- status: open --> closed
Comparing ADODB with PhpLib, PEAR DB, Metabase and
Native MySQL
Benchmark was to select 82 rows from the products
table 200 times.
The tests were repeated 5 times. Connection times were
excluded
from the benchmark. Lower values are better. All
numbers are in
seconds.
MySQL 1.12 1.12 1.17 1.15 1.14
ADODB 1.43 1.47 1.47 1.44 1.45
PhpLib 1.53 1.62 1.64 1.64 1.57
PEAR 2.91 2.90 2.85 2.83 2.84
(fetchInto)
PEAR 3.14 3.13 3.22 3.12 3.16
(fetchRow)
M'base 4.51 4.55 4.46 4.54 4.52
(numeric columns)
M'base 4.99 4.72 4.71 4.71 4.72 (named
columns)
Average Overhead
MySQL 1.14 -
ADODB 1.45 27%
PhpLib 1.60 40%
PEAR 2.87 152% (fetchInto)
PEAR 3.15 176% (fetchRow)
M'base 2.52 296% (numeric cols)
M'base 4.77 318% (named cols)
I was still surprised at how slow some of the
libraries were, even
though a code inspection had already given strong
hints on the expected
performance of the class libraries.
Methodology
Results on Pentium 800 Mhz running Win 2000, PHP 4.0.6
ISAPI on IIS5
with MySQL 3.23, all on the same machine. PEAR DB from
PHP 4.0.6,
ADODB 1.40, PhpLib 7.2d and Metabase 1.57 were used.
Code revised on 22nd October 2001. PhpLib tests added
24th October 2001.
Source code for these tests is available from
http://phplens.com/lens/adodb/
- John Lim