I have an employee table with say 50,000 records on the Webbased SQL Server and I want to display only 10 records at a time on the client side using ASP page or any other mechanism.

All the articles I have read so far suggest, to execute "Select * from Employee" every time a user navigates and using the PageSize, AbsolutePage & pagecount properties to get the respective 10 records.

I think rReturning 50,000 recording for each request will affect the performance significantly.

Any comments or any other better ways?