ID:               41594
 Updated by:       [EMAIL PROTECTED]
 Reported By:      christopher dot jones at oracle dot com
-Status:           Open
+Status:           Closed
 Bug Type:         OCI8 related
 Operating System: Linux x86
 PHP Version:      5.2.3
 New Comment:

This bug has been fixed in CVS.

Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
 
Thank you for the report, and for helping us make PHP better.




Previous Comments:
------------------------------------------------------------------------

[2007-06-05 00:50:09] christopher dot jones at oracle dot com

Description:
------------
In oci_statement.c both calls to OCIStmtRelease() pass the
OCI_STRLS_CACHE_DELETE flag. This means the statement cache (configure d
with oci8.statement_cache_size) is flushed.  There should be no reason
to flush the cache at these points.  

The fix is to change both OCI_STRLS_CACHE_DELETE flags to OCI_DEFAULT.

With this change even a simple script repeating one statement in a loop
proves Oracle is able to use the cache, reducing the number of times the
statement is parsed by the DB.

The change will also benefit users of persistent connections.



------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=41594&edit=1

Reply via email to