Salesforce runs Apex in a multi-tenant environment, where multiple organizations share the same computing resources. To ensure fair resource usage and maintain platform performance, Salesforce enforces Governor Limits hard limits on database operations, CPU usage, and memory consumption.<\/p>\n\n\n\n
Some of the most important governor limits include:<\/strong><\/p>\n\n\n\n This is where Bulkification becomes essential.<\/p>\n\n\n\n Bulkification is the practice of writing Apex code that efficiently processes multiple records in a single transaction, regardless of whether one record or hundreds of records trigger the execution.<\/p>\n\n\n\n Triggers, in particular, can execute on batches of up to 200 records at once – whether initiated through Data Loader, Salesforce Flow, API integrations, or bulk imports. If your code performs SOQL queries or DML operations inside loops, it scales linearly with the number of records and quickly exceeds governor limits.<\/p>\n\n\n\n In this blog, we’ll explore common bulkification mistakes, learn the correct implementation patterns, and review best practices for writing governor limit-safe Apex code.<\/p>\n\n\n\n One of the most common mistakes developers make is placing a SOQL query inside a loop.<\/p>\n\n\n\n This may work perfectly while testing with a single record in the Developer Console.<\/p>\n\n\n\n However, updating 200 Accounts causes the trigger to execute 200 SOQL queries, immediately exceeding Salesforce’s 100 SOQL query limit.<\/p>\n\n\n\n The same issue occurs with DML operations<\/strong>:<\/p>\n\n\n\n Performing DML inside loops quickly reaches the 150 DML statement limit, causing runtime exceptions.<\/p>\n\n\n\n Instead of querying once for every record, query all required data outside the loop.<\/p>\n\n\n\n The outcome remains the same, but the trigger now executes only one SOQL query, regardless of whether the batch contains 1 record or 200 records.<\/p>\n\n\n\n This approach dramatically improves scalability and keeps your code within Salesforce governor limits.<\/p>\n\n\n\n The same principle applies to DML statements.<\/p>\n\n\n\n Instead of updating records inside the loop, collect them first and perform a single DML operation afterward.<\/p>\n\n\n\n This approach performs only one update statement, regardless of how many Contact records are modified.<\/p>\n\n\n\n When reviewing Apex code for bulk safety, always verify the following:<\/p>\n\n\n\n Bulkification isn’t an advanced optimization technique – it’s a fundamental requirement for writing production-ready Apex code.<\/p>\n\n\n\n The guiding principle is simple: database operations such as SOQL queries and DML statements should occur once per transaction, not once per record.<\/p>\n\n\n\n By following bulkification best practices, using collections effectively, and minimizing database interactions, you can build scalable Apex solutions that stay within Salesforce governor limits and perform reliably in high-volume production environments.<\/p>\n\n\n\n By following the above blog instructions, you will be able to learn \u201cHow to Write Bulkified Apex Code in Salesforce to Avoid Governor Limits<\/strong>\u201c. If you still have queries or any related problems, don\u2019t hesitate to contact us at salesforce@greytrix.com<\/a>. More details about our integration product are available on our website<\/a> and Salesforce AppExchange<\/a>. About Us<\/b><\/br>\n Greytrix<\/a> \u2013 a globally recognized and one of the oldest Sage Development Partner and a Salesforce Product development partner offers a wide variety of integration products and services to the end users as well as to the Partners and Sage PSG across the globe. We offer Consultation, Configuration, Training and support services in out-of-the-box functionality as well as customizations to incorporate custom business rules and functionalities that require apex code incorporation into the Salesforce platform. Related Post:<\/strong><\/p>\n\n\n\n Salesforce runs Apex in a multi-tenant environment, where multiple organizations share the same computing resources. To ensure fair resource usage and maintain platform performance, Salesforce enforces Governor Limits hard limits on database operations, CPU usage, and memory consumption. Some of the most important governor limits include: This is where Bulkification becomes essential. Bulkification is the\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[2318,3541,3554,3555,3255,3548,3549,2160,31,3550,3542,3545,3547,3553,3552,3543,2158,367,2467,588,3418,1709,3532,2463,2048,3083,392,2782,3421,397,2567,3544,3512,3546,3417,3551],"class_list":["post-13064","post","type-post","status-publish","format-standard","hentry","category-salesforce-srv","tag-apex-best-practices","tag-apex-bulkification","tag-apex-collections","tag-apex-maps","tag-apex-programming","tag-apex-trigger-best-practices","tag-apex-trigger-optimization","tag-asynchronous-apex","tag-batch-apex","tag-bulk-data-processing","tag-bulkification-in-apex","tag-bulkified-apex-code","tag-dml-best-practices","tag-dml-optimization","tag-future-methods","tag-governor-limit-safe-code","tag-queueable-apex","tag-salesforce","tag-salesforce-admin","tag-salesforce-apex","tag-salesforce-architecture","tag-salesforce-automation","tag-salesforce-code-optimization","tag-salesforce-coding-standards","tag-salesforce-crm","tag-salesforce-developer","tag-salesforce-development","tag-salesforce-development-best-practices","tag-salesforce-governor-limits","tag-salesforce-integration","tag-salesforce-performance","tag-salesforce-triggers","tag-salesforce-tutorial","tag-soql-best-practices","tag-soql-optimization","tag-trigger-framework"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/13064","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/comments?post=13064"}],"version-history":[{"count":17,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/13064\/revisions"}],"predecessor-version":[{"id":13081,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/13064\/revisions\/13081"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/media?parent=13064"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/categories?post=13064"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/tags?post=13064"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
The Classic Anti-Pattern<\/mark><\/strong><\/h2>\n\n\n\n
trigger AccountTrigger on Account (before update) {\nfor (Account acc : Trigger.new) {\n\n\/\/ SOQL inside a loop\n List<Contact> contacts = [\n SELECT Id\n FROM Contact\n WHERE AccountId = :acc.Id\n ];\n\n if (!contacts.isEmpty()) {\n acc.Description = 'Has ' + contacts.size() + ' contacts';\n }\n}\n\n}<\/code><\/pre>\n\n\n\nfor (Account acc : accountsToUpdate) {\nupdate acc; \/\/ DML inside loop\n}<\/code><\/pre>\n\n\n\nThe Bulkified Version<\/mark><\/strong><\/h2>\n\n\n\n
trigger AccountTrigger on Account (before update) {\nSet<Id> accountIds = Trigger.newMap.keySet();\n\n\/\/ One query outside the loop\nMap<Id, List<Contact>> contactsByAccount = new Map<Id, List<Contact>>();\n\nfor (Contact c : [\n SELECT Id, AccountId\n FROM Contact\n WHERE AccountId IN :accountIds\n]) {\n\n if (!contactsByAccount.containsKey(c.AccountId)) {\n contactsByAccount.put(c.AccountId, new List<Contact>());\n }\n\n contactsByAccount.get(c.AccountId).add(c);\n}\n\nfor (Account acc : Trigger.new) {\n\n List<Contact> related = contactsByAccount.get(acc.Id);\n\n acc.Description = related != null\n ? 'Has ' + related.size() + ' contacts'\n : 'Has 0 contacts';\n}\n}<\/code><\/pre>\n\n\n\nBulkifying DML Operations<\/mark><\/strong><\/h2>\n\n\n\n
List<Contact> contactsToUpdate = new List<Contact>();\n\nfor (Account acc : Trigger.new) {\n\n List<Contact> related = contactsByAccount.get(acc.Id);\n\n if (related != null) {\n\n for (Contact c : related) {\n c.Description = 'Parent account updated';\n contactsToUpdate.add(c);\n }\n }\n}\n\nif (!contactsToUpdate.isEmpty()) {\n update contactsToUpdate; \/\/ Single DML statement\n}<\/code><\/pre>\n\n\n\nA Practical Bulkification Checklist<\/mark><\/strong><\/h2>\n\n\n\n
\n
Conclusion<\/mark><\/strong><\/h2>\n\n\n\n
We hope you may find this blog resourceful and helpful. However, if you still have concerns and need more help, please contact us at salesforce@greytrix.com<\/a>.<\/p>\n\n\n\n
Greytrix has some unique solutions for Cloud CRM such as Salesforce Sage integration<\/a> for Sage X3<\/a>, Sage 100<\/a> and Sage 300 (Sage Accpac)<\/a>. We also offer best-in-class Cloud CRM Salesforce customization and development services<\/a> along with services such as Salesforce Data Migration<\/a>, Integrated App development<\/a>, Custom App development and Technical Support business partners and end users. Salesforce Cloud CRM integration offered by Greytrix works with Lightning web components and supports standard opportunity workflow. Greytrix GUMU™ integration for Sage ERP \u2013 Salesforce is a 5-star rated app listed on Salesforce AppExchange<\/a>.
The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.
For more information on our Salesforce products and services, contact us at salesforce@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n\n\n\n\n