Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Slow cursor performance.
Precisely, and that's why PL/SQL always runs in ALL_ROWS mode
unless explicitly hinted otherwise.
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message news:aplos4$pns$1_at_ctb-nnrp2.saix.net...Received on Tue Oct 29 2002 - 06:21:31 CST
>
> How fast does it take for it to complete processing of the first row? Does
> the hint you use make the second row or 20th or 1000th row available as
> fast? How long does your code take before asking for the 1000th row?
>
> Oracle is giving you the first row as fast as possible - the intention being
> that while you are looking at the first few rows for some seconds or
> minutes, it can process and find the rest of the rows matching your
> criteria.
>
> Your code is likely spending less than a few ms per row, before asking the
> next one. Which means that finding the first row as fast as possible is a
> bit pointless as your code does not spend any significant amount of time
> dealing with the first row (like a user would staring at the screen in
> Toad).