note 87118 deleted from function.oci-fetch-all by sixd
| From: | sixd@php.net | Date: | Sat, 21 Nov 2009 00:02:01 +0000 |
| Subject: | note 87118 deleted from function.oci-fetch-all by sixd | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-163161@lists.php.net to get a copy of this message | ||
Note Submitter: sixd at php dot net
----
Avoid using the "skip" and "maxrows" parameters. The function works by fetching
and discarding all rows up to the "skip'th" row. This wastes network and CPU. It is
better to rewrite the query and use ROWNUM (or similar) to limit the rows the DB returns.