svn: /phpdoc/en/trunk/reference/oci8/functions/ oci-set-prefetch.xml

From: Date: Fri, 13 Nov 2009 23:57:53 +0000
Subject: svn: /phpdoc/en/trunk/reference/oci8/functions/ oci-set-prefetch.xml
Groups: php.doc.cvs 
Request: Send a blank email to doc-cvs+get-5381@lists.php.net to get a copy of this message
sixd Fri, 13 Nov 2009 23:57:53 +0000 Revision: http://svn.php.net/viewvc?view=revision&revision=290726 Log: add note about LOB & LONG cols Changed paths: U phpdoc/en/trunk/reference/oci8/functions/oci-set-prefetch.xml Modified: phpdoc/en/trunk/reference/oci8/functions/oci-set-prefetch.xml =================================================================== --- phpdoc/en/trunk/reference/oci8/functions/oci-set-prefetch.xml 2009-11-13 23:48:34 UTC (rev 290725) +++ phpdoc/en/trunk/reference/oci8/functions/oci-set-prefetch.xml 2009-11-13 23:57:53 UTC (rev 290726) @@ -34,17 +34,17 @@ re-executed statements or by other connections. </para> <para> - Call <function>oci_set_prefetch</function> before - calling <function>oci_execute</function>. + Call <function>oci_set_prefetch</function> before + calling <function>oci_execute</function>. </para> <para> - A tuning goal is to set the prefetch value to a reasonable size - for the network and database to handle. For queries returning a - very large number of rows, overall system efficiency might be - better if rows are retrieved from the database in several chunks - (i.e set the prefetch value smaller than the number of rows). - This allows the database to handle other users' statements while - your script is processing the current set of rows. + A tuning goal is to set the prefetch value to a reasonable size for + the network and database to handle. For queries returning a very + large number of rows, overall system efficiency might be better if + rows are retrieved from the database in several chunks (i.e set the + prefetch value smaller than the number of rows). This allows the + database to handle other users' statements while your script is + processing the current set of rows. </para> <para> Query prefetching was introduced in Oracle 8i. REF CURSOR @@ -52,10 +52,13 @@ linked with Oracle 11gR2 Client libraries and connected to 11gR2 or previous versions of the database. Nested cursor prefetching was introduced in Oracle 11gR2 and requires both the Oracle Client - libraries and the database to be version 11gR2. The prefetch value - is ignored and single-row fetches will be used when prefetching is - not supported. + libraries and the database to be version 11gR2. </para> + <para> + Prefetching is not supported when queries contain LONG or LOB + columns. The prefetch value is ignored and single-row fetches will + be used in all the situations when prefetching is not supported. + </para> </refsect1> <refsect1 role="parameters">

« previous php.doc.cvs (#5381) next »