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 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
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.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 | Typhoon619/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:
Stopping bad HTML propagation ? (1997)
SSL and WebCatalog (1997)
[WebDNA] Need someone to port CakePHP auction site to WebDNA (2010)
Show shoppingcart after remove last item (1997)
Applescript error (1998)
# of real domains on 1 web server (1997)
billing system (2003)
Trouble with formula.db (1997)
Am I going senile? (Price recalc based on quantity) (1997)
Every other record deleted (2005)
WebDNA5 & Tiger (2006)
mod_webcatalog2.so.2-40 is garbled (2008)
SEARCH RESULTS (1998)
Paypal merchant code tricks or pitfalls (2003)
FW: It gets better... posting problems + Webcat 3.0.7 avail able - did anyone know? (2000)
WebCommerce: Folder organization ? (1997)
suffix mapping for NT? (1997)
Sense/Disallow HTML tags during $Append (1997)
math problems (2000)
Logging purchases (1997)