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.

Thanks Make sense 

Is Load More Option is Out of the box of SKUID? To what extent it can load ?

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.

Thanks