Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
samit_java
Starting Member
4 Posts |
 Posted - 2005-07-21 : 02:50:11
|
| 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.Thanks -Samit |
|
|
AndyB13
Aged Yak Warrior
583 Posts |
|
|
|
|
|
How to retrieve partial records from a table
