Re: search vs lookup
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17805
interpreted = N
texte = >So far I know database searches are very fast when they perform an indexed search and return just one record.>The WebCat manual claims to use Lookup to get just one field, and it is really fast.>But what is generally faster when I need 2 or 3 fields of one record?>How with small databases (10 records, 5 fields)>How with bigger databases (1000 records, 20 fields)Grant told me that single lookups are fast compared to single searches, but when you need more than a couple of fields, you're better off using a search.Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>So far I know database searches are very fast when they perform an indexed search and return just one record.>The WebCat manual claims to use Lookup to get just one field, and it is really fast.>But what is generally faster when I need 2 or 3 fields of one record?>How with small databases (10 records, 5 fields)>How with bigger databases (1000 records, 20 fields)Grant told me that single lookups are fast compared to single searches, but when you need more than a couple of fields, you're better off using a search.Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://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:
Page Counters? (1997)
emailer on Windows Beta 18 (1997)
WebCat2: Formulas.db question (1997)
Here's how to kill a Butler Database. (1997)
Odd [math] behavior (2003)
2nd WebCatalog2 Feature Request (1996)
Showif date > other date (2004)
[WebDNA] WebDNA Crashing or Not (2008)
Proper file locations (1997)
Frustration with formulas.db (1999)
IP address & domain name problem (2003)
orderfile headers (was: 2nd Request for help/adviceonvariable pricing) (2000)
WC2b15 File Corruption (1997)
Setting up shop (1997)
WebCat2 several catalogs? (1997)
[WebDNA] Dynamic JSON Problem (2020)
Looking for WebCatalog Programmer in Silicon Valley (1998)
Date Math bug (1998)
ShowIf variables (1997)
[WebDNA] [redirect] include a value to pass along? (2010)