Re: How many lookups does it take ...
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 51918
interpreted = N
texte = If your search is like this: [search db=your.db&eqIDdata=10&allcase=T&rank=off] then the search is practically as fast as a single lookup. If you need to be case-insensitive or use XXXtype=num or XXXtype=date or any comparison other than eq or sort the results, then the search slows down based on the amount of work it needs to do. - brian On Thursday, July 24, 2003, at 03:57 PM, WebDna @ wrote: > ... to get to the center of a search? > > We need to get the following information for user with the ID = 10 > > [FirstName] > [LastName] > [DateOfBirth] > [Phone] > [Address] > [City] > etc > > Is it faster to do Lookups since we know the ID or a single search? I > know > lookup is faster than search but when does it make more sense to do a > search? After 5 lookups? 10? 20? > > What do you think? > > Ron ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
If your search is like this: [search db=your.db&eqIDdata=10&allcase=T&rank=off] then the search is practically as fast as a single lookup. If you need to be case-insensitive or use XXXtype=num or XXXtype=date or any comparison other than eq or sort the results, then the search slows down based on the amount of work it needs to do. - brian On Thursday, July 24, 2003, at 03:57 PM, WebDna @ wrote: > ... to get to the center of a search? > > We need to get the following information for user with the ID = 10 > > [FirstName] > [LastName] > [DateOfBirth] > [Phone] > [Address] > [City] > etc > > Is it faster to do Lookups since we know the ID or a single search? I > know > lookup is faster than search but when does it make more sense to do a > search? After 5 lookups? 10? 20? > > What do you think? > > Ron ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Brian Fries
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:
Search Question (2000)
show all problem (1997)
Purchased cart being overwritten (1997)
[format] (1998)
archives down? (2002)
Sort Order on a page search (1997)
Formatting time output (2000)
WebCat2 - many [carts] on one template page? (1997)
Search/sort in URL Was: GuestBook example (1997)
back button loses cart (2000)
RE: PDF (1999)
Followup question re: checksum for credit cards? (1997)
InternetWeek E-Commerce article (1998)
Exclamation point (1997)
[index] (1997)
proper way to check if a container is empty? (2000)
add to cart within a page? (1997)
How do I get Google to crawl a WebCat site? (2003)
webcat/webmerchant docs (1997)
[searchString] (1997)