Contents
What is Salesforce Governor limit?
Simply put, Salesforce Governor Limits are usage caps enforced by Salesforce to ensure efficient processing. They allow for multiple users of the platform without impeding performance. There are many different types of governor limits, some of which are tied to your Salesforce edition.
How do I find the governor limit in Salesforce?
Follow this process to meet the governor limits in Salesforce:
- Do not have DML statements or SOQL queries in our FOR loop.
- Try not to use SOQL or DML operations in the loop.
- Try to bulkify the code and helper methods.
- Query large data sets.
- Use Batch Apex if we want to process 50,000 records.
What are Governor limits for DML statements?
Major Governor Limits
| Overview | Governor Limit |
|---|---|
| Total number of SOSL queries issued in Salesforce | 20 |
| DML Governor Limits in Salesforce (Total number of issued statements per transaction) | 150 |
| Total number of records retrieved by a single SOSL query | 2000 |
| Total number of records that were retrieved by SOQL queries | 50000 |
What can I do about the Governor limit in Salesforce?
A simple solution is simply to move all SOQL statements outside of for loops, and especially if the for loop iterator is dynamic (the number of accounts in the list could change but if the iterator is a number, then that is fixed). To do that, you’ll likely be depending more on other collections and inventive SOQLs.
When do you hit the soql query limit?
This example shows how SOQL query limit can be reached − The following trigger iterates over a list of customers and updates the child record’s (Invoice) description with string ‘Ok to Pay’. When the ‘updateCustomerDescription’ method is called and the number of customer records are more than 100, then it will hit the SOQL limit.
Are there governor limits for an anonymous script?
One of the most well known governor limits is that an apex class / execute anonymous script can ‘only’ have 100 SELECT statements per apex transaction. By the way, an apex transaction is a set of operations that are executed in a single unit.
How to avoid the limit error in apex Governer?
As we have seen, the trigger design pattern helps avoid the limit error. We will now see other important limits. You can issue only 100 queries per transaction, that is, when your code will issue more than 100 SOQL queries then it will throw error. This example shows how SOQL query limit can be reached −