Chris wrote:
Hi all,
Using php 5.2.6 + oci driver 1.3.4 from pecl
Has anyone had any issues with the oci8 driver performance?
I'm doing some profiling using xdebug and all of the time seems to be
spent in oci_execute and oci_fetch_array. This shows up when I use
jmeter to hit the app pretty hard.
The data being returned is quite small (returning 10 rows) and the
queries themselves are fast when run manually (or even through a
separate script). They are fetching a lot of columns however.
I eventually found the http://php.net/oci_internal_debug function and it
shows a lot of OCIAttrGet calls.
When I look at the oracle side of things, it's processing a lot of stuff
but it's not out of control.
I'm not sure what else to include so any suggestions/comments etc are
most welcome.
Thanks.
The oci_execute oci_fetch_array calls will take the bulk of the time
because there isn't much else to do for a query. Execution will, of
course, take time while the DB is processing the query. So eliminate
the DB configuration, character set conversion, etc as a cause first.
The OCIAttrGet call are local calls and not the relatively expensive
round-trip calls to the DB.
Your comment about a lot of columns doesn't match the test you sent me
offline: it only queries two columns.
Chris
--
Email: [EMAIL PROTECTED] Tel: +1 650 506 8630
Twitter: http://twitter.com/ghrdFree PHP Book: http://tinyurl.com/f8jad
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php