php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: christopher dot jones at oracle dot com
New email:
PHP Version: OS:

 

 [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.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Thu Nov 21 13:01:29 2024 UTC