RE: [phpGroupWare-developers] [patch #6572] A test on using PDO in db-class

[Sigurd Nes]

> From: Dave Hall address@hidden
> Sent: 2008-07-18 11:23:24 CEST
> To: address@hidden
> Subject: Re: [phpGroupWare-developers] [patch #6572] A test on using PDO in   
> db-class
> 
> On Thu, 2008-07-17 at 23:50 +0200, Sigurd Nes wrote:
> > Hi all,
> > 
> > I did a test on using PDO for db-connection.
> > The code is based on the current db-class from trunk and the tutorial found 
> > at:
> > http://www.phpro.org/tutorials/Introduction-to-PHP-PDO.html
> > 
> > Seems like it is about 5 % faster on reading and 20 % faster on writing 
> > compared
> > to adodb with eaccelerator (had hoped for more).
> > 
> > The class is not 100% complete - but most of it works.
> > 
> > http://savannah.gnu.org/patch/download.php?file_id=16131
> > 
> > What do you think ?
> 
> Please post the test cases used to generate these stats so they can be
> verified.
> 

Yep - it is faster:

100.000 inserts and selects levels out on 14 sec and 3,5 sec for PDO and 21 sec 
and 6 sec for ADOdb.

That is 33% faster on insert and 42 % faster on select

See attachment to try it your self

Regards

Sigurd

test_pdo.php
Description: Binary data