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:
Using Plug-In while running 1.6.1 (1997)
Most Recent version of WebDNA For RH ES (2006)
OFF-TOPIC: Free webdna.net email addresses ... (2003)
Frames and WebCat (1997)
Text vs. Math (2000)
Orderfile (2005)
[WebDNA] Ubuntu 14.04 & WebDNA (2017)
Error Lob.db records error message not name (1997)
Re:HTTP header line is too long? (1997)
WebCat 3? (2000)
A dynamic database. (1997)
Documentation Feedback (1997)
Wireless WebDNA available today! (2000)
WebCat2b13MacPlugIn - More limits on [include] (1997)
How can I record purchases to a database? (1998)
Emailer (WebCat2) (1997)
Search design (1997)
[URGENT] Different Results From Math Tag Depending On OS (2006)
State Coalition Approves Internet Sales Tax Plan (2002)
sku not found (1997)