Pagination is server-side for standard and custom objects — only the records for the current page are retrieved, optimizing performance and reducing memory usage.

For Salesforce Big Objects, pagination is client-side, since Salesforce doesn't support the OFFSET clause for Big Objects. The full result set is returned and Query Manager paginates locally. Use LIMIT to control how many records are retrieved.