#41594 [Opn->Csd]: Statement cache is flushed too frequently

ID: 41594 Updated by: tony2001@php.net 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