PAGINATION is the concept of splitting a larger data set into several smaller sets before transferring and displaying to the user. What this means is that instead of sending large bulks of information across the wire, that would otherwise consume a lot of resources (network traffic, memory/cache etc), we split the large bulks into smaller manageable chunks and only handle as much data that is needed.

Pagination can be seen everywhere; from Blogs and Forums, to News sites. All these use some form of pagination or another. Without pagination Forums would be showing thousands of topics at once instead of showing 20 topics per page; Blogs would be showing hundreds of blog posts per page instead of 10 posts per page. News sites… well.. they would take a rather long time to load if they displayed all of articles at once!

There are several forms of Pagination available; and no doubt you would have come across one or more already:

  • The first is what I refer to as Preemptive Loading
  • The second is On Demand Loading

In this article I will explain each of these in detail. I will explain the short comings of Preemptive Loading, and the benefits of On Demand Loading; and also explain how On Demand Loading can be achieved via SQL Server…

Continue reading “Pagination and Sorting via SQL” »