note 87118 added to function.oci-fetch-all
| From: | sixd@php.net | Date: | Thu, 20 Nov 2008 02:24:43 +0000 |
| Subject: | note 87118 added to function.oci-fetch-all | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-146735@lists.php.net to get a copy of this message | ||
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.
----
Server IP: 69.147.83.197
Probable Submitter: 148.87.1.170
----
Manual Page -- http://www.php.net/manual/en/function.oci-fetch-all.php
Edit -- https://master.php.net/note/edit/87118
Del: integrated -- https://master.php.net/note/delete/87118/integrated
Del: useless -- https://master.php.net/note/delete/87118/useless
Del: bad code -- https://master.php.net/note/delete/87118/bad+code
Del: spam -- https://master.php.net/note/delete/87118/spam
Del: non-english -- https://master.php.net/note/delete/87118/non-english
Del: in docs -- https://master.php.net/note/delete/87118/in+docs
Del: other reasons-- https://master.php.net/note/delete/87118
Reject -- https://master.php.net/note/reject/87118
Search -- https://master.php.net/manage/user-notes.php