oci_set_prefetch_lob

oci_set_prefetch_lob

Sets the amount of data prefetched for each CLOB or BLOB.

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 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. oci_execute

The value affects LOBs returned as OCILob instances and also those returned using . OCI_RETURN_LOBS

Call before calling . If it is not called, the value of is used. oci_set_prefetch_lob``oci_executeoci8.prefetch_lob_size

The LOB prefetch value should only be set with Oracle Database 12.2 or later.

statement``prefetch_lob_sizeThe number of bytes of each LOB to be prefetched, >= 0

return.success

Voorbeeld: Changing the LOB prefetch value for a query

<?php

$conn = oci_connect('hr', 'welcome', 'localhost/XE');

$stid = oci_parse($conn, 'SELECT myclob FROM mytable');
oci_set_prefetch_lob($stid, 100000);  // Set before calling oci_execute()
oci_execute($stid);

echo "<table border='1'>\n";
while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS+OCI_RETURN_LOBS)) {
    echo "<tr>\n";
    foreach ($row as $item) {
        echo "    <td>".($item !== null ? htmlentities($item, ENT_QUOTES) : "nbsp")."</td>\n";
    }
    echo "</tr>\n";
}
echo "</table>\n";

oci_free_statement($stid);
oci_close($conn);

?>

oci8.prefetch_lob_size