General information
Category:
Internet applications
Title:
Paging through ADO Recordset
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?
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only