Home/Questions/Q 362
Next
In Process

Decode Trail Latest Questions

Asked: 2025-11-22T11:10:04+00:00 In:

How do I fix “Too many SOQL queries: 101” in an Apex trigger?

Shivam Rastogi

Too many SOQL queries: 101

Apex
Leave an answer

Leave an answer

Browse

1 Answer

  1. Aman Shrivastav
    Begginer

    Bulkify your trigger and move queries outside loops.

    Problem Explanation

    Salesforce enforces a governor limit of 100 SOQL queries per transaction. Queries inside loops multiply quickly and exceed this limit.

    Root Cause(s)

    1. SOQL inside for loops

    2. Multiple triggers on the same object

    3. Recursive trigger execution

    Step-by-Step Solution

    1. Collect record IDs into a Set<Id>

    2. Run one SOQL query using WHERE Id IN :idSet

    3. Store results in a Map<Id, SObject>

    4. Access data from the map inside loops

    CODE SNIPPET:
    Map<Id, Account> accMap = new Map<Id, Account>(
    [SELECT Id, Name FROM Account WHERE Id IN :accIds]
    );

    Edge Cases & Variations

    1. Use Trigger.newMap in update triggers

    2. Watch for workflow or Flow-triggered recursion

    Common Mistakes to Avoid

    1. Querying per record

    2. Ignoring recursion guards

    3. Using Limits.getQueries() only for logging