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--95349936 Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit So far, no change. Here the small stress file, so anybody can test: --Apple-Mail-2--95349936 Content-Disposition: attachment; filename=stress.dna Content-Type: application/octet-stream; x-unix-mode=0644; x-mac-type=54455854; name="stress.dna" Content-Transfer-Encoding: 7bit WebDNA Performance Test [!] ##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--95349936 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit - chris On 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:

    
  1. Re: [WebDNA] Lookup vs. Search (Kenneth Grome 2009)
  2. Re: [WebDNA] Lookup vs. Search (Frank Nordberg 2009)
  3. Re: [WebDNA] Lookup vs. Search (christophe.billiottet@webdna.us 2009)
  4. [WebDNA] Lookup vs. Search (Kenneth Grome 2009)
  5. Re: [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (christophe.billiottet@webdna.us 2009)
  6. Re: [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (Kenneth Grome 2009)
  7. Re: [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (christophe.billiottet@webdna.us 2009)
  8. [WebDNA] Lookup vs. Search (was: 3-5 GB of native WebDNA db...) (Frank Nordberg 2009)
--Apple-Mail-2--95349936 Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit So far, no change. Here the small stress file, so anybody can test: --Apple-Mail-2--95349936 Content-Disposition: attachment; filename=stress.dna Content-Type: application/octet-stream; x-unix-mode=0644; x-mac-type=54455854; name="stress.dna" Content-Transfer-Encoding: 7bit WebDNA Performance Test [!] ##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--95349936 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit - chris On 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:

serial number (1998) Help name our technology! (1997) Autoreturn Submit? (1997) Setting up shop (1997) taxTotal (1997) Web Catalog 2 demo (1997) [no_cache]?! (2000) billing system (2003) More questions about serial number dishing (1997) Sorry I didn't pay attention-but ??? (1997) WebCommerce: Folder organization ? (1997) Questions about maximum (1999) [SHOWIF]s and empty arguments (1997) A Toughie (1998) Multiple Merchant Accounts? (1997) Job Posting (1998) Configuration Q (1998) WebDNA Solutions ... sorry! (1997) Execute Applescript (1997) Database Strategy - more... (1998)