Re: Cursor without a where clause...

Hi.

 Try closing the cursor every N rows and re-opening it again ( starting  at close position ).
 You have to re-code your application ( keep the row identification  somewhere ).

 HTH. Michael

In article <8djsrd$upm$1_at_nnrp1.deja.com>,   justvrk <justvrk_at_my-deja.com> wrote:
> Hello:
> I am stuck up with a performance problem involving a cursor.
> I am moving data from a huge table ( rows > 300,000,000 ) with
 business
> validation done through a set of plsql procedures. Till date I am
> unable to complete the full move in one step. I am opening a cursor on
> the huge table without any WHERE clause, and because of which things
> are slowing down.
> I have tested with small chuck of data in steps and the completion
> time is rising exponentially. like 5 mins for the first 100000 recs,
 15
> mins for first 200000 recs and so on.
> Can someone suggest me any hints to speed up this blind cursor
> method ? Also I am thinking about partitioning the table but I am not
> sure whether this will be of any help.
>
> Thanks in Advance.
> justvrk
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Apr 22 2000 - 00:00:00 CDT