Statement cache is flushed too frequently

Bug #41594	Statement cache is flushed too frequently
Submitted:	2007-06-05 00:50 UTC	Modified:	2007-06-05 07:49 UTC
From:	christopher dot jones at oracle dot com	Assigned:
Status:	Closed	Package:	OCI8 related
PHP Version:	5.2.3	OS:	Linux x86
Private report:	No	CVE-ID:	None

[2007-06-05 00:50 UTC] 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.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports

[2007-06-05 07:49 UTC] tony2001@php.net

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.