|
 ADOdb Lite Benchmark Comparison - August 12, 2005
Some people were wondering if ADOdb Lite was any faster than ADOdb since it is also smaller. I decided to use virtually the same benchmark testing that was used for ADOdb on their site.
Benchmark Hardware:
P4 1.0Ghz
Fedora Core 3
Apache 2.0.54
PHP 4.4.0
MySQL 4.1.10
ADOdb 4.65
ADOdb Lite 1.00
The test used the settings detailed on the Benchmark page for how to perform the test yourself. The Accelerator test was performed using eAccelerator 0.9.3 with optimizations enabled. Below are the pages per second generated using the Microsoft Web Application Stress Tool and the benchmark programs located on the Benchmark page. The higher the value the better the performace.
| |
With Accelerator |
No Accelerator |
| PHP MySQL Commands |
101.60 |
93.20 |
| ADOdb Lite |
88.34 |
55.92 |
| ADOdb |
64.33 |
17.40 |
As you can see, in addition to using less memory, ADOdb Lite is 300% faster than ADOdb on a server without an accelerator installed. And if you have an accelerator it is about 30% faster
than ADOdb.
How to perform the ADOdb Lite Benchmark Comparison - August 7, 2005
This benchmark is a cut down version of the benchmark package
that can be found at http://phplens.com/lens/adodb/ and was created
by John Lim. The only changes are to set MAXTIMES to 1 instead of
200, removal of all tests except for adodb and mysql and inclusion
of an adodblite test (copy of the adodb test with a different
path to the library).
How to run the test.
Download the benchmark files from here
http://sourceforge.net/project/showfiles.php?group_id=140982&package_id=160056
Upload the benchmark directory to your server.
Download the Web Application Stress Tool from here
http://www.microsoft.com/downloads/details.aspx?FamilyID=E2C0585A-062A-439E-A67D-75A89AA36495&displaylang=en
and install it on your computer You will need to be running Windows NT or XP.
Download ADOdb from http://adodb.sourceforge.net/ and unpack it to
the benchmark directory.
Download ADOdb Lite from http://adodblite.sourceforge.net/ and
unpack it to the benchmark directory.
Create a database called benchmark.
Use the createproducts.sql to create the products table in the
benchmark database.
You can assign a user called pj and a password called pj to that
database or edit the three bench*.php files and set the user and
password you would like to use.
You can now setup three tests in the Web Application Stress Tool
for each bench*.php. Be sure to use these settings for each test.
Stress Level(threads): 2
Stress Multiplier: 1
Use Random Delay: NOT CHECKED
Test Run Time: 0 Days, 0 Hours, 0 Minutes, 30 Seconds
Suspend Warmup: 5 Seconds
All other settings should be unchecked.
Run each test two to five times and view the reports area for the results.
| 
