|
From: <no...@so...> - 2001-10-24 14:59:45
|
Support Requests item #474492, was opened at 2001-10-24 07:59 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=403612&aid=474492&group_id=31885 Category: None Group: None Status: Open Priority: 5 Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: phplib, pear db, adodb benchmarks Initial Comment: 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 ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=403612&aid=474492&group_id=31885 |
