Apex, Best Practice, Development, Dreamforce

You can you use DML in a for loop!


Some people may have have seen ‘Apex Ten Commandments’ that myself and Codefriar did at Dreamforce a while back.

One slide we didn’t know if we should put in or not was to come right at the end saying “Thou shalt feel free to break these rules as wisdom merits”. But the issue with this slide was two fold. The majority of developers the ten commandments was aimed at should be following the rules. But for more advanced developers you do at times need to twist the rules and they don’t make sense. Adding the slide could mean that junior developers think of the commandments are only loose guidelines. In the end we left it out but the following year Codefriar kept it in… and in hindsight a better idea 🙂

Rule #2 was “Thou shalt not put DML in for loops“:

But there is one scenario when you can actually have a DML in a for loop and that is when you have your for loop return a collection rather than a specific record.

for (Account a : [SELECT Id, Name FROM Account
 WHERE Name LIKE 'Acme%']) {
 // Your code here
 update a;
}
for (List accts : [SELECT Id, Name FROM Account
 WHERE Name LIKE 'Acme%']) {
 // Your code here
 update accts;
}

The second is better because Salesforce will return 200 records at a time into your for loop. So your DML will only fire once for every 200 records. There is another fringe benefit! Salesforce will clear the heap stack on every iteration thus helping to clear out that heap stack so you don’t hit a heap size limit, which is always good 🙂

  • O Trailhead, myTrailhead! A reply…

    So Salesforce has just announced pricing for myTrailhead at $25/user/month but only as an add-on to a Salesforce Enterprise license so ...
  • My Tools & Techniques to keep focused

    I’m a trustee of a Charity, Technical Architect at NetStronghold, organiser of London’s Calling, create and support my online Salesforce courses ...
  • How secure are your #Salesforce AppExchange Apps?

    If you work in a regulated industry like banking or even if you don’t, understanding the risk that your IT systems ...
Load More By Francis Pindar
Load More In Apex

Check Also

O Trailhead, myTrailhead! A reply…

So Salesforce has just announced pricing for myTrailhead ...

Subscribe via Email

Enter your email address to subscribe and receive notifications of new posts by email.

My Latest YouTube Video

Books I’m currently reading

From Goodreads

  • Book cover

    The Psychology of Selling: Increase Your Sales Faster and Easier Than You Ever Thought Possible

    Brian Tracy

  • Book cover

    Sapiens: A Brief History of Humankind

    Yuval Noah Harari

  • Book cover

    The Subtle Art of Not Giving a F*ck: A Counterintuitive Approach to Living a Good Life

    Mark Manson

Follow me on Twitter