Re: PEAR DB abstraction layers
| From: | Lorenzo Alberton | Date: | Mon, 19 Apr 2004 16:25:57 +0000 |
| Subject: | Re: PEAR DB abstraction layers | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-28053@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/
Until now, I've always trusted Lukas' statements
about MDB[x] performances, but having the link
of John Lim's benchmark suite at hand was too
tempting... [:grin:]
I have no web-server stress tool installed,
so I just run each test three times. I know it is
quite a ridiculous test, but it could nevertheless
show a general performance index of each dbal
All the DBALs are in their latest CVS versions.
The test results are attached.
Best regards,
Lorenzo
Apache/2.0.49 (Win32) PHP/4.3.6 Server at localhost Port 80 Mysql/3.23.58-max-debug http://phplens.com/lens/adodb/ Benchmark MySQL: Queried 200 times for 0.565757989883 seconds MySQL: Queried 200 times for 0.536381006241 seconds MySQL: Queried 200 times for 0.551997900009 seconds ADODB: Queried 200 times for 1.59053611755 seconds ADODB: Queried 200 times for 1.57458591461 seconds ADODB: Queried 200 times for 1.56963300705 seconds //with portability = MDB2_PORTABILITY_NONE PEAR MDB2: Queried 200 times for 1.81178689003 seconds PEAR MDB2: Queried 200 times for 1.82114195824 seconds PEAR MDB2: Queried 200 times for 1.84796595573 seconds PEAR MDB: Queried 200 times for 2.21403098106 seconds PEAR MDB: Queried 200 times for 2.0872130394 seconds PEAR MDB: Queried 200 times for 2.09404802322 seconds //with portability = MDB2_PORTABILITY_ALL PEAR MDB2: Queried 200 times for 2.74024987221 seconds PEAR MDB2: Queried 200 times for 2.73800611496 seconds PEAR MDB2: Queried 200 times for 2.71783494949 seconds //with default portability options (~DB_PORTABILITY_NONE) PEAR DB: Queried 200 times for 3.33627796173 seconds PEAR DB: Queried 200 times for 3.23177909851 seconds PEAR DB: Queried 200 times for 3.1908390522 seconds //with portability = DB_PORTABILITY_ALL PEAR DB: Queried 200 times for 6.07162594795 seconds PEAR DB: Queried 200 times for 5.81364798546 seconds PEAR DB: Queried 200 times for 5.9135389328 seconds Metabase: Queried 200 times for 10.3572499752 seconds Metabase: Queried 200 times for 10.8948390484 seconds Metabase: Queried 200 times for 10.3562500477 seconds
Apache/2.0.49 (Win32) PHP/4.3.6 Server at localhost Port 80 Mysql/3.23.58-max-debug http://phplens.com/lens/adodb/ Benchmark MySQL: Queried 200 times for 0.565757989883 seconds MySQL: Queried 200 times for 0.536381006241 seconds MySQL: Queried 200 times for 0.551997900009 seconds ADODB: Queried 200 times for 1.59053611755 seconds ADODB: Queried 200 times for 1.57458591461 seconds ADODB: Queried 200 times for 1.56963300705 seconds //with portability = MDB2_PORTABILITY_NONE PEAR MDB2: Queried 200 times for 1.81178689003 seconds PEAR MDB2: Queried 200 times for 1.82114195824 seconds PEAR MDB2: Queried 200 times for 1.84796595573 seconds PEAR MDB: Queried 200 times for 2.21403098106 seconds PEAR MDB: Queried 200 times for 2.0872130394 seconds PEAR MDB: Queried 200 times for 2.09404802322 seconds //with portability = MDB2_PORTABILITY_ALL PEAR MDB2: Queried 200 times for 2.74024987221 seconds PEAR MDB2: Queried 200 times for 2.73800611496 seconds PEAR MDB2: Queried 200 times for 2.71783494949 seconds //with default portability options (~DB_PORTABILITY_NONE) PEAR DB: Queried 200 times for 3.33627796173 seconds PEAR DB: Queried 200 times for 3.23177909851 seconds PEAR DB: Queried 200 times for 3.1908390522 seconds //with portability = DB_PORTABILITY_ALL PEAR DB: Queried 200 times for 6.07162594795 seconds PEAR DB: Queried 200 times for 5.81364798546 seconds PEAR DB: Queried 200 times for 5.9135389328 seconds Metabase: Queried 200 times for 10.3572499752 seconds Metabase: Queried 200 times for 10.8948390484 seconds Metabase: Queried 200 times for 10.3562500477 seconds