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 = 103043
interpreted = N
texte = Based on my own test, i got > 40000 searches with > [lookup].......................................: 2 s > 10000 searches with > [search].......................................: 20 s which would make [lookup] roughly 40 times faster than [search] with 6.2. I noticed the difference was less dramatic using 6.0 - chris On Jul 28, 2009, at 10:40, Frank Nordberg wrote: > christophe.billiottet@webdna.us wrote: > > ... >> Since [lookup] is extremely fast compared to [search] > ... > > 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? > > Frank Nordberg > http://www.musicaviva.com > http://stores.ebay.com/Nordbergs-Music-Store?refid=store > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ 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)
Based on my own test, i got > 40000 searches with > [lookup].......................................: 2 s > 10000 searches with > [search].......................................: 20 s which would make [lookup] roughly 40 times faster than [search] with 6.2. I noticed the difference was less dramatic using 6.0 - chris On Jul 28, 2009, at 10:40, Frank Nordberg wrote: > christophe.billiottet@webdna.us wrote: > > ... >> Since [lookup] is extremely fast compared to [search] > ... > > 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? > > Frank Nordberg > http://www.musicaviva.com > http://stores.ebay.com/Nordbergs-Music-Store?refid=store > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ christophe.billiottet@webdna.us

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:

PayFlow Pro (2003) WebCatalog Mac and cgi-bin (WebSTAR 2.0) (1997) PCS Emailer's role ? (1997) converted seed value? (1998) Artwork (1997) Review comparison by PC Magazine: Open for On-line Business (1997) [protect] (2000) [WebDNA] Quick grep question (2009) Custom formulas.db (1998) WebDNA problem (2006) Security (2000) Help name our technology! (1997) Re:no [search] with NT (1997) Webcatalog/Butler (1998) Signal Raised (1997) RE: WebCatalog NT beta 18 now available (1997) (off topic).upload in webstart (2001) HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997) Nesting FoundItem Context (1997) Multiple download orders of the same product? (1997)