Max # Of records (limit)

  • 1
  • Question
  • Updated 2 months ago
  • Answered
For a module what will be the Max # of records Limit, we can extract? If we extract more records it that will impact the performance of the page?
Photo of Lahari

Lahari

  • 206 Points 100 badge 2x thumb

Posted 3 months ago

  • 1
Photo of Zach McElrath

Zach McElrath, Employee

  • 48,984 Points 20k badge 2x thumb
Are you talking about Salesforce Models? If so, the Maximum number of records that a Model can retrieve is limited by the "Heap Size" limit in Salesforce. Functionally this can be totally different depending on the number of fields in your Model and how much data is in each field. For example, for a Model on the Account object selecting just the Name, Type, and Id fields, you can likely retrieve 1000's of Accounts before hitting the heap size limit, but if you're retrieving 100 fields on the Case object, including some Long Text Fields like "Description" with lots and lots of data in them, you might only be able to retrieve 500 Cases before hitting the heap size limit. These numbers are all just chainsaw-math of course, but the point is that "it depends" on the number of fields in your Model and what data is in those fields.
Photo of Lahari

Lahari

  • 206 Points 100 badge 2x thumb
Thanks Make sense 
Photo of Lahari

Lahari

  • 206 Points 100 badge 2x thumb
Is Load More Option is Out of the box of SKUID? To what extent it can load ?

 
Photo of Matt Davis

Matt Davis, Employee

  • 488 Points 250 badge 2x thumb
I believe 10k records is the wall you end up hitting on the Salesforce end.

Also worth noting you can get similar functionality with the load all remaining records javascript in Skuid. We have a page where we needed as many records as we could get, but get the heap error at ~600 records. So instead we have it limited to 500 records and use load all remaining records on page load to get 10k records.
Photo of Lahari

Lahari

  • 206 Points 100 badge 2x thumb
Thanks