Re: How many lookups does it take ...
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 51921
interpreted = N
texte = This is fairly straight shooting. if I needed sorting or anything other than specific data I would use the search. I would rather not add the data into some array style variabling system and sorting through. ----- Original Message ----- From: "Brian Fries"
To: "WebDNA Talk" Sent: Thursday, July 24, 2003 3:58 PM Subject: Re: How many lookups does it take ... > 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/ ------------------------------------------------------------- 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:
This is fairly straight shooting. if I needed sorting or anything other than specific data I would use the search. I would rather not add the data into some array style variabling system and sorting through. ----- Original Message ----- From: "Brian Fries" To: "WebDNA Talk" Sent: Thursday, July 24, 2003 3:58 PM Subject: Re: How many lookups does it take ... > 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/ ------------------------------------------------------------- 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/
"WebDna @"
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:
Anyone using unix? Having problems... (2000)
WebCat b13 CGI -shownext- (1997)
Am I going senile? (Price recalc based on quantity) (1997)
WC TableGrinder (1997)
Single Link browsing (1997)
Re:HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997)
Protect (1997)
CC: (1998)
Part 2 - [showif] if variable exists (1998)
Re:2nd WebCatalog2 Feature Request (1996)
Replace Statement (1997)
How to Sort Summ data ? (1997)
Extracting URL (2007)
Smith Micro - no competition (2000)
How do you TEAM Code? (2004)
[WebDNA] writing pdfs on the fly (Avery labels #5160) (2010)
[HIDEIF] inside [FOUNDITEM] (1997)
Squares instead of spaces (2001)
Too Much Rootbeer Free Offer (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)