php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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

Add a Patch

Pull Requests

Add a Pull Request

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.


 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue Mar 19 06:01:30 2024 UTC