Re: Req: Array Tags Explained, simple and clear

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55149
interpreted = N
texte = On 1/1/04 10:33 PM, "Palle Bo Nielsen" wrote: > In stead I can tell you that my Forum area build using WebDNA today > contains more than 50.000 entries and every time a page is shown, the > total database i searched at least once. After the search, there is a > lot of LookUps and Showif/Hideif and If/then/else context. The result > is, that it takes some time for the pages to build on user requests and > maybe I can optimize the code using the new functionality in WebDNA > 5.x, like Array e.g. >=20 > So, you are able to put data into the arrays, which is fine and you can > get the data out of the Arrays using loops and showif/hideif context to > filter etc. But is method really the right choice when handling tens of > thousands of records who have to be sorted and filtered etc. ? I think point is more that you have a db that has a lot of records in it, and Array or table or whatever cool function there is in WebDNA will not make it any faster, until you move some data out of the original source db. We have had something similar and came up with putting some data, which is rarely needed, in separate db's. Made our searches trough 500000 records much faster. Just a thought:-) Nitai -- Redakto - Content Management that simply works ComputerOil=AE GmbH Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.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: Req: Array Tags Explained, simple and clear ( Donovan Brooke 2004)
  2. Re: Req: Array Tags Explained, simple and clear ( Donovan Brooke 2004)
  3. Re: Req: Array Tags Explained, simple and clear ( "Nitai @ ComputerOil" 2004)
  4. Re: Req: Array Tags Explained, simple and clear ( Palle Bo Nielsen 2004)
  5. Re: Req: Array Tags Explained, simple and clear ( Palle Bo Nielsen 2004)
  6. Re: Req: Array Tags Explained, simple and clear ( "Nitai @ ComputerOil" 2004)
  7. Re: Req: Array Tags Explained, simple and clear ( "Nitai @ ComputerOil" 2004)
  8. Re: Req: Array Tags Explained, simple and clear ( Donovan Brooke 2004)
  9. Re: Req: Array Tags Explained, simple and clear ( Marc Kaiwi 2004)
  10. Re: Req: Array Tags Explained, simple and clear ( Palle Bo Nielsen 2004)
  11. Re: Req: Array Tags Explained, simple and clear ( Marc Kaiwi 2003)
  12. Re: Req: Array Tags Explained, simple and clear ( "Nitai @ ComputerOil" 2003)
  13. Re: Req: Array Tags Explained, simple and clear ( Palle Bo Nielsen 2003)
  14. Re: Req: Array Tags Explained, simple and clear ( "Scott Anderson" 2003)
  15. Re: Req: Array Tags Explained, simple and clear ( Palle Bo Nielsen 2003)
  16. Re: Req: Array Tags Explained, simple and clear ( Phillip Bonesteele 2003)
  17. Re: Req: Array Tags Explained, simple and clear ( Donovan Brooke 2003)
  18. Req: Array Tags Explained, simple and clear ( Palle Bo Nielsen 2003)
On 1/1/04 10:33 PM, "Palle Bo Nielsen" wrote: > In stead I can tell you that my Forum area build using WebDNA today > contains more than 50.000 entries and every time a page is shown, the > total database i searched at least once. After the search, there is a > lot of LookUps and Showif/Hideif and If/then/else context. The result > is, that it takes some time for the pages to build on user requests and > maybe I can optimize the code using the new functionality in WebDNA > 5.x, like Array e.g. >=20 > So, you are able to put data into the arrays, which is fine and you can > get the data out of the Arrays using loops and showif/hideif context to > filter etc. But is method really the right choice when handling tens of > thousands of records who have to be sorted and filtered etc. ? I think point is more that you have a db that has a lot of records in it, and Array or table or whatever cool function there is in WebDNA will not make it any faster, until you move some data out of the original source db. We have had something similar and came up with putting some data, which is rarely needed, in separate db's. Made our searches trough 500000 records much faster. Just a thought:-) Nitai -- Redakto - Content Management that simply works ComputerOil=AE GmbH Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.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/ "Nitai @ ComputerOil"

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:

Not really WebCat (1997) all records returned. (1997) Webcatalog server support (1997) Drop Down Menus (2002) forming a SKU (1999) [dos] command question (1997) Updating fields from different platforms (1998) WebCat2b13MacPlugIn - [include] (1997) SSL Certificates (2004) Database of Tax Rates? (1997) read and write you own cookies with webcat (1997) Re:Searching for ALL / empty form field (1997) WebCatalog for Postcards ? (1997) [WebDNA] RESTART WebDNA (2016) WebCat2b12 CGI Mac -- Problems propagating the cart through (1997) Nested tags count question (1997) multi-paragraph fields (1997) Setting up the server (1997) How to add product size choices to form? (1997) Installing on IIS 5.1 Windows XP Pro - Username/Password (2006)