Re: [WebDNA] max number of searches and lookups on a page
This WebDNA talk-list message is from 2016
It keeps the original formatting.
numero = 112749
interpreted = N
texte = 332Grant once told me that doing three lookups takes about the sameamount of resources as a single search ... so if you're doingthree or more lookups in a single db record you're actually betteroff replacing them with a single search.I seldom use lookups because I typically need data from more thanone field anyways. And it's not possible to use lookups when thevalue you're seeking might not be an exact (case sensitive) match,so this is another limitation of lookups that encourage me to usesearches more often.I avoid nested contexts as much as possible too, because the morenesting you employ the more resources are used. Sometimes thingscan get pretty slow when nesting too much ... :(I generally prefer to avoid nesting by putting my search contextsat the top of the page, then setting the values I need from thefounditems context as text vars. This allows me to start and endmy search without nesting any other contexts inside. Then when Iactually need the db values from the founditems context further ondown the page, they are all available as text variables.I use text variables extensively and have never had a problemsetting hundreds or even thousands on a page. I think the use oftext variables to avoid nested contexts, and using searches toavoid multiple lookups, makes good sense.Regards,Kenneth GromeWebDNA Solutionshttp://www.webdnasolutions.comWeb Database Systems and Linux Server AdministrationOn 04/30/2016 07:40 AM, Richard Kwasniewski wrote:> Just curious.> > Whats the most lookups and/or searches you've even had on a page.> > I have a page being worked on that seems to have way tooo many of> both so I'm slimming things down with text variables. Seems clunky> the way I have it setup now.> > Currently there 14 searches and 57 lookups or so. I can slim that> down to 7 searches, probably no fewer than that, the number of> lookups I'm just starting to slim down.... > > I believe the docs also said the number of text variables is> dependent on available ram.> > Is it bad to have a whole of text variables on a page?> > I'm guessing if this one page is accessed by many people at once> then all those text variables in ram start to add up? That being> the case am I better off having more searches and/or lookups than> going the text variable route.---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list
.To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us.
Associated Messages, from the most recent to the oldest:
332Grant once told me that doing three lookups takes about the sameamount of resources as a single search ... so if you're doingthree or more lookups in a single db record you're actually betteroff replacing them with a single search.I seldom use lookups because I typically need data from more thanone field anyways. And it's not possible to use lookups when thevalue you're seeking might not be an exact (case sensitive) match,so this is another limitation of lookups that encourage me to usesearches more often.I avoid nested contexts as much as possible too, because the morenesting you employ the more resources are used. Sometimes thingscan get pretty slow when nesting too much ... :(I generally prefer to avoid nesting by putting my search contextsat the top of the page, then setting the values I need from thefounditems context as text vars. This allows me to start and endmy search without nesting any other contexts inside. Then when Iactually need the db values from the founditems context further ondown the page, they are all available as text variables.I use text variables extensively and have never had a problemsetting hundreds or even thousands on a page. I think the use oftext variables to avoid nested contexts, and using searches toavoid multiple lookups, makes good sense.Regards,Kenneth GromeWebDNA Solutionshttp://www.webdnasolutions.comWeb Database Systems and Linux Server AdministrationOn 04/30/2016 07:40 AM, Richard Kwasniewski wrote:> Just curious.> > Whats the most lookups and/or searches you've even had on a page.> > I have a page being worked on that seems to have way tooo many of> both so I'm slimming things down with text variables. Seems clunky> the way I have it setup now.> > Currently there 14 searches and 57 lookups or so. I can slim that> down to 7 searches, probably no fewer than that, the number of> lookups I'm just starting to slim down.... > > I believe the docs also said the number of text variables is> dependent on available ram.> > Is it bad to have a whole of text variables on a page?> > I'm guessing if this one page is accessed by many people at once> then all those text variables in ram start to add up? That being> the case am I better off having more searches and/or lookups than> going the text variable route.---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us.
Kenneth Grome
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:
Cookie setting (2003)
Netscape v. IE (1997)
Searchable WebCat (etc.) Docs ? (1997)
Emailer (1997)
Re:[off] Promotions Co? (1997)
[WebDNA] Sendmail BCC bug still exists (2015)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
Custom WebCat Prefs ... (1997)
Trouble with Showif and Search (1998)
RE: Nesting [ListFiles] (1998)
WebCatb15 Mac CGI -- [purchase] (1997)
PSC recommends what date format yr 2000??? (1997)
WebSite and *NO* Authentication Dialog Box!!? (1998)
searching within same page (2000)
searchable list archive (1997)
Kaaaaahhhhhhhnnnnnnn! (1997)
AUTONUMBER (2003)
WC Database Format (1997)
Help name our technology! (1997)
RE: [WebDNA] How to valuate a domain name? (2010)