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:

    
  1. Re: [lookup] vs. [search] (Kenneth Grome 1998)
  2. Re: [lookup] vs. [search] (Grant Hulbert 1998)
  3. [lookup] vs. [search] (Kenneth Grome 1998)
>>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:

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)