PDO performance View as Markdown

If there is any difference, it is very small. And, anyway, overhead
would turn to nothing comparing to typical query-execution time

I've chosen PDO 3 years ago and never really looked at mysqli since
then. PDO is a pleasure to work with :)

Hi guys,
Just a quick question. I've recently been looking at changing over
our code to use the PDO interface to a mysql database.

Currently we are using MySQLi but after looking at the PDO interface i
personally prefer the way API is presented (not saying mysqli is bad
or anything like that...completely personal). I was just wondering if
there was any performance or latency hit by using PDO with mysql 5.

From what i have benchmarked there isn't any at all, but since PDO
came back faster for a few things i'm not sure how accurate my
benchmarks were =)

Just looking for some feedback.

many thanks
Andrew

--

--
Alexey Zakhlestin
http://blog.milkfarmsoft.com/

Andrew Mason wrote:

Hi guys,
Just a quick question. I've recently been looking at changing over
our code to use the PDO interface to a mysql database.

Currently we are using MySQLi but after looking at the PDO interface i
personally prefer the way API is presented (not saying mysqli is bad
or anything like that...completely personal). I was just wondering if
there was any performance or latency hit by using PDO with mysql 5.

From what i have benchmarked there isn't any at all, but since PDO
came back faster for a few things i'm not sure how accurate my
benchmarks were =)

Just looking for some feedback.

many thanks
Andrew

I have not done the benchmark recently, but here is what I found last
year. It just depends on what is important to you.

http://dealnews.com/developers/php-mysql.html

--

Brian Moon
Senior Developer

http://dealnews.com/
It's good to be cheap =)