Re: [WebDNA] php/mySQL version of WebDNA Speed Test?
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 102141
interpreted = N
texte = My developer, Andjelika, who wrote the php/mySQL test, has some pretty sp=ecific questions/comments=20that people more qualified than myself should answer, so I have directed =her to the list. Be nice=20:)-DanOn Thu, 05 Mar 2009 10:52:10 -0800 "Dan Strong"
wrote:> Thank you for this. It is much more in line with what I was expecting. =I have passed it on to=20>IT, as well as the developer who wrote the stress test I first posted. I= will keep you posted if=20>anything interesting comes of it.> -Dan>=20>=20> On 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 s=ervers. CICADA test shows=20>>only a light load on WebDNA engine. Here the rough code:>>=20>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> old archives: http://dev.webdna.us/TalkListArchive/
Associated Messages, from the most recent to the oldest:
My developer, Andjelika, who wrote the php/mySQL test, has some pretty sp=ecific questions/comments=20that people more qualified than myself should answer, so I have directed =her to the list. Be nice=20:)-DanOn Thu, 05 Mar 2009 10:52:10 -0800 "Dan Strong" wrote:> Thank you for this. It is much more in line with what I was expecting. =I have passed it on to=20>IT, as well as the developer who wrote the stress test I first posted. I= will keep you posted if=20>anything interesting comes of it.> -Dan>=20>=20> On 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 s=ervers. CICADA test shows=20>>only a light load on WebDNA engine. Here the rough code:>>=20>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> old archives: http://dev.webdna.us/TalkListArchive/
"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:
Question on TABLES (2003)
Cart doesn't interpret tag! (1997)
OT: FCKeditor (2005)
Grep Question (2003)
Micro-managing External Links (2006)
List Last Word (2002)
RE: Languages (1997)
Secure Server basic question... (1997)
Message Board (again:-) (2000)
No Data Results (1997)
Paymethod=cc allows all zeros - Anyone?? (1999)
pc (1997)
NetCloak as Emailer substitute? (1999)
Problem displaying search result (1997)
reading a email (2000)
Still having problems with Authen (1997)
Sending mail (was forms and variables) (1998)
E-Mailer (WebCatb15acgiMac) (1997)
Some Questions (1997)
SKU lookup (1997)