Re: Table code broken?
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 60387
interpreted = N
texte = There is no intentional limitation on table size. Available memory should be the only factor in limiting a table size. I'll take a closer look at the code to see if any other conditions exists that may limit the number of records a table can hold. On a side note: The table context was created as a convenient way of storing and manipulating smaller sets of data. Although storing thousands of records in a table should not be a problem, this can become quite taxing on your system resources if several request threads are creating multiple instances of large tables. In addition to all the WebDNA databases that are already cached in RAM, each WebDNA request thread maintains its own list of table objects. There currently is no way to 'share' a table resource between threads. -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of devaulw@onebox.com Sent: Wednesday, December 08, 2004 11:30 AM To: WebDNA Talk Subject: Re: Table code broken? OK, these are identical in structure except for the directory or the number of dates. I assure you that there is a /Orders/ path on this server (with fewer than 10k order files in it). If I limit the number of entries to the table by restricting the date (SET 2 below), the problem disappears for the /Orders/ folder. See the three sets of code below for what works/what doesn't. Is there a limit to either the number of entries in a table or the size of a table? There's no limit mentioned in the docs and there should be plenty of room to handle this on the server. Thanks, Bill SET 1 THIS WORKS: [table name=tab&fields=ONO,DACR][/table] [listfiles path=/] [append table=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]] [append table=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/] [append table=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 to Web 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:
There is no intentional limitation on table size. Available memory should be the only factor in limiting a table size. I'll take a closer look at the code to see if any other conditions exists that may limit the number of records a table can hold. On a side note: The table context was created as a convenient way of storing and manipulating smaller sets of data. Although storing thousands of records in a table should not be a problem, this can become quite taxing on your system resources if several request threads are creating multiple instances of large tables. In addition to all the WebDNA databases that are already cached in RAM, each WebDNA request thread maintains its own list of table objects. There currently is no way to 'share' a table resource between threads. -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of devaulw@onebox.com Sent: Wednesday, December 08, 2004 11:30 AM To: WebDNA Talk Subject: Re: Table code broken? OK, these are identical in structure except for the directory or the number of dates. I assure you that there is a /Orders/ path on this server (with fewer than 10k order files in it). If I limit the number of entries to the table by restricting the date (SET 2 below), the problem disappears for the /Orders/ folder. See the three sets of code below for what works/what doesn't. Is there a limit to either the number of entries in a table or the size of a table? There's no limit mentioned in the docs and there should be plenty of room to handle this on the server. Thanks, Bill SET 1 THIS WORKS: [table name=tab&fields=ONO,DACR][/table] [listfiles path=/] [append table=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]] [append table=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/] [append table=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 to Web 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:
WebCatalog f2 Installation (1997)
Bug or syntax error on my part? (1997)
Suggestions on best way to work with yyyy/mm/dd (1997)
Webcat 2.0.1 date math bug -> Crash! (1997)
problems with 2 tags shakur (1997)
Webcat deletes last line from Excel-saved text db (2004)
Nesting FoundItem Context (1997)
Stats (2004)
show all problem (1997)
listfile options (1997)
PSC recommends what date format yr 2000??? (1997)
WebDNA tables and commas - the fix (2004)
Loss in Form (1998)
Add htmlarea 3 to SiteBuilder (2004)
wierd [cart] action! (1997)
Preventing code execution (2003)
Separate SSL Server (1997)
Only charge card when product shipped ? (1997)
sorting problem for sku=0? (1998)
Multiple prices (1997)