Sounds like you are using client-side rendering, which is trying to render all of those records at once to the client. I would recommend initializing server-side rendering on your front end, using for instance, DataTables js, or similar library for displaying the data. DataTables would then make Ajax requests to your server for each draw of the table. While not necessarily having finite control over the number of records returned, it would generally only return the records being visibly displayed on the screen. You would, however, have to handle the logic for pagination, sorting and searching on the server, as these functionalities would no longer be managed client-side.