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:
Webcat listserver - WAS - webcat method for waiting specific amount of time? (2000)
[TaxableTotal] - not working with AOL and IE (1997)
[WebDNA] [OT] the "Work in progress" thread. (2009)
Thanks Grant (1997)
Wireless WebDNA available today! (2000)
SMSI FTP - calander system THANKS! (2002)
Help with update to 2.11 (1998)
Almost a there but..bye bye NetCloak (1997)
Setting up shop (1997)
[WebDNA] "sem_open" bug (2012)
problem: type 2 errors (1997)
showifs (1999)
[WebDNA] setcookie in IE11 (2014)
hmmm (2006)
WebCatalog Hosting (1996)
re:check boxes (1997)
Search in 2 or more catalogs (1997)
[WriteFile] problems (1997)
Dummy Credit Card Number for debug? (1997)
convert characters (2003)