Re: [WebDNA] Lookup vs. Search

This WebDNA talk-list message is from

2009

It keeps the original formatting. numero = 103049
interpreted = N
texte = --Apple-Mail-2--95349936Content-Type: text/plain;charset=US-ASCII;format=flowedContent-Transfer-Encoding: 7bitSo far, no change. Here the small stress file, so anybody can test:--Apple-Mail-2--95349936Content-Disposition: attachment;filename=stress.dnaContent-Type: application/octet-stream;x-unix-mode=0644;x-mac-type=54455854;name="stress.dna"Content-Transfer-Encoding: 7bit[!] ##Check for the Database first - create it if not there--[/!][showif T=[fileinfo file=speed.db][exists][/fileinfo]][closedatabase db=speed.db][deletefile file=speed.db][/showif][showif F=[fileinfo file=speed.db][exists][/fileinfo]][writefile file=speed.db]skuvalue[/writefile][/showif][!] ##Delete the records in the DB to ensure the search is 'clean'--[/!][delete db=speed.db&neSKUdata=find_all] 

(seconds)	This Task
Variables
Text Variables - Set an increasing # into a text variable 10000 times	[Math time]{[time]}-{[start_time]}[/Math]
Let's do some math: sin(x), 0<x<51, 10000 times.	[Math time]{[time]}-{[start_time]}[/Math]
Database Manipulation
Open a database (2 fields), append 10000 records	[Math time]{[time]}-{[start_time]}[/Math]
Now 40000 searches with [raw][lookup][/raw]	[Math time]{[time]}-{[start_time]}[/Math]
10000 searches with [raw][search][/raw]	[Math time]{[time]}-{[start_time]}[/Math]
Delete the records	[Math time]{[time]}-{[start_time]}[/Math]

--Apple-Mail-2--95349936Content-Type: text/plain;charset=US-ASCII;format=flowed;delsp=yesContent-Transfer-Encoding: 7bit- chrisOn Jul 28, 2009, at 12:10, Kenneth Grome wrote:> Hi Chris,>> Grant also said doing a case-sensitive search is almost as fast as a > lookup, so this is something else to take into consideration when > deciding which approach to use.>> Lookups are case-sensitive by default. Nothing can change this. But > if a lookup is possible then a faster case-sensitive search is also > possible by adding "&[fieldname]case=T" to your search string.>> It would be interesting to see lookups compared with case-sensitive > searches in version 6.2. This more of an apples-to-apples comparison > since they are both case sensitive, and I think the results would be > informative.>> Chris, apparently you're already setup to do these comparisons since > you've been posting results. Any chance of you doing a case- > sensitive comparison like this?>> Sincerely,> Ken Grome>>--Apple-Mail-2--95349936-- Associated Messages, from the most recent to the oldest:

Re: [WebDNA] Lookup vs. Search (Kenneth Grome 2009) Re: [WebDNA] Lookup vs. Search (Frank Nordberg 2009) Re: [WebDNA] Lookup vs. Search (christophe.billiottet@webdna.us 2009) [WebDNA] Lookup vs. Search (Kenneth Grome 2009) Re: [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (christophe.billiottet@webdna.us 2009) Re: [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (Kenneth Grome 2009) Re: [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (christophe.billiottet@webdna.us 2009) [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (Frank Nordberg 2009)

--Apple-Mail-2--95349936Content-Type: text/plain;charset=US-ASCII;format=flowedContent-Transfer-Encoding: 7bitSo far, no change. Here the small stress file, so anybody can test:--Apple-Mail-2--95349936Content-Disposition: attachment;filename=stress.dnaContent-Type: application/octet-stream;x-unix-mode=0644;x-mac-type=54455854;name="stress.dna"Content-Transfer-Encoding: 7bit[!] ##Check for the Database first - create it if not there--[/!][showif T=[fileinfo file=speed.db][exists][/fileinfo]][closedatabase db=speed.db][deletefile file=speed.db][/showif][showif F=[fileinfo file=speed.db][exists][/fileinfo]][writefile file=speed.db]skuvalue[/writefile][/showif][!] ##Delete the records in the DB to ensure the search is 'clean'--[/!][delete db=speed.db&neSKUdata=find_all] 

(seconds)	This Task
Variables
Text Variables - Set an increasing # into a text variable 10000 times	[Math time]{[time]}-{[start_time]}[/Math]
Let's do some math: sin(x), 0<x<51, 10000 times.	[Math time]{[time]}-{[start_time]}[/Math]
Database Manipulation
Open a database (2 fields), append 10000 records	[Math time]{[time]}-{[start_time]}[/Math]
Now 40000 searches with [raw][lookup][/raw]	[Math time]{[time]}-{[start_time]}[/Math]
10000 searches with [raw][search][/raw]	[Math time]{[time]}-{[start_time]}[/Math]
Delete the records	[Math time]{[time]}-{[start_time]}[/Math]

--Apple-Mail-2--95349936Content-Type: text/plain;charset=US-ASCII;format=flowed;delsp=yesContent-Transfer-Encoding: 7bit- chrisOn Jul 28, 2009, at 12:10, Kenneth Grome wrote:> Hi Chris,>> Grant also said doing a case-sensitive search is almost as fast as a > lookup, so this is something else to take into consideration when > deciding which approach to use.>> Lookups are case-sensitive by default. Nothing can change this. But > if a lookup is possible then a faster case-sensitive search is also > possible by adding "&[fieldname]case=T" to your search string.>> It would be interesting to see lookups compared with case-sensitive > searches in version 6.2. This more of an apples-to-apples comparison > since they are both case sensitive, and I think the results would be > informative.>> Chris, apparently you're already setup to do these comparisons since > you've been posting results. Any chance of you doing a case- > sensitive comparison like this?>> Sincerely,> Ken Grome>>--Apple-Mail-2--95349936-- 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:

Sendmail: bounced e-mails (2001) Re:Help name our technology! (1997) Sort Floating Point Number (2008) [OT] Internet connection problem (2003) Emailer (WebCat2) (1997) [WebDNA] Debian Lenny, Lighttpd and WebDNA FastCGI ... (2010) Nesting format tags (1997) WebDNA Solutions ... (1997) WebCat2b15MacPlugin - showing [math] (1997) [WebDNA] EMailFolder/ (2016) [WebDNA] Old Problem, the exclamation point (2014) WCS Newbie question (1997) WebDelivery downloads alias, not original ? (1997) Connection Speed (2002) problems with 2 tags (1997) [delete] problem (1997) WebCat2b15MacPlugin - [protect] (1997) webcat- multiple selection in input field (1997) all records returned. (1997) Ampersand (1997)