[WebDNA] some tests

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107154
interpreted = N
texte = --Apple-Mail-12-801300441 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii I just ran some tests: the new [append] tag is really fast :-) iMac Core 2 Duo 2.4GHz 3GB RAM WebDNA 7.0 with "Only commit databases to = disk when instructed" Open a database (2 fields), append 10000 records00:00:00 Now 40000 searches with [lookup] 00:00:02 10000 searches with [search] 00:00:18 Delete the records 00:00:05 Open a database, append 10000 rec using [replace]00:00:06 iMac Core 2 Duo 2.4GHz 3GB RAM WebDNA 7.0 with "Automatically commit = databases to disk after modification" Open a database (2 fields), append 10000 records00:00:03 Now 40000 searches with [lookup] 00:00:03 10000 searches with [search] 00:00:17 Delete the records 00:00:05 Open a database, append 10000 rec using [replace]00:00:09 PowerPC G5 1.8GHz 4GB RAM WebDNA 6.0a with "Automatically commit = databases to disk after modification" Open a database (2 fields), append 10000 records00:00:14 Now 40000 searches with [lookup] 00:00:56 10000 searches with [search] 00:00:42 Delete the records 00:00:21 Open a database, append 10000 rec using [replace]00:00:22 MacMini Core 2 Duo 2.26GHz 8GB RAM WebDNA 6.2 with "Automatically commit = databases to disk after modification" Open a database (2 fields), append 10000 records00:00:04 Now 40000 searches with [lookup] 00:00:02 10000 searches with [search] 00:00:19 Delete the records 00:00:06 Open a database, append 10000 rec using [replace]00:00:08 --Apple-Mail-12-801300441 Content-Disposition: attachment; filename=stress.dna Content-Type: application/octet-stream; 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]
Open a database (2 fields), append 10000 records using the replace trick [Math time]{[time]}-{[start_time]}[/Math]
--Apple-Mail-12-801300441-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] some tests (christophe.billiottet@webdna.us 2011)
  2. Re: [WebDNA] some tests (William DeVaul 2011)
  3. [WebDNA] some tests (christophe.billiottet@webdna.us 2011)
--Apple-Mail-12-801300441 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii I just ran some tests: the new [append] tag is really fast :-) iMac Core 2 Duo 2.4GHz 3GB RAM WebDNA 7.0 with "Only commit databases to = disk when instructed" Open a database (2 fields), append 10000 records00:00:00 Now 40000 searches with [lookup] 00:00:02 10000 searches with [search] 00:00:18 Delete the records 00:00:05 Open a database, append 10000 rec using [replace]00:00:06 iMac Core 2 Duo 2.4GHz 3GB RAM WebDNA 7.0 with "Automatically commit = databases to disk after modification" Open a database (2 fields), append 10000 records00:00:03 Now 40000 searches with [lookup] 00:00:03 10000 searches with [search] 00:00:17 Delete the records 00:00:05 Open a database, append 10000 rec using [replace]00:00:09 PowerPC G5 1.8GHz 4GB RAM WebDNA 6.0a with "Automatically commit = databases to disk after modification" Open a database (2 fields), append 10000 records00:00:14 Now 40000 searches with [lookup] 00:00:56 10000 searches with [search] 00:00:42 Delete the records 00:00:21 Open a database, append 10000 rec using [replace]00:00:22 MacMini Core 2 Duo 2.26GHz 8GB RAM WebDNA 6.2 with "Automatically commit = databases to disk after modification" Open a database (2 fields), append 10000 records00:00:04 Now 40000 searches with [lookup] 00:00:02 10000 searches with [search] 00:00:19 Delete the records 00:00:06 Open a database, append 10000 rec using [replace]00:00:08 --Apple-Mail-12-801300441 Content-Disposition: attachment; filename=stress.dna Content-Type: application/octet-stream; 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]
Open a database (2 fields), append 10000 records using the replace trick [Math time]{[time]}-{[start_time]}[/Math]
--Apple-Mail-12-801300441-- 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:

Https not showing products (2004) Triggers (2003) Number of Feilds Passed to [append] (2000) Logging purchases (1997) all records returned. (1997) [convertChars] and HTML Tags (1997) Emailer update for Mac? (1998) Re1000002: Setting up shop (1997) [searchString] (1997) Is there a max number of fields? (1998) form crasehes server (1997) problem (how to mark orders as 'opened') (1998) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Help! Missing [showif] or [hideif] (2000) Country & Ship-to address & other fields ? (1997) RE: OK, here goes... (1997) [WebDNA] install issues on Centos 6 (2017) [Cart] ... (1997) Summing fields (1997) SKU (1997)