Getting heap size error stating 'Apex heap size too large: 6271211'. Please help me in getting this

Hi, Actually I have got a problem here. When I load a good number of data (for ex, even 17,000 records) on my skuid page, then it shows the heap size error stating ‘Apex heap size too large: 6271211’. Please help me in getting this resolved.

Salesforce imposes limits on how much you can query at one time. Limit the number of rows in your model.

Alternatively, you may be able to remove unnecessary, large fields from the model since the heap size is affected by both the width and depth of the model. You can also look at conditions and filters to reduce the number of rows retrieved.

If it is necessary to pack your page with 17,000+ records, some javascript gurus have posted a method for starting with a limited query and retrieving in blocks until all matching records are found. I think an example was posted in the community within the last 6 months (Sep 2018 - Mar 2019).