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:

why won't this work, please tell me??? (2001) Am I going senile? (Price recalc based on quantity) (1997) Navigator 4.0 & tables (1997) wrong input values? (1997) [Sum] function? (1997) How much is too much? I can never remember the answer. (2002) NT or Mac (1998) [OT] Search Engine Tips (2003) WebCat with WebTen (1998) Upcoming 2.1 Release and PCS Committment (1997) maximu values for sendmail! (1997) Grant, please help me ... (1997) [WebDNA] showif/sendmail question (2008) Looking for a host (1997) Email/Sendmail in WEBDNA has stopped... (2004) Using WC for Bulk Emailings (1997) PCS Frames (1997) [ListFiles] & [loop] (1998) ConverChars (1999) HELP WITH DATES (1997)