Hello,



I'm using server side cursor in my component to retrieve data from database

and display it back to client. But when the page size is very large ( say

1000 records/ page)

and if the no. of pages are say more than 1000, then when i try to go from

first page to last page it throws a time out error.

I'm not dividing the recordset into logical pages (using PageSize,

AbsolutePage , AbsolutePosition properties etc. of the recordset) instead

i'm using simple move commands

to move through the recordset.



So if the efficiency will be increased if i divide the recrdset into logical

pages, or is there some other way out to increase the efficiency of my

component ?





regards

Manish