In terms of the general use cases (anything documented in the manual,
Zend_Db_Table, Zend_Db_Select) - you will see no discernible difference.
The only time you'll see any differences is if you are using extension
specific features.
I suggest you have a look at the chart at the bottom of this page:
http://us3.php.net/manual/en/mysqli.overview.php
This will give you a better idea for what goes on under the hood in
Zend_Db_Adapter_Mysqli and Zend_Db_Adapter_Pdo_Mysql.
Beyond that, both extensions are as available on all platforms I've
seen, so either choice is good, and generally, switching in mid-stream
is a piece of cake.
-ralph
Ross Little wrote:
Hi Guys
I'm relatively new to ZF, but it seems that just about every tutorial out
there uses the Mysqli adapter but everywhere else, I read about how much
more secure and efficient the PDO adapter is. Is this true?
In order to take advantage of PDO, do I only need to change my
resources.db.adapter in my application.ini file? I tried this and I didn't
notice any difference. I mean, i don't imagine it'll make a discernable
difference on my development version of the code, but it didn't break
anything.
Any thoughts?
Ross
