Re: Table code broken?
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 60393
interpreted = N
texte = Just FYI...In the case where you find yourself needing to generating several temporarydatabases, you may want to take a look at your WebDNA 'CacheSizePrefs' file(introduced in WebDNA 4.5.1). WebDNA uses the settings in this file to setthe size of the database and template caches, when starting up. The 'stock'settings are:DatabasesCacheSize100TemplatesCacheSize100This file is located in the WebCatalogEngine folder. The WebDNA processmust be restarted for the changes to take effect.Given the increasing amounts of RAM installed on servers these days, you canprobably bump up the DatabasesCacheSize setting. This should reduce theamount of db swapping that WebDNA will be doing if the number of opendatabases frequently reaches the cache size limit. Be careful whenincreasing these values, as WebDNA does not currently handle the case wherethe increased number of databases does not fit in available RAM. Perhapsstart at 150, then 175, and so on. If you find several error log entrieswhere WebDNA failed to open a db due to lack of available RAM, then backdown the cache size.-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Ofdevaulw@onebox.comSent: Wednesday, December 08, 2004 12:41 PMTo: WebDNA TalkSubject: Re: Table code broken?Thanks for looking into this - I was pulling my hair out at 3am on this one.I was looking for a workaround to a temp database. I wanted to avoid diskwrites and the possiblity of two people creating the same temp database asthe same time.Perhaps I will keep tables for working sets of search results and rename thetemp database to a cart name. There still is possibility of many db's openat the same time.Eventually I will move data to a permanent database, but WebDNA is so fastat creating these db's on the fly...Bill-----Original Message-----From: Scott Anderson
Sent: Wed, 8 Dec 2004 12:17:37 -0800To: "WebDNA Talk" Subject: Re: Table code broken?There is no intentional limitation on table size. Available memory shouldbe the only factor in limiting a table size. I'll take a closer look at thecode to see if any other conditions exists that may limit the number ofrecords a table can hold.On a side note: The table context was created as a convenient way ofstoring and manipulating smaller sets of data. Although storing thousandsof records in a table should not be a problem, this can become quite taxingon your system resources if several request threads are creating multipleinstances of large tables. In addition to all the WebDNA databases that arealready cached in RAM, each WebDNA request thread maintains its own list oftable objects. There currently is no way to 'share' a table resourcebetween threads.-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Ofdevaulw@onebox.comSent: Wednesday, December 08, 2004 11:30 AMTo: WebDNA TalkSubject: Re: Table code broken?OK, these are identical in structure except for the directory or the numberof dates. I assure you that there is a /Orders/ path on this server (withfewer than 10k order files in it). If I limit the number of entries to thetable by restricting the date (SET 2 below), the problem disappears for the/Orders/ folder. See the three sets of code below for what works/whatdoesn't.Is there a limit to either the number of entries in a table or the size of atable? There's no limit mentioned in the docs and there should be plenty ofroom to handle this on the server.Thanks,BillSET 1 THIS WORKS:[table name=tab&fields=ONO,DACR][/table][listfiles path=/][appendtable=tab]ONO=[url][filename][/url]&DACR=[url][moddate][/url][/append][/listfiles][search table=tab&neDACRdatarq=[blank]][founditems][ONO] [DACR]
[/founditems][/search]SET 2 THIS DATE RESTRICTED VERSION WORKS:[table name=tab&fields=ONO,DACR][/table][listfiles path=/Orders][showif [math]{[moddate]}[/math]>[math]{[date]}-30[/math]][appendtable=tab]ONO=[url][filename][/url]&DACR=[url][moddate][/url][/append][/showif][/listfiles]SET 3 THIS UNRESTRICTED VERSION SHOWS NOTHING![table name=tab&fields=ONO,DACR][/table][listfiles path=/Orders/][appendtable=tab]ONO=[url][filename][/url]&DACR=[url][moddate][/url][/append][/listfiles]-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail toWeb Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail toWeb Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail toWeb Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Just FYI...In the case where you find yourself needing to generating several temporarydatabases, you may want to take a look at your WebDNA 'CacheSizePrefs' file(introduced in WebDNA 4.5.1). WebDNA uses the settings in this file to setthe size of the database and template caches, when starting up. The 'stock'settings are:DatabasesCacheSize100TemplatesCacheSize100This file is located in the WebCatalogEngine folder. The WebDNA processmust be restarted for the changes to take effect.Given the increasing amounts of RAM installed on servers these days, you canprobably bump up the DatabasesCacheSize setting. This should reduce theamount of db swapping that WebDNA will be doing if the number of opendatabases frequently reaches the cache size limit. Be careful whenincreasing these values, as WebDNA does not currently handle the case wherethe increased number of databases does not fit in available RAM. Perhapsstart at 150, then 175, and so on. If you find several error log entrieswhere WebDNA failed to open a db due to lack of available RAM, then backdown the cache size.-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Ofdevaulw@onebox.comSent: Wednesday, December 08, 2004 12:41 PMTo: WebDNA TalkSubject: Re: Table code broken?Thanks for looking into this - I was pulling my hair out at 3am on this one.I was looking for a workaround to a temp database. I wanted to avoid diskwrites and the possiblity of two people creating the same temp database asthe same time.Perhaps I will keep tables for working sets of search results and rename thetemp database to a cart name. There still is possibility of many db's openat the same time.Eventually I will move data to a permanent database, but WebDNA is so fastat creating these db's on the fly...Bill-----Original Message-----From: Scott Anderson Sent: Wed, 8 Dec 2004 12:17:37 -0800To: "WebDNA Talk" Subject: Re: Table code broken?There is no intentional limitation on table size. Available memory shouldbe the only factor in limiting a table size. I'll take a closer look at thecode to see if any other conditions exists that may limit the number ofrecords a table can hold.On a side note: The table context was created as a convenient way ofstoring and manipulating smaller sets of data. Although storing thousandsof records in a table should not be a problem, this can become quite taxingon your system resources if several request threads are creating multipleinstances of large tables. In addition to all the WebDNA databases that arealready cached in RAM, each WebDNA request thread maintains its own list oftable objects. There currently is no way to 'share' a table resourcebetween threads.-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Ofdevaulw@onebox.comSent: Wednesday, December 08, 2004 11:30 AMTo: WebDNA TalkSubject: Re: Table code broken?OK, these are identical in structure except for the directory or the numberof dates. I assure you that there is a /Orders/ path on this server (withfewer than 10k order files in it). If I limit the number of entries to thetable by restricting the date (SET 2 below), the problem disappears for the/Orders/ folder. See the three sets of code below for what works/whatdoesn't.Is there a limit to either the number of entries in a table or the size of atable? There's no limit mentioned in the docs and there should be plenty ofroom to handle this on the server.Thanks,BillSET 1 THIS WORKS:[table name=tab&fields=ONO,DACR][/table][listfiles path=/][appendtable=tab]ONO=[url][filename][/url]&DACR=[url][moddate][/url][/append][/listfiles][search table=tab&neDACRdatarq=[blank]][founditems][ONO] [DACR]
[/founditems][/search]SET 2 THIS DATE RESTRICTED VERSION WORKS:[table name=tab&fields=ONO,DACR][/table][listfiles path=/Orders][showif [math]{[moddate]}[/math]>[math]{[date]}-30[/math]][appendtable=tab]ONO=[url][filename][/url]&DACR=[url][moddate][/url][/append][/showif][/listfiles]SET 3 THIS UNRESTRICTED VERSION SHOWS NOTHING![table name=tab&fields=ONO,DACR][/table][listfiles path=/Orders/][appendtable=tab]ONO=[url][filename][/url]&DACR=[url][moddate][/url][/append][/listfiles]-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail toWeb Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail toWeb Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail toWeb Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
"Scott Anderson"
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[WebDNA] a major shift in strategy? (2008)
Need help... (1997)
'page impression' techniques for banner ads (1999)
WebCat2 beta 11 - new prefs ... (1997)
[WebDNA] Auto Expansion of .zip (2009)
Summing fields (1997)
WebCat2 - [format thousands] (1997)
Help! WebCat2 bug (1997)
Severe Slowness (2005)
Search/sort in URL Was: GuestBook example (1997)
Shhh, very quiet. (2006)
Database wiped clean (2005)
Variable security (2000)
[HIDEIF] inside [FOUNDITEM] (1997)
Unexpected error (1997)
WebDelivery downloads alias, not original ? (1997)
Bug or syntax error on my part? (1997)
WebMerchant and AVS (1998)
WebCat2 Append problem (B14Macacgi) (1997)
Signal Raised Error (1997)