texte = --Apple-Mail-10-980385958Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiHi Palle! does WebDNA returns an error message? are your paths correct? =is the folder that contains your database has proper permissions?Try to run this small speed test--Apple-Mail-10-980385958Content-Disposition: attachment;filename=stressfull.dnaContent-Type: application/octet-stream;name="stressfull.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] |
[/!]