Re: Forms - Dev 2K

In article <586u51$dv2_at_gulfa.kuwait.net>, mtcsp_at_kuwait.net (Lucky) wrote:
>
> I have a table of 6000 Rec. I want to fetch at a time
> 10 records, when the last record is reached I want to fetch the next
> set.
> Initially for the first set of 10 records, response is fast, but it
> starts
> decreasing exponentially. The table is indexed with the primary key.
> The block

This is because they are being stored on your PC and when your PC runs out of memory it starts hitting the disk.

> property (records fetched = 10, and records buffered = 10 ). By the
> time I reach to the 50th record time increases to 1 min and it kept on
> increasing.
>
> Any help will be appriciated. Thanks for your time.
>
> Sarosh

What are you trying to do ?

Mike Collins - Factograde Computing Ltd
Independent Oracle Consultancy Received on Thu Dec 05 1996 - 00:00:00 CET