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:

    
  1. Re: Table code broken? ( Stuart Tremain 2004)
  2. Re: Table code broken? ( "Scott Anderson" 2004)
  3. Re: Table code broken? ( Stuart Tremain 2004)
  4. Re: Table code broken? ( "Scott Anderson" 2004)
  5. Re: Table code broken? ( devaulw@onebox.com 2004)
  6. Re: Table code broken? ( "Scott Anderson" 2004)
  7. Re: Table code broken? ( devaulw@onebox.com 2004)
  8. Re: Table code broken? ( "Scott Anderson" 2004)
  9. Re: Table code broken? ( "Scott Anderson" 2004)
  10. Re: Table code broken? ( Larry Hewitt 2004)
  11. Re: Table code broken? ( devaulw@onebox.com 2004)
  12. Re: Table code broken? ( devaulw@onebox.com 2004)
  13. Re: Table code broken? ( Brian Fries 2004)
  14. Table code broken? ( devaulw@onebox.com 2004)
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:

image magick (2003) linetiems in thankyou.tpl (1997) hidden databases (2000) WebCat2 - Getting to the browser's username/password data (1997) Sensations (1997) Location of Browser Info.txt file (1997) shownext (2000) Need help with emailer- 2 issues (1997) NT Setup (1998) request for comment tag (1998) Milliseconds (1998) no global [username] or [password] displayed ... (1997) Using Plug-In while running 1.6.1 (1997) When do we get to request new features? (1999) OFF-TOPIC: Check www.godaddy.com for me ... (2003) problems with 2 tags shakur (1997) File Upload (1997) WC2b15 File Corruption (1997) WebCatalog.acgi quitting with error Type 2 (1998) Starting WebCat under linux (2000)