function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
SfDevForceSfDevForce 

Row count added to the total number of records retrieved by SOQL queries

Hi,
I'm trying to get a row count for a report.  However, when I do a count(), the total seems to get added to the total number of records retrieved by SOQL queries.  If I have 15,000 rows and I do a count(), would I run into the governor limit?  Does anyone know? Please help, thank you. 

Best Answer chosen by Admin (Salesforce Developers) 
Nick1746323Nick1746323
Yep, thats right, a "select count() from anything" can easily break the governor limits.

All Answers

Nick1746323Nick1746323
Yep, thats right, a "select count() from anything" can easily break the governor limits.
This was selected as the best answer
TehNrdTehNrd

But wouldn't it be nice if it didn't........

 

http://ideas.salesforce.com/article/show/10089055/Count_the_SOQL_count_query_as_a_single_row_query