-
What is the maximum number of rows that SOQL and SOSL can “scan”?
What is the maximum number of rows that SOQL and SOSL can “scan”?
-
4 Replies
-
Hi,
LIMIT is an optional clause that can be added to a SOSL query to specify the maximum number of rows that are returned in the text query, up to 2,000 results. If unspecified, the default is the maximum 2,000 results. The default 2,000 results is the largest number of rows that can be returned for API version 28.0 and later.
The LIMIT clause has no limit in and of itself. It's limited to the context in which it's used. If it's used in Apex code it's limited to the total governor limit for SOQL rows, which is currently 50,000. If it's used in a query via the Web Service API then there is no limit.
Hope this helps you.
-
Maximum Number of SOQL queries in a transaction: 100
Maximum Number of query rows in a transaction: 50000
Maximum Number of SOSL queries in a transaction: 20
-
Hi,
Found this online-
LIMIT is an optional clause that can be added to a SOSL query to specify the maximum number of rows that are returned in the text query, up to 2,000 results. If unspecified, the default is the maximum 2,000 results. The default 2,000 results is the largest number of rows that can be returned for API version 28.0 and later.
The LIMIT clause has no limit in and of itself. It’s limited to the context in which it’s used. If it’s used in Apex code it’s limited to the total governor limit for SOQL rows, which is currently 50,000. If it’s used in a query via the Web Service API then there is no limit.
Hope this helps.
-
The Governor Limits enforces the following:-
Maximum number of records that can be retrieved by SOQL command: 50,000.
Maximum number of records that can be retrieved by SOSL command: 2,000
Log In to reply.
Popular Salesforce Blogs
Custom Metadata Test Class Coverage in Salesforce
When we want to implement custom Logic with IF/ELSE cases then in many scenarios we use Custom Metadata Types. But when we try to cover…
What is Salesforce Community Cloud?
In today's fast-paced business environment, maintaining strong relationships with clients and partners is crucial for success. Salesforce Community Cloud has emerged as a dynamic solution…
Steps to Connect Pardot to Salesforce
Steps to Integrate Salesforce and Pardot: There are some steps to install Pardot in salesforce 1- Click on this link https://login.salesforce.com/?ec=302&startURL=%2Fpackaging%2FinstallPackage.apexp%3Fp0%3D04t1W000000U7P8(production) https://test.salesforce.com/?ec=302&startURL=%2Fpackaging%2FinstallPackage.apexp%3Fp0%3D04t1W000000U7P8 (sandbox) 2- After…
