Being a Salesforce developer , I hope you must have come across the “Too many query rows: 50001” error in Salesforce while working with Apex ,Test class , Flow or handling large data sets. It’s one of those common governor limit errors that every developer runs into at some point mostly in full copy sandbox and production.
Let’s break down in this Triggerhours article what this error actually means, why Salesforce enforces it, and how you can fix and prevent it in your code going forward.
This System.LimitException means the number of rows returned by all SOQL queries in one Apex transaction exceeds some Salesforce platform limits.Salesforce enforces this limit to provide equitable resource distribution in its multitenant architecture. Fetching too many records uses a lot of server memory and processing power, which might degrade performance of the server for other users that are tied to the same resources.
The specific governor limit is:
The most common cause is writing SOQL queries without sufficiently selective WHERE clauses , LIMIT, especially when querying objects that tend to have a large number of records . So we should always make our Make SOQL query selective
List allTasks = [SELECT Id, Subject FROM Task];
List allAccounts = [SELECT Id, Name, AnnualRevenue FROM Account];
for (Account acc : allAccounts) {
// Some logic here...
}
List contacts = [SELECT Id FROM Contact WHERE Account.Type = 'Customer'];
List leads = [SELECT Id FROM Lead WHERE Status = 'Open'];
This is the most crucial fix. Always filter your SOQL queries to retrieve only the records you actually need. So we should always make our Make SOQL query selective by following Salesforce help article. Filter on Indexed Fields: Make use of indexed fields in the WHERE clause contains (for example, Id, Name, OwnerId, CreatedDate, External IDs, and indexed custom fields). This makes the database to locate the relevant records with much higher speed and efficiency.
Be Specific: Make your conditions as specific as possible to narrow down the result set.
You can also reach out to Salesforce support to get your custom field indexed to Improve Performance of SOQL Queries
List accounts = [SELECT Id FROM Account WHERE Name LIKE 'A%']; // Still potentially large
// Filter by a specific record type AND an indexed field (OwnerId)
Id specificRecordTypeId = '012.....';
List accounts = [
SELECT Id
FROM Account
WHERE RecordTypeId = :specificRecordTypeId
AND OwnerId = :UserInfo.getUserId()
]; // Much more selective
List recentTasks = [
SELECT Id, Subject
FROM Task
ORDER BY CreatedDate DESC
LIMIT 1000
];
global class ProcessLargeAccountDataBatch implements Database.Batchable {
global Database.QueryLocator start(Database.BatchableContext BC) {
// This QueryLocator can handle millions of records without hitting the 50k limit here.
return Database.getQueryLocator('SELECT Id, Name, AnnualRevenue FROM Account WHERE Needs_Processing__c = true');
}
global void execute(Database.BatchableContext BC, List scope) {
// 'scope' contains a batch of records (default 200).
// Any queries INSIDE execute must respect the 50k limit for THIS batch transaction.
for (Account acc : scope) {
// Process each account...
}
// update scope; // DML on the batch
}
global void finish(Database.BatchableContext BC) {
// Optional: Send completion email, etc.
}
}
try {
// Attempting to query ALL Task records - very likely > 50,000
List allTasks = [SELECT Id FROM Task];
System.debug('Total tasks found: ' + allTasks.size());
} catch (System.LimitException e) {
System.debug('Caught expected error: ' + e.getMessage());
// You should see the "Too many query rows: 50001" error here.
}
try {
// The Fix: Add a selective WHERE clause and a LIMIT
Date oneMonthAgo = System.today().addMonths(-1);
List recentTasks = [
SELECT Id, Subject
FROM Task
WHERE CreatedDate >= :oneMonthAgo
AND OwnerId = :UserInfo.getUserId()
LIMIT 1000
];
System.debug('Found ' + recentTasks.size() + ' recent tasks for the current user.');
} catch (System.LimitException e) {
// This block should ideally not be hit now
System.debug('Unexpected error: ' + e.getMessage());
}
SFCC Developer | SFCC Technical Architect | Salesforce Consultant | Salesforce Developer | Salesforce Architect |
Want to promote your products/services in front of more customers?
81 Views
83 Views
263 Views
166 Views
164 Views
112 Views
175 Views
