• #27332
    Forcetalks

    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”?

    Tagged: , , , , , ,

    #27349
    Salesforce | PRANAV PRANAV #1
    Forcetalks

    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.

    #27404
     Ratnakar #10
    Forcetalks

    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

Viewing 3 posts - 1 through 3 (of 3 total)

Please to reply to this topic.

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending

About Us

Forcetalks is a Salesforce collaboration platform for coders & developers, geeks & nerds, consultants & business heads, admins & architects, managers & marketers and of course the business owners. A community where you can learn from, where you can contribute to. For you. For Salesforce. Read More...

Copyright 2018 Forcetalks. All Right Reserved.

Log in with your credentials

or    

Forgot your details?