Re: Table code broken?

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 60389
interpreted = N
texte = 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 disk writes and the possiblity of two people creating the same temp database as the same time. Perhaps I will keep tables for working sets of search results and rename the temp database to a cart name. There still is possibility of many db's open at the same time. Eventually I will move data to a permanent database, but WebDNA is so fast at creating these db's on the fly... Bill -----Original Message----- From: Scott Anderson Sent: Wed, 8 Dec 2004 12:17:37 -0800 To: "WebDNA Talk" Subject: Re: Table code broken? 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/ ------------------------------------------------------------- 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)
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 disk writes and the possiblity of two people creating the same temp database as the same time. Perhaps I will keep tables for working sets of search results and rename the temp database to a cart name. There still is possibility of many db's open at the same time. Eventually I will move data to a permanent database, but WebDNA is so fast at creating these db's on the fly... Bill -----Original Message----- From: Scott Anderson Sent: Wed, 8 Dec 2004 12:17:37 -0800 To: "WebDNA Talk" Subject: Re: Table code broken? 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/ ------------------------------------------------------------- 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/ devaulw@onebox.com

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:

problems with 2 tags (1997) WebCatalog 2.0 & WebDNA docs in HTML ... (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) Is setting a basic lineitem in the cart really magic? (2000) Simple Store (2000) [WebDNA] Sorry WebDNA server not running (2014) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) A few questions. . . (1997) NEWBIE ? help with link (1998) [index] (1997) ERASING DATABASE (1997) WebCat2 - Getting to the browser's username/password data (1997) Database Options (1997) &fieldsdir=ra truely random?? (2000) WebCat2b12 CGI Mac - [shownext] problem (1997) Wrapping text (1998) WebCat b15 Mac plug-in (1997) Quickie question on the email templates (1997) Snake Bites (1997) Help with database strategy (1998)