note 87118 added to function.oci-fetch-all

From: 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

« previous php.notes (#146735) next »