[WebDNA] some tests

This WebDNA talk-list message is from

2011

It keeps the original formatting. numero = 107154
interpreted = N
texte = --Apple-Mail-12-801300441Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiI 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:00Now 40000 searches with [lookup] 00:00:0210000 searches with [search] 00:00:18Delete the records 00:00:05Open a database, append 10000 rec using [replace]00:00:06iMac 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:03Now 40000 searches with [lookup] 00:00:0310000 searches with [search] 00:00:17Delete the records 00:00:05Open a database, append 10000 rec using [replace]00:00:09PowerPC 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:14Now 40000 searches with [lookup] 00:00:5610000 searches with [search] 00:00:42Delete the records 00:00:21Open a database, append 10000 rec using [replace]00:00:22MacMini 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:04Now 40000 searches with [lookup] 00:00:0210000 searches with [search] 00:00:19Delete the records 00:00:06Open a database, append 10000 rec using [replace]00:00:08--Apple-Mail-12-801300441Content-Disposition: attachment;filename=stress.dnaContent-Type: application/octet-stream;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]
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:

Re: [WebDNA] some tests (christophe.billiottet@webdna.us 2011) Re: [WebDNA] some tests (William DeVaul 2011) [WebDNA] some tests (christophe.billiottet@webdna.us 2011)

--Apple-Mail-12-801300441Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiI 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:00Now 40000 searches with [lookup] 00:00:0210000 searches with [search] 00:00:18Delete the records 00:00:05Open a database, append 10000 rec using [replace]00:00:06iMac 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:03Now 40000 searches with [lookup] 00:00:0310000 searches with [search] 00:00:17Delete the records 00:00:05Open a database, append 10000 rec using [replace]00:00:09PowerPC 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:14Now 40000 searches with [lookup] 00:00:5610000 searches with [search] 00:00:42Delete the records 00:00:21Open a database, append 10000 rec using [replace]00:00:22MacMini 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:04Now 40000 searches with [lookup] 00:00:0210000 searches with [search] 00:00:19Delete the records 00:00:06Open a database, append 10000 rec using [replace]00:00:08--Apple-Mail-12-801300441Content-Disposition: attachment;filename=stress.dnaContent-Type: application/octet-stream;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]
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:

NetSplat and WebCat2 (1997) Extra equals signs with IE? (More debugging questions...) (1997) PCS Emailer's role ? (1997) creator code (1997) Public beta 6 for WebCatalog 4.0 is now available (2000) [WebDNA] Dates (2009) Problems passing [SKU] with $Replace in 2.0 (1997) SSL data to/from webcatalog? (2000) Frames and [cart] (1998) WebCatalog dying in NT (1998) Looking for Salvatore (2003) RE: Just a thought (1998) transferring values (1998) Just Testing (1997) EXTERNAL EMAIL: RE: [WebDNA] [BULK] SQL ODBC 00000 Error (2019) [addlineitems] display (1997) Date Formats (1997) [WebDNA] proxy server domains mysteriously appear in webdna's domain list (2010) email code (1998) Append command (2000)