Re: [WebDNA] php/mySQL version of WebDNA Speed Test?

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 108255
interpreted = N
texte = You remember this speed test from Marc 2009? (end oof this email) Here some new tests to compare with WebDNA 7.0.628 Same old platform iMac 2.4GHz, 3GB RAM Automatically commit databases to disk after modification = --------------------------------------------------------------------------= ------- WebDNA CICADA iMac 2.4GHz, 3GB RAM Text Variables - Set an increasing # into a text variable 10000 times..: = 5 s Let's do some math: sin(x) 10000 times.................................: = 0 s Open a database (2 fields), append 10000 records.......................: = 5 s Now 40000 searches with [lookup].......................................: = 3 s 10000 searches with [search]...........................................: = 16 s Delete 10000 records...................................................: = 6 s Only commit databases to disk when instructed = --------------------------------------------------------------------------= ------- WebDNA CICADA iMac 2.4GHz, 3GB RAM Text Variables - Set an increasing # into a text variable 10000 times..: = 5 s Let's do some math: sin(x) 10000 times.................................: = 0 s Open a database (2 fields), append 10000 records.......................: = 0 s Now 40000 searches with [lookup].......................................: = 2 s 10000 searches with [search]...........................................: = 16 s Delete 10000 records...................................................: = 5 s MacMini Corei7 with 4GB RAM Automatically commit databases to disk after modification = --------------------------------------------------------------------------= ------- WebDNA CICADA iMac 2.4GHz, 3GB RAM Text Variables - Set an increasing # into a text variable 10000 times..: = 3 s Let's do some math: sin(x) 10000 times.................................: = 0 s Open a database (2 fields), append 10000 records.......................: = 6 s Now 40000 searches with [lookup].......................................: = 1 s 10000 searches with [search]...........................................: = 11 s Delete 10000 records...................................................: = 3 s Only commit databases to disk when instructed = --------------------------------------------------------------------------= ------- WebDNA CICADA iMac 2.4GHz, 3GB RAM Text Variables - Set an increasing # into a text variable 10000 times..: = 3 s Let's do some math: sin(x) 10000 times.................................: = 0 s Open a database (2 fields), append 10000 records.......................: = 0 s Now 40000 searches with [lookup].......................................: = 1 s 10000 searches with [search]...........................................: = 11 s Delete 10000 records...................................................: = 3 s On Mar 5, 2009, at 13:56, christophe.billiottet@webdna.us wrote: > = --------------------------------------------------------------------------= ------- > 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 > = --------------------------------------------------------------------------= ------- 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)
You remember this speed test from Marc 2009? (end oof this email) Here some new tests to compare with WebDNA 7.0.628 Same old platform iMac 2.4GHz, 3GB RAM Automatically commit databases to disk after modification = --------------------------------------------------------------------------= ------- WebDNA CICADA iMac 2.4GHz, 3GB RAM Text Variables - Set an increasing # into a text variable 10000 times..: = 5 s Let's do some math: sin(x) 10000 times.................................: = 0 s Open a database (2 fields), append 10000 records.......................: = 5 s Now 40000 searches with [lookup].......................................: = 3 s 10000 searches with [search]...........................................: = 16 s Delete 10000 records...................................................: = 6 s Only commit databases to disk when instructed = --------------------------------------------------------------------------= ------- WebDNA CICADA iMac 2.4GHz, 3GB RAM Text Variables - Set an increasing # into a text variable 10000 times..: = 5 s Let's do some math: sin(x) 10000 times.................................: = 0 s Open a database (2 fields), append 10000 records.......................: = 0 s Now 40000 searches with [lookup].......................................: = 2 s 10000 searches with [search]...........................................: = 16 s Delete 10000 records...................................................: = 5 s MacMini Corei7 with 4GB RAM Automatically commit databases to disk after modification = --------------------------------------------------------------------------= ------- WebDNA CICADA iMac 2.4GHz, 3GB RAM Text Variables - Set an increasing # into a text variable 10000 times..: = 3 s Let's do some math: sin(x) 10000 times.................................: = 0 s Open a database (2 fields), append 10000 records.......................: = 6 s Now 40000 searches with [lookup].......................................: = 1 s 10000 searches with [search]...........................................: = 11 s Delete 10000 records...................................................: = 3 s Only commit databases to disk when instructed = --------------------------------------------------------------------------= ------- WebDNA CICADA iMac 2.4GHz, 3GB RAM Text Variables - Set an increasing # into a text variable 10000 times..: = 3 s Let's do some math: sin(x) 10000 times.................................: = 0 s Open a database (2 fields), append 10000 records.......................: = 0 s Now 40000 searches with [lookup].......................................: = 1 s 10000 searches with [search]...........................................: = 11 s Delete 10000 records...................................................: = 3 s On Mar 5, 2009, at 13:56, christophe.billiottet@webdna.us wrote: > = --------------------------------------------------------------------------= ------- > 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 > = --------------------------------------------------------------------------= ------- christophe.billiottet@webdna.us

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:

Faxing orders in place of email (1997) Fwd: Problems with Webcatalog Plug-in (1997) Sendmail Recipients (2001) 2.0 Info (1997) Can't save email prefs (2003) Editor Recommendation for NT Users (1998) Help! WebCat2 bug (1997) Need relative path explanation (1997) [founditems][replacefounditems] (2003) Emailer problems solved (1997) UPS Calculator (2003) Download capabilities (1997) possible, WebCat2.0 and checkboxes-restated (1997) TemplateCacheSize preference! (1998) [ConvertChars] problem (1997) Hiding HTML and breaking the page (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Search returns all, not 20 (1997) I'm tired of all this! (2000) Sendmail - Attachment / My First Post (2001)