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:

Using Plug-In while running 1.6.1 (1997) Time Display from Database (1997) WebCatalog not running after upgrade (2000) Emailer update for Mac? (1998) Formvariable won't update (1999) Trouble Searching (1999) Typhoon Rev. and PCS store problems (1999) Error with [applescript] (1999) WebCat editing, SiteGuard & SiteEdit (1997) how to determine the actual file format of an image file? (2002) multiple replace sku data (2003) Re:[ShowIf] and empty fields (1997) [WebDNA] WebDNA Sciprt for Zipping files? (2012) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Searching multiple fields from one form field (1997) Trouble with formula.db + more explanation (1997) decrypt - encrypt (1999) Online reference (1997) UPDATE PROBLEM (1997) Interactive Online Docs Was: [OT] Mozilla | Was: R.I.P. (2003)