I've just got back from delivering my Working with PHP and Oracle presentation at the Melbourne Opensource Developers' Conference. I don't think the organisers are going to post the presentations, so I wanted to make it available here. This talk covers:
- Free Oracle tools
- OCI8 extension
- Connection management (including the new connection pooling feature)
- Improving performance
- XML
- Oracle resources
Comments (5)
Hey Alison,
How does PHP fit into Oracle's fusion vision with Java, J2EE web services etc. Is PHP becoming a key technology, or is it going to remain niche?
Posted by Kirk Brocas | December 7, 2006 12:16 AM
Posted on December 7, 2006 00:16
Hi there Kirk. Hope your world is sunny and bright. Oh, it's my world too. We're both in Melbourne! :-)
PHP doesn't fit into Project Fusion. Fusion is Fusion. J2EE is J2EE. What we're doing with PHP here is to help the PHP community to work with Oracle. There are no plans to include PHP in our own technology stack, other than to support our customers who are using it.
Posted by Alison Holloway | December 7, 2006 12:38 AM
Posted on December 7, 2006 00:38
Thanks Alison. Just couldn't see where PHP fitted into the picture. And yes, the world is sunny and bright here. That's because there is no ozone!
Posted by Kirk Brocas | December 7, 2006 3:22 AM
Posted on December 7, 2006 03:22
Wish I could have attended your presentation. OSDC looked like fun.
I was looking at your presentation, and was a little confused by the statement on p15 "PHP enhancements described here are proposed". Did that just pertain to the Database Resident Connection Pooling section? It looks like great things are in the plans.
I am looking to tune my persistent connections from the PHP side and am not sure entirely how it acts if I set oci8.max_persistent or oci8.persistent_timeout.
Posted by Alton Crossley | January 25, 2007 1:15 PM
Posted on January 25, 2007 13:15
Yes, the Database Resident Connection Pooling is a new feature, and that's what the note relates to. Everything else in that presentation already exists in the PHP driver.
Setting oci8.max_persistent sets the maximum number of persistent connections the web server will allow at any one time.
Setting oci8.persistent_timeout sets the time the persistent connections will live for. You'll need to do some testing and tweaking so you can get the load right for your application and server.
Alison
Posted by Alison Holloway | January 31, 2007 1:41 AM
Posted on January 31, 2007 01:41