I am trying to display 4 columns of a particular table. The browser
is displaying 50 records per page. 'Next' and 'Previous' buttons are
there for navigating through all the records. It may have even 1
million or more records. The table may have n number of records. I am
not getting any problem if the record size is approximately 50,000.
But for large number of records say, 1 lac or more, the browser is
taking too much time...roughly, for 1 lac record it is taking 35
seconds and for 2.5 lac record it is taking 4 minutes...as the no of
records fetched increases...page loading time also increases
exponentially. So, my aim is to collect partial data from the table
and display it. In oracle I can manage it using rownum and minus
clause, efficiently. But in SQL Server I am not able to handle it,
using those technique. My application runs both on Oracle and SQL
Server. Can anybody help me?
For more clarity :::: I want to collect 1 to 50 records from the
table. next time I want to collect records from 51th. position to
100th. position. And then from 101th. position to 15oth. and so on.
Of course in SQL Server.
I am writing my code in JSP.
[ July 21, 2005: Message edited by: samit majumdar ]