Re: PEAR DB abstraction layers
| From: | Lorenzo Alberton | Date: | Tue, 20 Apr 2004 23:31:37 +0000 |
| Subject: | Re: PEAR DB abstraction layers | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-28177@lists.php.net to get a copy of this message | ||
On Mon, 19 Apr 2004 17:16:07 +0200, Martin Jansen wrote:
> On Mon Apr 19, 2004 at 04:0039PM +0200, Lukas Smith wrote:
>
>> However MDB2 has the following:
>> - is faster
>
> Do you have some concrete benchmark results to back this up? -
> Martin Martin Jansen
> http://martinjansen.com/
attached: benchmark results for mysql and php5.0.0-RC1
[ I'm impressed with the php5 speedup... ]
Best regards,
--
Lorenzo Alberton
http://pear.php.net/user/quipo
Apache/2.0.49 (Win32) PHP/5.0.0-RC1 Server at localhost Port 80 Mysql/3.23.58-max-debug http://phplens.com/lens/adodb/ Benchmark MySQL: Queried 200 times for 0.450705051422 seconds MySQL: Queried 200 times for 0.480592012405 seconds MySQL: Queried 200 times for 0.467209100723 seconds ADODB: Queried 200 times for 0.651127815247 seconds ADODB: Queried 200 times for 0.652872800827 seconds ADODB: Queried 200 times for 0.649571895599 seconds //with portability = MDB2_PORTABILITY_NONE PEAR MDB2: Queried 200 times for 0.818247079849 seconds PEAR MDB2: Queried 200 times for 0.822215080261 seconds PEAR MDB2: Queried 200 times for 0.813241004944 seconds PEAR MDB: Queried 200 times for 0.852077960968 seconds PEAR MDB: Queried 200 times for 0.875056028366 seconds PEAR MDB: Queried 200 times for 0.883426904678 seconds //with default portability options (~DB_PORTABILITY_NONE) PEAR DB: Queried 200 times for 0.929541110992 seconds PEAR DB: Queried 200 times for 0.911957025528 seconds PEAR DB: Queried 200 times for 0.926497936249 seconds //with portability = MDB2_PORTABILITY_ALL PEAR MDB2: Queried 200 times for 1.04677700996 seconds PEAR MDB2: Queried 200 times for 0.984637975693 seconds PEAR MDB2: Queried 200 times for 1.03026199341 seconds //with portability = DB_PORTABILITY_ALL PEAR DB: Queried 200 times for 1.59116005898 seconds PEAR DB: Queried 200 times for 1.64945912361 seconds PEAR DB: Queried 200 times for 1.62392306328 seconds Metabase: Queried 200 times for 2.06246089935 seconds Metabase: Queried 200 times for 2.04101705551 seconds Metabase: Queried 200 times for 2.16028094292 seconds
Apache/2.0.49 (Win32) PHP/5.0.0-RC1 Server at localhost Port 80 Mysql/3.23.58-max-debug http://phplens.com/lens/adodb/ Benchmark MySQL: Queried 200 times for 0.450705051422 seconds MySQL: Queried 200 times for 0.480592012405 seconds MySQL: Queried 200 times for 0.467209100723 seconds ADODB: Queried 200 times for 0.651127815247 seconds ADODB: Queried 200 times for 0.652872800827 seconds ADODB: Queried 200 times for 0.649571895599 seconds //with portability = MDB2_PORTABILITY_NONE PEAR MDB2: Queried 200 times for 0.818247079849 seconds PEAR MDB2: Queried 200 times for 0.822215080261 seconds PEAR MDB2: Queried 200 times for 0.813241004944 seconds PEAR MDB: Queried 200 times for 0.852077960968 seconds PEAR MDB: Queried 200 times for 0.875056028366 seconds PEAR MDB: Queried 200 times for 0.883426904678 seconds //with default portability options (~DB_PORTABILITY_NONE) PEAR DB: Queried 200 times for 0.929541110992 seconds PEAR DB: Queried 200 times for 0.911957025528 seconds PEAR DB: Queried 200 times for 0.926497936249 seconds //with portability = MDB2_PORTABILITY_ALL PEAR MDB2: Queried 200 times for 1.04677700996 seconds PEAR MDB2: Queried 200 times for 0.984637975693 seconds PEAR MDB2: Queried 200 times for 1.03026199341 seconds //with portability = DB_PORTABILITY_ALL PEAR DB: Queried 200 times for 1.59116005898 seconds PEAR DB: Queried 200 times for 1.64945912361 seconds PEAR DB: Queried 200 times for 1.62392306328 seconds Metabase: Queried 200 times for 2.06246089935 seconds Metabase: Queried 200 times for 2.04101705551 seconds Metabase: Queried 200 times for 2.16028094292 seconds