What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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:

    
  1. Re: How many lookups does it take ... ( "WebDna @" 2003)
  2. Re: How many lookups does it take ... ( Tim Robinson 2003)
  3. Re: How many lookups does it take ... ( "WebDna @" 2003)
  4. Re: How many lookups does it take ... ( "WebDna @" 2003)
  5. Re: How many lookups does it take ... ( Glenn Busbin 2003)
  6. Re: How many lookups does it take ... ( Bob Minor 2003)
  7. Re: How many lookups does it take ... ( Brian Fries 2003)
  8. Re: How many lookups does it take ... ( "WebDna @" 2003)
  9. How many lookups does it take ... ( "WebDna @" 2003)
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:

RE: Problems with dbcatalog.exe (1997) docs for WebCatalog2 (1997) [include] affect on filepaths for links? (1997) shownext problems (1998) RE: Languages (1997) Announcing general availabilty of WebDNA 4.5 release (2002) Logging purchases (1997) when is date system date or order date? (1997) Email (1998) :Programmer: Looking for work (2002) Word wrapping (1997) Two submit buttons ? (1997) Is the time limited demo still available? (2002) Great product and great job ! (1997) [WebDNA] An unknown error occured // Deadlock avoided (2011) SPAM (OT) (2004) Performance Issue (2000) WebCatalog on Windows 98 (2000) tracking variables across a site... (2000) Problems with [Search] param - Mac Plugin b15 (1997)