oci driver performance

From: Date: Thu, 16 Oct 2008 23:22:33 +0000
Subject: oci driver performance
Groups: php.db 
Request: Send a blank email to php-db+get-45533@lists.php.net to get a copy of this message
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. -- Postgresql & php tutorials http://www.designmagick.com/

« previous php.db (#45533) next »