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

[Sigurd Nes]

Sigurd Nes wrote:
>> From: Maât address@hidden
>> Sent: 2008-07-18 08:17:31 CEST
>> To: address@hidden
>> Subject: Re: [phpGroupWare-developers] [patch #6572] A test on using PDO in  
>> db-class
>>
>> Sigurd Nes a écrit :
>>> 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 ?
>>>   
>> nice try !
>>
>> thanks Sigurd :)
>>
> 
> I think we also could have a look at Prepared Queries - maybe something as 
> the second example on this page:
> http://www.devshed.com/c/a/PHP/Working-with-Prepared-Queries-with-PDO-Objects-in-PHP-5/2/
> 
The class is updated to handle prepared prepared statements for insert and
select (function insert() and function select())

Might be good for preventing sql-injections.

The test include test on FETCH_ASSOC and FETCH_BOTH - seems to make no
difference in performance (speed).


Regards

Sigurd