Let’s say I want to fetch the data from database and transform them and display in UI
As many said The main reason to do pagination is not really because it makes sense to only display a few entries in the UI at once. Instead, pagination allows you to only transfer the necessary entries from large data sets. But the problem is Let’s say I have 30 K records and I only show 1000 entires at UI at once using paginantion the problem arises when user filters or sorts or serahc anything is shown (We have 18 columns with search and filtering on all) in this case I need to deal with whole database to do this and Paginantion does’nt help here or is there a better way ?

Currently we load the entire dataset and do filtering, searching and sorting it works fine but how to do it with pagination.

Currently we load the entire dataset and do filtering, searching and sorting it works fine but how to do it with pagination.