Hi Everybody!!!

Issue1)I have to cache 20 lac records,

Issue2)I am using oracle as database,now i need to retrieve specified number of rows from the table (e.g select * from table where rownum>10 and rownum<45)


it will take time to retrieve and populate the dataset these 20lac records,How I can do it.
Is there any other way to solve this .
Also is there any way to solve (2) issue



Cheers :)

vinod

__________________
Cheers :)

vinod