Skip to main content


 

Symptoms


What's the maximum number of records I can LIST from a smartobject? I have a table of 19,000 records which contains a column I want to use as possible AutoComplete values.

Does the AutoComplete only return 100 search results? We would love to use this control as an "as-you-type" search.
Also, where in the Salesforce Instance can I modify it to return batch sizes larger than 250?
 

Diagnoses


There is no maximum to the number of records a smartobject can list. However, the more records pulled back by a get list method, the bigger the performance hit.
 

Resolution

The AutoComplete control only brings back a maximum of 100 results. The more letters typed in, the less results you have, and within a couple of letters you can get past the 100 object limit.

The default batch size for a query from Salesforce is 500. This is not configurable as a default. However you can increase this up to 2000, but for performance reasons there is no guarantee that it will be the actual batch size.




 
Be the first to reply!

Reply