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 Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://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 Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://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:
Permissions Ignored - PLEASE HELP (2003)
Still search problems! (1999)
Problems getting parameters passed into email. (1997)
Secure Server (1997)
WebCatalog stalls (1998)
Please please help (2001)
Separate SSL Server (1997)
Showing formatted results in tables (2002)
WebCat2.0 acgi vs plugin (1997)
Attn: Bug in GeneralStore example b15 (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Emailer (1998)
Announce: Bug fix talk list (1999)
quit command on NT (1997)
Order file numbers different than the cart number. why? (2000)
snicker, snicker (1997)
RE: Can a database get stomped by simultaneous access? (1997)
Running 2 two WebCatalog.acgi's (1996)
SUBMIT buttons not working.... (2000)
"Advanced" Search Algorithm (2008)