Rad Server - return a large number of records

Question

I plan to create a Rad server project (Rest) and ask a question that I could not find the answer. Is there a way to send records to the client as pages using EMS components, if I have millions of records in a table. if not in this case, what methods can be used?

Edit: There is a table with millions of records, and the user is about to filter and query the records. Is there a way to record paging in Rad Server if the user has not done good filtering and the query returns more records than expected?