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:
Seeking Better Display of results... (1997)
email address with spaces (2001)
Interesting speed comparison .. (2003)
Force a search at the default.tmpl page? (1997)
Viewing Changes (1998)
PayFlowPro (2003)
[OT] Mozilla | Was: R.I.P. Netscape (2003)
[group] ? (1997)
Using [showif] (2000)
The beginning (1997)
Sending emails (2002)
Date Range search (1997)
# fields limited? (1997)
Shared conversion under WebTen (1998)
WebCat2.0 [format thousands .0f] no go (1997)
Help with update to 2.11 (1998)
PCS Emailer's role ? (1997)
RE: Ongoing group search problems ... (1997)
Emailer error codes (1999)
WebCommerce: Folder organization ? (1997)