Re: [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...)

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 103046
interpreted = N
texte = Grant once said a single search takes as long as about three lookups, but he probably said that a decade ago. After seeing Christophe's test results it appears this relationship may no longer apply. Sincerely, Ken Grome > I know this is a difficult question but is it possible to > give a rough estimate of *how* much faster a lookup is? > > I mean, if I need the values of two fields in a database, > would a search or two consecutive lookpus be my best bet? Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (christophe.billiottet@webdna.us 2009)
  2. Re: [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (Kenneth Grome 2009)
  3. Re: [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (christophe.billiottet@webdna.us 2009)
  4. [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (Frank Nordberg 2009)
Grant once said a single search takes as long as about three lookups, but he probably said that a decade ago. After seeing Christophe's test results it appears this relationship may no longer apply. Sincerely, Ken Grome > I know this is a difficult question but is it possible to > give a rough estimate of *how* much faster a lookup is? > > I mean, if I need the values of two fields in a database, > would a search or two consecutive lookpus be my best bet? 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:

WEBCAT with SQL backend. Help please! (2000) Hierarchy of form/text/math variables (2000) Losing file paths? (1999) [OT] Who's got a cool link (2002) Forms (1998) Explorer 3.0 (1997) Extra carriage returns (1999) WebCat2b12 Mac.acgi--[searchstring] bug (1997) mime types (2003) WC 3.0.1 Mac days_to_date (1998) MAC versions of WebCatalog 2.1 and WebMerchant 2.1 (1998) Bug or syntax error on my part? (1997) Autonumber (2003) searching by date (1998) [/application] error? (1997) [WebDNA] [SEEK] (2013) [SearchString] problem with [search] context (1997) supressing math results (1997) writing cart to db (1998) Checking for blank form fields (sort of...) (1998)