Re: cursor result return

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 23 Feb 2005 09:31:54 -0800
Message-ID: <1109179735.764933@yasure>

Cris Carampa wrote:

> DA Morgan wrote:
>

>>> Doesn't it depend upon the number of columns selected? It takes 7 
>>> seconds here (9.0.1.3 on Linux) for a "select * from 4352-rows-table" 
>>> and 1/3 second for a "select 1 from same-table".
>>>
>>> Kind regards,
>>
>>
>>
>> Unbelievably slow.

>
>
> I was talking about typing "select * from test_table" in SQL*Plus and
> waiting for all the rows to scroll across the screen, not about running
> the PL/SQL block. Of course the PL/SQL block is faster. I tried your
> code and got the same timing as you (BTW the OP's PL/SQL block took 588
> seconds to complete, so my guess was that 9 seconds was the time taken
> by SQL*Plus to display 4000 records on the screen, which seems to me an
> acceptable time if * = <lot of columns>).
>
> Kind regards,

Any time SQL*Plus takes a long time to scroll records there is a simple solution ... either minimize SQL*Plus or ALT-TAB to a static page that obscures SQL*Plus.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Wed Feb 23 2005 - 11:31:54 CST