Abstraction layers

[Jacob Singh]

What is everyone's favorite abstraction layer?
--
Jacob Singh, ja...@prisonbooks.org on 10/24/2001

[John Lim]

Someone asked me to benchmark PHPLib also.
Here is the revised benchmarks, with some minor speedups for
PEAR DB and Metabase.

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 4.52 296% (numeric cols)
M'base 4.77 318% (named cols)

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/