SQL Database Paging with the Seek Method
Use the search form above, coupled with an extremely efficient pagination solution, to navigate Microsoft's Northwind Database.
This demo utilizes the Seek method, also referred to as Keyset Pagination, to harness the power of optimized indexes when querying the database.
The notable speed, scalability, and data integrity, combine to provide the perfect solution for shared multi-user environments with dynamic underlying data.
Please view the videos below highlighting the Seek method's advantages over traditional "Row Counting" SQL strategies like the Offset Fetch clause.
Feel free to Contact Harry Duvauchelle with any questions or comments. Thank you.
An overview highlighting the advantages of this applications unique paging and sorting system:
- Fast and Accurate Results
- Filterless Search Results
- Relational Sorting
- Detailed View
Comparing the queries.
Evaluating the Seek and Offset execution plans in SQL Server.
- Seek is significantly faster than Offset.
- Seek scales exceptionally well as the 100th page is as fast as the 1st.
Seek Vs. Offset!
A side by side comparison of Seek's consistent results to Offset's lack of data integrity when using dynamic underlying data.
Use the Demo and test it yourself.
Search without filters and quickly page through the entire database index.
- Next button gets results greater than the last record in the previous page.
- Previous button gets results less than the first record in the previous page.
A unique way to functionally re-sort results from both the master and detailed view.
- You select the field AND its value for the re-sort query parameters.
- Your results are re-sorted around values from the selected record.
An elegant master-detailed interface.
- Page through the detailed view without drilling down.
- Re-sort results around the record you are viewing to keep your place in the new index.
Please understand, if there are speed issues, this app is hosted on an economy hosting plan intended to simply compare the Seek method to row counting queries.