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:

[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)