Limit sql data for each page in application

Question

I have 5000 rows of data for a company in SQL but when I open the companies data in my app I don't want to bring all 5000 right away, I want to only bring like 100 for the first page and then when I go to the next page it brings the next 100 rows and so on. Is there a way to do that so I don't have to bring all 5000 and my app crashes?

Answer 1

It depends on your application.

Assuming you are using C#/.Net see:

https://learn.microsoft.com/en-us/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/sorting-filtering-and-paging-with-the-entity-framework-in-an-asp-net-mvc-application

https://learn.microsoft.com/en-us/aspnet/web-forms/overview/data-access/paging-and-sorting/efficiently-paging-through-large-amounts-of-data-cs

Answer 2

Hi @austin branham ,

We recommend that you use the OFFSET and FETCH clauses instead of the TOP clause to implement a query paging solution and limit the number of rows sent to a client application. Refer to MS document Using OFFSET and FETCH to limit the rows returned.

Suggest you reading below blog or below similar thread to get detail examples about this. If I misunderstood your question, please let me know.

Pagination in SQL Server
What is the best way to paginate results in SQL Server

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".