Re: [WebDNA] php/mySQL version of WebDNA Speed Test?
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108256
interpreted = N
texte = Sorry! damn copy-paste thing :-)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 RAMand a MacMini Corei7 with 4GB RAMAutomatically commit databases to disk after modification=--------------------------------------------------------------------------=-------WebDNA 7.0.628iMac 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 7.0.628iMac 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 sAutomatically commit databases to disk after modification=--------------------------------------------------------------------------=-------WebDNA 7.0.622MacMini Corei7 with 4GB 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 7.0.622MacMini Corei7 with 4GB 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:
Sorry! damn copy-paste thing :-)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 RAMand a MacMini Corei7 with 4GB RAMAutomatically commit databases to disk after modification=--------------------------------------------------------------------------=-------WebDNA 7.0.628iMac 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 7.0.628iMac 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 sAutomatically commit databases to disk after modification=--------------------------------------------------------------------------=-------WebDNA 7.0.622MacMini Corei7 with 4GB 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 7.0.622MacMini Corei7 with 4GB 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:
List Address Changed! (1998)
WebMerchant 3.0 for Mac shipping now (1998)
WCS Newbie question (1997)
CHMOD recursive for directories (2006)
Has anyone used WebCatalog with CGatePro? (2000)
UPS, FEDEX TRACKING (1999)
Date Time Oddness (1999)
What is WebDNA (1997)
WebCat2 - many [carts] on one template page? (1997)
Problem (1997)
TCPconnect in a DB? (1999)
More on the email templates (1997)
Snake Bites (1997)
Nested vs conditional (1997)
Credit card processing - UK (1997)
Database Program (1997)
Re:no template caching (1997)
Ready,Set; Print! (1999)
[tcpsend] (2001)
Folder modify times (2003)