How to overcome governor limits in salesforce


How do I overcome governor limits in Salesforce?

  • Log in to Salesforce as an administrator user.
  • From Setup, enter Users in the Quick Find box, then select Users.
  • Click Edit next to the name of the user to receive the email notifications.
  • Select the Send Apex Warning Emails option.
  • Click Save.
How can you avoid Salesforce Governor Limits?
  1. Do not have DML statements or SOQL queries in our FOR loop.
  2. Try not to use SOQL or DML operations in the loop.
  3. Try to bulkify the code and helper methods.
  4. Query large data sets.
  5. Use Batch Apex if we want to process 50,000 records.
  6. Streamline various triggers on the same object.
Mar 7, 2022


Table of Contents

What is a governor limit in Salesforce?

So, governor limits regulate what your code can do when it is run on the Salesforce platform. And this in turn helps the scalability of the platform since the resources are predefined. Quality Clouds helps customers understand their Governor Limit usage and take corrective actions to optimize their Salesforce orgs.

What are governor limits and how do they work?

Due to the nature of multitenancy and the fact we are sharing resources, governor limits are in place to ensure that any Apex we develop, does not monopolize the shared resources we are allocated. Imagine this: there are 100 flats in a single apartment building. The 100 flats share resources: water, electricity, gas and wi-fi bandwidth.

Why is my Governor limit so high in apex?

Most commonly, this governor limit will be hit because there is a SOQL statement in a for loop; which is considered one of the ‘cardinal sins’ of programming in Apex.

What happens when code exceeds a limit in Salesforce apex?

If code exceeds a limit, the associated governor issues a runtime exception. The Salesforce Apex limits/governors track and enforce the statistics outlined in the following tables and sections. This table summarizes the limits for some features in the Salesforce application by edition.


How can you avoid exceeding governor limits?

Best Practices to Avoid Governor LimitsBulkify your code.Avoid SOQL queries or DML statements inside For loops.Bulkify your helper methods.Use collections, streamlining queries, and efficient For loops.Streamline multiple triggers on the same object.Query large data sets.More items…

What happens when Governor limits in Salesforce?

If a Salesforce Governor Limit is hit, the associated governor issues a runtime exception that cannot be handled. In other words, your code breaks and won’t work.

How can a developer avoid exceeding the governor limits when using an Apex trigger?

One Trigger Per Object. … Logic-less Triggers. … Context-Specific Handler Methods. … Bulkify your Code. … Avoid SOQL Queries or DML statements inside FOR Loops. … Using Collections, Streamlining Queries, and Efficient For Loops. … Querying Large Data Sets. … Use @future Appropriately.More items…•

What happens when Governor limits are exceeded?

Because Apex runs in a multitenant environment, the Apex runtime engine strictly enforces limits so that runaway Apex code or processes don’t monopolize shared resources. If some Apex code exceeds a limit, the associated governor issues a runtime exception that can’t be handled.

How do I get more than 50000 records in Salesforce?

You cannot retrieve more than 50,000 records your SOQL calls in a single context. However, with Batch Apex your logic will be processed in chunks of anywhere from 1 to 200 records in a batch. You’d need to modify your business logic to take the batching into account if necessary.

How you make sure Governor Limit won’t be hit in Salesforce in the code?

How to avoid Governor LimitsAvoid DML Statements and SOQL queries within the For Loop.Make sure that the apex code manages more than one record at a time.For loops, we should use collections.Streamline different triggers over the same page.

How do I resolve too many SOQL queries 101 in Salesforce?

Resolve the “Too many SOQL queries: 101” error To fix the issue, change your code so that the number of SOQL fired is less than 100. If you need to change the context, you can use @future annotation which will run the code asynchronously.

Can we have two triggers on same object?

Multiple Triggers on the same object Writing multiple triggers renders the system unable to recognize the order of execution. Moreover, each trigger that is invoked does not get its own governor limits. Instead, all code that is processed, including the additional triggers, share those available resources.

Why there is governor limits in Salesforce?

Governor Limits in Salesforce are the runtime limits enforced by apex runtime engine to write scalable and efficient code. Because apex runs in a multitenant environment, the Apex runtime engine strictly enforces limits to ensure that runaway Apex code or processes do not monopolize shared resources.

How do I query more than 10000 records in Salesforce?

You could use batch apex, and it is the only way by which you can query some millions of records without hitting the governor limits. You can find the document for writing batch apex here. Thanks. you can fetch the records in batches in 200 (the implicit query more pattern).

What is the governor limit for maximum CPU time on the Salesforce server issue?

Per-Transaction Apex LimitsDescriptionSynchronous LimitAsynchronous LimitMaximum CPU time on the Salesforce servers 510,000 milliseconds60,000 millisecondsMaximum execution time for each Apex transaction10 minutes10 minutesMaximum number of push notification method calls allowed per Apex transaction101016 more rows

Is SOSL faster than SOQL?

Both SOQL WHERE filters and SOSL search queries can specify text you should look for. When a given search can use either language, SOSL is generally faster than SOQL if the search expression uses a CONTAINS term.

Why is it important to use Apex collections?

It is important to use Apex Collections to efficiently query data and store the data in memory. A combination of using collections and streamlining SOQL queries can substantially help writing efficient Apex code and avoid governor limits

What is an Apex trigger?

A single Apex Trigger is all you need for one particular object. If you develop multiple Triggers for a single object, you have no way of controlling the order of execution if those Triggers can run in the same contexts

How many SOQL queries can you get before the governor limit?

An individual Apex request gets a maximum of 100 SOQL queries before exceeding that governor limit. So if this trigger is invoked by a batch of more than 100 Account records, the governor limit will throw a runtime exception

Is Salesforce used by organizations?

The Salesforce platform sees considerable usage by organizations all around the world. For more than two decades now, Salesforce has been involved in effective management of customer data with many of its groundbreaking concepts and policies such as multitenancy and ability to access your data anywhere at any time. To achieve this Salesforce Developers are equipped with an array of tools for designing, building and customizing several Salesforce features, platforms and applications according to the needs of the business.

Spend Time Designing the Architecture

Rushing into coding a new solution or configuring a new solution should be done with hesitancy. In almost every situation I’ve been on a team that hits a governor limit that requires reworking things. Spending an extra few hours or maybe a few days on diagraming and documenting the solution could have likely saved a lot of rework.

Apex Triggers

There are a number of ways to make our triggers more performant and to avoid errors. In the blog article Apex Trigger Best Practices we cover them in more detail.

Bulkify your code

Loops and unoptimized queries are one of the most common causes of hitting governor limits. By utilizing collections and doing bulk queries we can make our methods more efficient and more reusable.

Use Collections and Datasets

By using apex collections we can efficiently query data and store data in memory. By using the right data structures we can reduce our memory footprint or speed up our execution.

Use Batch Apex for Large Quantities of Data

There are really only a few different ways to be able to process large quantities of records on the Salesforce platform – all of the different methods pretty much involve asynchronous apex or more specifically batch jobs.

Use Asynchronous Apex Methods Wisely

Scalability: because the calls are queued up there’s a lot less limits that Salesforce Programmers need to be worried about.

Wrapping It Up

As frustrating as the governor limits can be, I know they have forced me to be a better software developer on Salesforce and in general. Spending some time upfront designing, before jumping into coding, can save dozens of hours of debugging and solving governor limits.

Per-Transaction Apex Limits

Salesforce run time engine keeps an eye on all the apex resource used during a transaction and throws an error if it crosses any of such limits.

Per-Transaction Certified Managed Package Limits

Managed packages are apps typically used by Salesforce Partners to distribute and sell applications to customers. These packages must be created from a Developer Edition organization. Using the AppExchange and the License Management Application (LMA), developers can sell and manage user-based licenses to the app.

Static Apex Limit

Note: The HTTP request and response sizes count towards the total heap size. Also, Apex trigger batch size for platform events and Change Data Capture events is 2,000.

Here is some commonly asked questions related to Salesforce Governor Limits in any Salesforce interviews

How to overcome SOQL error: Too manySOQLqueries:101, which occur due to Salesforce Governor Limits?

What is Salesforce multitenancy?

Salesforce operates on a form of software multitenancy. In layman’s terms, this means that a single instance of software (in this case Salesforce), runs on a server that is able to serve multiple users. Due to the nature of multitenancy and the fact we are sharing resources, governor limits are in place to ensure that any Apex we develop, …

What is a 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 many select statements can an apex class execute?

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.

Why is the governor limit hit in Apex?

Most commonly, this governor limit will be hit because there is a SOQL statement in a for loop; which is considered one of the ‘cardinal sins’ of programming in Apex.


Leave a Comment