Re: [lookup] vs. [search]

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 16529
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.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ 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.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Grant Hulbert

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:

WCS Newbie question (1997) Weird error/limit - something amiss? (1997) Extra Text Fields (was Another question) (1997) RE: Missing contexts on NT (1997) E-Mail (1998) WebCat2: Items xx to xx shown, etc. (1997) OT: Forcing a header when printing web pages (2002) Re:PCS Customer submissions ? (1997) Emailer setup (1997) pop up building with summarize (1998) [WebDNA] Displaying age (2010) [Announce]: Web server security and password protection (1997) 2 field showif/hideif's (2002) RE: Emailer Set Up (1997) Forbidden CGI Error (1997) NetSplat and WebCat2 (1997) [RemoveHTML] removing JavaScript ?? (2008) PCS Emailer's role ? (1997) Adding Message to Order (1997) Number of files in a directory (2006)