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 swhich would make [lookup] roughly 40 times faster than [search] with 6.2. I noticed the difference was less dramatic using 6.0- chrisOn 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:
Based on my own test, i got> 40000 searches with > [lookup].......................................: 2 s> 10000 searches with > [search].......................................: 20 swhich would make [lookup] roughly 40 times faster than [search] with 6.2. I noticed the difference was less dramatic using 6.0- chrisOn 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)