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,=20 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 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 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:

    
  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)
Thank you for this. It is much more in line with what I was expecting. I = have passed it on to IT,=20 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 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 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)