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:
[LOOKUP] (1997)
[Fwd: F3 database munching] (1997)
orderfile location (1999)
MacActivity and PCS (1997)
Listserver problem (1997)
Multiple 'Users.db' files not possible (1997)
Carts & Refering URLs (1997)
[WebDNA] Clean URLS job - will pay (2010)
Kaaaaahhhhhhhnnnnnnn! (1997)
Banner DNA (1997)
Error: Permision deny. (2005)
Bug Report, maybe (1997)
Remote Admin Design Question (1998)
searching for last file in a directory (1999)
2nd WebCatalog2 Feature Request (1996)
WebCat2.0 [format thousands .0f] no go (1997)
Hiding HTML and breaking the page (1997)
[WriteFile] problems (1997)
multi-paragraph fields (1997)
Question about replacing words (1998)