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:

PIXO support (1997) serial number generation (1997) Bug Report, maybe (1997) Server Load (2000) WebCat2 several catalogs? (1997) Navigator 4.01 (1997) quitting (1997) [WebDNA] WebDNA crash and now emailer not working (2010) Directory Overload (1998) WebCat2: Items xx to xx shown, etc. (1997) Num Sort Descending (2004) Trouble with formula.db (1997) Couple of questions II (1999) Reports of ErrorLog.txt not being written in Linux (2000) Any Newsletters out there (1998) How to verify email address (1997) showif errors (1998) Feedback Please (2003) NetForms for mail, sorry (1998) PCS Frames (1997)