Re: [WebDNA] php/mySQL version of WebDNA Speed Test?
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 102140
interpreted = N
texte = Thank you for this. It is much more in line with what I was expecting. I =have passed it on to IT,=20as well as the developer who wrote the stress test I first posted. I will= keep you posted if=20anything interesting comes of it.-DanOn Thu, 5 Mar 2009 13:56:16 -0200 christophe.billiottet@webdna.us wrote:> So far, here my results; these are just rough tests and need tuning. I = found them extremely=20>interesting.>=20> -----------------------------------------------------------------------=----------> php/MySQL> quad Opteron 2.2GHz, 4GB RAM for apache/php Ubuntu 8> quad Opteron 2.2GHz, 8GB RAM for MySQL 5 Ubuntu 8>=20> Text Variables - Set an increasing # into a text variable 10000 times.=.: 0.03 s> Let's do some math (10000 times)......................................=.: 0.05 s> Open database (2 fields), append 10000 records........................=.: 3 s> Search 40000 Records..................................................=.: 105 s> Delete 10000 Records..................................................=.: 35 s> -----------------------------------------------------------------------=----------> WebDNA CICADA> iMac 2.4GHz, 3GB RAM>=20> Text Variables - Set an increasing # into a text variable 10000 times.=.: 5 s> Let's do some math: sin(x) 10000 times................................=.: 1 s> Open a database (2 fields), append 10000 records......................=.: 2 s> Now 40000 searches with [lookup]......................................=.: 2 s> 10000 searches with [search]..........................................=.: 72 s> Delete 10000 records..................................................=.: 7 s> -----------------------------------------------------------------------=----------> WebDNA 6.0a under Ubuntu 8> quad Opteron 2.2GHz, 4GB RAM for apache/WebDNA>=20> Text Variables - Set an increasing # into a text variable 10000 times.=.: 13 s> Let's do some math: sin(x) 10000 times................................=.: 10 s> Open a database (2 fields), append 10000 records......................=.: 13 s> Now 40000 searches with [lookup]......................................=.: 70 s> 10000 searches with [search]..........................................=.: 27 s> Delete 10000 records..................................................=.: 9 s> -----------------------------------------------------------------------=---------->=20> Notes: php/mysql test and WebDNA 6.0a tests add a big stress on the se=rvers. CICADA test shows=20>only a light load on WebDNA engine. Here the rough code:>=20
Associated Messages, from the most recent to the oldest:
Thank you for this. It is much more in line with what I was expecting. I =have passed it on to IT,=20as well as the developer who wrote the stress test I first posted. I will= keep you posted if=20anything interesting comes of it.-DanOn Thu, 5 Mar 2009 13:56:16 -0200 christophe.billiottet@webdna.us wrote:> So far, here my results; these are just rough tests and need tuning. I = found them extremely=20>interesting.>=20> -----------------------------------------------------------------------=----------> php/MySQL> quad Opteron 2.2GHz, 4GB RAM for apache/php Ubuntu 8> quad Opteron 2.2GHz, 8GB RAM for MySQL 5 Ubuntu 8>=20> Text Variables - Set an increasing # into a text variable 10000 times.=.: 0.03 s> Let's do some math (10000 times)......................................=.: 0.05 s> Open database (2 fields), append 10000 records........................=.: 3 s> Search 40000 Records..................................................=.: 105 s> Delete 10000 Records..................................................=.: 35 s> -----------------------------------------------------------------------=----------> WebDNA CICADA> iMac 2.4GHz, 3GB RAM>=20> Text Variables - Set an increasing # into a text variable 10000 times.=.: 5 s> Let's do some math: sin(x) 10000 times................................=.: 1 s> Open a database (2 fields), append 10000 records......................=.: 2 s> Now 40000 searches with
[lookup]......................................=.: 2 s> 10000 searches with
[search]..........................................=.: 72 s> Delete 10000 records..................................................=.: 7 s> -----------------------------------------------------------------------=----------> WebDNA 6.0a under Ubuntu 8> quad Opteron 2.2GHz, 4GB RAM for apache/WebDNA>=20> Text Variables - Set an increasing # into a text variable 10000 times.=.: 13 s> Let's do some math: sin(x) 10000 times................................=.: 10 s> Open a database (2 fields), append 10000 records......................=.: 13 s> Now 40000 searches with
[lookup]......................................=.: 70 s> 10000 searches with
[search]..........................................=.: 27 s> Delete 10000 records..................................................=.: 9 s> -----------------------------------------------------------------------=---------->=20> Notes: php/mysql test and WebDNA 6.0a tests add a big stress on the se=rvers. CICADA test shows=20>only a light load on WebDNA engine. Here the rough code:>=20
"Dan Strong"
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:
[searchString] (1997)
What is WebDNA (1997)
Fwd: virtual domain and [listfile] paths and aliases (1998)
More questions about serial number dishing (1997)
Trunk-gator (1997)
Problem with [Search] inside of [Loop]? (1997)
What is this error message? (2006)
[WebDNA] [OT] hello (2012)
WebCat2b15MacPlugin - [protect] (1997)
WebDNA 4.5 rpm?!! (2003)
WebCat b13 CGI -shownext- (1997)
Can't load tmpl files (1997)
all records returned. (1997)
emailer w/F2 (1997)
taxTotal confusion (1998)
Thanks Grant (1997)
[WebDNA] [BULK] which of these tags exist in 7.0 (2011)
Cart ID (1999)
using showpage and showcart commands (1996)
Problems with [Search] param - Mac Plugin b15 (1997)