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:
Exchange rates (2000)
Using Plug-In while running 1.6.1 (1997)
How do I make this faster???? (2000)
Now when I send TeaRoom Order fields it does not post in Invoice. (1997)
Country & Ship-to address & other fields ? (1997)
[WebDNA] Need to convert unix date? (2009)
Log-in Scheme (2003)
Safari browser and WebDNA set-cookies (2003)
WebCat2 several catalogs? (1997)
Problem getting shipping to calculate (2003)
Auto entering Friday's date in a field (2002)
Keeping text formatting (like hard returns) (2002)
Search/sort in URL Was: GuestBook example (1997)
Bug Report, maybe (1997)
Where's Cart Created ? (1997)
[WebDNA] Silly question (2009)
SET (1998)
Date search - yes or no (1997)
Pithy questions on webcommerce & siteedit (1997)
Alphonse MacDonald/DC/IPSW is out of the office. (2003)