Re: [lookup] vs. [search]
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16532
interpreted = N
texte = >>Grant, what would you guess is the break-even point, in terms of speed and/or processing demands, between using a series of lookups and using a search context?>>I'd have to guess 2-3 at most, statistically speaking (for instance, if the lookup finds the item in record 1 of 1,000,000 it will stop looking immediately). If you set your search to case-sensitive and use eqFIELDNAMEdata, then it's extremely close to the speed of lookup.>>You can test for yourself using [elapsedtime] to see which is better with your particular data.Thanks, your guess is plenty good enough for me ... :)Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>>Grant, what would you guess is the break-even point, in terms of speed and/or processing demands, between using a series of lookups and using a search context?>>I'd have to guess 2-3 at most, statistically speaking (for instance, if the lookup finds the item in record 1 of 1,000,000 it will stop looking immediately). If you set your search to case-sensitive and use eqFIELDNAMEdata, then it's extremely close to the speed of lookup.>>You can test for yourself using
[elapsedtime] to see which is better with your particular data.Thanks, your guess is plenty good enough for me ... :)Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
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:
Help! WebCat2 bug (1997)
ASP and WebDNA (1998)
Newbie Tax Question (1997)
I'm tired of all this! (2000)
Re:multiple digests, please stop (1997)
[isfile] ? (1997)
[WebDNA] Ubuntu 18.04.2 ??? (2019)
I give up!! (1997)
WebCat on 10.0.4 - iTools 6.0 (2001)
Squares instead of spaces (2001)
Frames and WebCat (1997)
[WebDNA] Emailer breaking format (2015)
WebCatalog2 Feature Feedback (1996)
founditems / writefile (2005)
Code database (1998)
List archive status? (1999)
Threaded Discussion (1998)
Documentation Feedback (1997)
Sorting error (1997)
Webmerchant (1999)