Re: Limiting Large Result Sets

From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: 29 Aug 2006 15:46:10 -0700
Message-ID: <1156891569.920865.203570@i42g2000cwa.googlegroups.com>

smartnhandsome_at_gmail.com wrote:
> Hi,
>
> I would be glad if someone could provide solution for this problem.
>
> working ENV:
> Jdeveloper 10.1.3 - Development
> Oracle 9i - Database
> Windows XP - OS
>
> I want to retrieve about 30 rows at a time . The table contains over 2
> million rows. I would like to begin at the first row and drag 30 rows
> over the network. Then get the next 30 and repeat the process untill
> all rows are displayed.
>
> (snip)

I'm curious - what are you doing with the 2 million rows that you fetch? (Can't really think of anyone wanting to look at 2 million records at once :) )
Also 30 rows at a time for 2 million rows seems a bit a off-scale to me.

best,
Martin Received on Tue Aug 29 2006 - 17:46:10 CDT