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=20 that people more qualified than myself should answer, so I have directed = her to the list. Be nice=20 :) -Dan On 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:

    
  1. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? (christophe.billiottet@webdna.us 2012)
  2. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? (christophe.billiottet@webdna.us 2012)
  3. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? ("Dan Strong" 2009)
  4. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? ("Dan Strong" 2009)
  5. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? (christophe.billiottet@webdna.us 2009)
  6. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? (christophe.billiottet@webdna.us 2009)
  7. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? (christophe.billiottet@webdna.us 2009)
  8. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? ("Dan Strong" 2009)
  9. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? (Bob Minor 2009)
  10. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? (christophe.billiottet@webdna.us 2009)
  11. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? ("Dan Strong" 2009)
  12. RE: [WebDNA] php/mySQL version of WebDNA Speed Test? ("David Taniguchi" 2009)
  13. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? (Donovan Brooke 2009)
  14. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? ("Dan Strong" 2009)
  15. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? (Bob Minor 2009)
  16. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? (christophe.billiottet@webdna.us 2009)
  17. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? ("Dan Strong" 2009)
  18. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? (Bob Minor 2009)
  19. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? ("Dan Strong" 2009)
  20. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? ("Dan Strong" 2009)
  21. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? (Ki Song 2009)
  22. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? ("Dan Strong" 2009)
  23. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? (christophe.billiottet@webdna.us 2009)
  24. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? ("Gary Krockover" 2009)
  25. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? (Bob Minor 2009)
  26. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? (Rich Kwas 2009)
  27. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? (Ki Song 2009)
  28. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? ("Dan Strong" 2009)
  29. Re: [WebDNA] php/mySQL version of WebDNA Speed Test? ("Dan Strong" 2009)
  30. [WebDNA] php/mySQL version of WebDNA Speed Test? ("Dan Strong" 2009)
My developer, Andjelika, who wrote the php/mySQL test, has some pretty sp= ecific questions/comments=20 that people more qualified than myself should answer, so I have directed = her to the list. Be nice=20 :) -Dan On 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)