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.628Same old platform iMac 2.4GHz, 3GB RAMAutomatically commit databases to disk after modification=--------------------------------------------------------------------------=-------WebDNA CICADAiMac 2.4GHz, 3GB RAMText Variables - Set an increasing # into a text variable 10000 times..: = 5 sLet's do some math: sin(x) 10000 times.................................: = 0 sOpen a database (2 fields), append 10000 records.......................: = 5 sNow 40000 searches with [lookup].......................................: = 3 s10000 searches with [search]...........................................: = 16 sDelete 10000 records...................................................: = 6 sOnly commit databases to disk when instructed=--------------------------------------------------------------------------=-------WebDNA CICADAiMac 2.4GHz, 3GB RAMText Variables - Set an increasing # into a text variable 10000 times..: = 5 sLet's do some math: sin(x) 10000 times.................................: = 0 sOpen a database (2 fields), append 10000 records.......................: = 0 sNow 40000 searches with [lookup].......................................: = 2 s10000 searches with [search]...........................................: = 16 sDelete 10000 records...................................................: = 5 sMacMini Corei7 with 4GB RAMAutomatically commit databases to disk after modification=--------------------------------------------------------------------------=-------WebDNA CICADAiMac 2.4GHz, 3GB RAMText Variables - Set an increasing # into a text variable 10000 times..: = 3 sLet's do some math: sin(x) 10000 times.................................: = 0 sOpen a database (2 fields), append 10000 records.......................: = 6 sNow 40000 searches with [lookup].......................................: = 1 s10000 searches with [search]...........................................: = 11 sDelete 10000 records...................................................: = 3 sOnly commit databases to disk when instructed=--------------------------------------------------------------------------=-------WebDNA CICADAiMac 2.4GHz, 3GB RAMText Variables - Set an increasing # into a text variable 10000 times..: = 3 sLet's do some math: sin(x) 10000 times.................................: = 0 sOpen a database (2 fields), append 10000 records.......................: = 0 sNow 40000 searches with [lookup].......................................: = 1 s10000 searches with [search]...........................................: = 11 sDelete 10000 records...................................................: = 3 sOn 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:
You remember this speed test from Marc 2009? (end oof this email)Here some new tests to compare with WebDNA 7.0.628Same old platform iMac 2.4GHz, 3GB RAMAutomatically commit databases to disk after modification=--------------------------------------------------------------------------=-------WebDNA CICADAiMac 2.4GHz, 3GB RAMText Variables - Set an increasing # into a text variable 10000 times..: = 5 sLet's do some math: sin(x) 10000 times.................................: = 0 sOpen a database (2 fields), append 10000 records.......................: = 5 sNow 40000 searches with
[lookup].......................................: = 3 s10000 searches with
[search]...........................................: = 16 sDelete 10000 records...................................................: = 6 sOnly commit databases to disk when instructed=--------------------------------------------------------------------------=-------WebDNA CICADAiMac 2.4GHz, 3GB RAMText Variables - Set an increasing # into a text variable 10000 times..: = 5 sLet's do some math: sin(x) 10000 times.................................: = 0 sOpen a database (2 fields), append 10000 records.......................: = 0 sNow 40000 searches with
[lookup].......................................: = 2 s10000 searches with
[search]...........................................: = 16 sDelete 10000 records...................................................: = 5 sMacMini Corei7 with 4GB RAMAutomatically commit databases to disk after modification=--------------------------------------------------------------------------=-------WebDNA CICADAiMac 2.4GHz, 3GB RAMText Variables - Set an increasing # into a text variable 10000 times..: = 3 sLet's do some math: sin(x) 10000 times.................................: = 0 sOpen a database (2 fields), append 10000 records.......................: = 6 sNow 40000 searches with
[lookup].......................................: = 1 s10000 searches with
[search]...........................................: = 11 sDelete 10000 records...................................................: = 3 sOnly commit databases to disk when instructed=--------------------------------------------------------------------------=-------WebDNA CICADAiMac 2.4GHz, 3GB RAMText Variables - Set an increasing # into a text variable 10000 times..: = 3 sLet's do some math: sin(x) 10000 times.................................: = 0 sOpen a database (2 fields), append 10000 records.......................: = 0 sNow 40000 searches with
[lookup].......................................: = 1 s10000 searches with
[search]...........................................: = 11 sDelete 10000 records...................................................: = 3 sOn 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)