|
oci_set_prefetch_lobSets the amount of data prefetched for each CLOB or BLOB. Description
bool oci_set_prefetch_lob(resource
$statement , int $prefetch_lob_size )Sets the internal buffer size used to fetch each CLOB or BLOB value when the implementation gets the internal Oracle LOB locator from the database after a successful query call to oci_execute and for each subsequent internal fetch request to the database. Increasing this value can improve the performance of fetching smaller LOBs by reducing round-trips between PHP and the database. Memory usage will change.
The value affects LOBs returned as OCILob instances and also those returned
using Call oci_set_prefetch_lob before calling oci_execute. If it is not called, the value of oci8.prefetch_lob_size is used. The LOB prefetch value should only be set with Oracle Database 12.2 or later. Parameters
Return Values
Returns Examples
Example #1 Changing the LOB prefetch value for a query
|