Hi people.

I'm implementing some apps using Oracle as database, and i want yours opinions about what DB Adapter is the best for use, the Oracle (Zend_Db_Adapter_Oracle) or PDO_OCI (Zend_Db_Adapter_Pdo_Oci)? I mean in performance, security and others elements.

Thanks.

I wrote a database speed test script a few weeks ago, that measured the elapsed time for running a query 5 times and iterating over the result set each time. The result set in my case contained somewhere around 13.000 rows.

I ran this three times and averaged I got these results:
- Direct Oracle: 3.30 seconds
- Direct PDO: 1.20 seconds
- ADOdb + Oracle: 5.32 seconds
- Zend_DB + Oracle: 4.11 seconds
- Zend_DB + PDO: 1.83 seconds

So I'm going with PDO.

Hum, quite interesting, thanks for sharing this.

In another forum a guy say something diferent, but i'll check it better.

Thanks.

I'm reading "The Underground PHP and Oracle Manual" and found this:

"If you want to make full use of Oracle features and want high performance use PHP’s
main Oracle extension, the OCI8 extension."

Page 13. I'm confused now ;D

Well, since it's trivially easy to switch between PDO and OCI8 when you're using Zend_DB, I suggest you build your app, and then, when it's done, benchmark it using both PDO and OCI8 as back-end engine. This way you know for sure.

All I can tell you is what I observed for my particular test case.

Ok, and i apreciate that, thanks!