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:

Help with Repost Data msg from form (1997) cart ID (1998) Help needed! (1998) question: Eudora 3.1.1 (1997) [writefile] (1997) Search for 20 finds 2000, 200 Why? (1997) pc (1997) Math Blind (2000) Unexpected error (1997) Post (1997) select multiple (1997) [showif [getcookie otherDomain]=yes] inside a [TCP connect] will work? (2000) [url] link (1998) NewCart+Search with one click ? (1997) Setting up WebCatalog with Retail Pro data (1996) WebCat2 beta 11 - new prefs ... (1997) Help! WebCat2 bug (1997) Protect vs Authenicate (1997) PCS Customer submissions ? (1997) Cart Already Submitted (2003)