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
sampathawaduge sameerasampathawaduge sameera 

What is the advantage of querying within loop?

what is the advantages of querying data withing the for loop itself like below

for(Account a:[select name from Account])
{
***logic***
}
Best Answer chosen by sampathawaduge sameera
sfdcMonkey.comsfdcMonkey.com
+1 to Raj, you can find your answer here in more details : explained by sfdcFox

https://salesforce.stackexchange.com/questions/129706/which-one-is-better-loop-with-soql-or-create-a-list-then-loop

for heap size refrence : https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_gov_limits.htm#total_heap_size_limit_desc

Thanks let us know if it helps 
 

All Answers

Raj VakatiRaj Vakati
It's going to reduce the heap size. Its one of the technique to reduce the heap size 
<Saket><Saket>
Raj V awesome 👌
sfdcMonkey.comsfdcMonkey.com
+1 to Raj, you can find your answer here in more details : explained by sfdcFox

https://salesforce.stackexchange.com/questions/129706/which-one-is-better-loop-with-soql-or-create-a-list-then-loop

for heap size refrence : https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_gov_limits.htm#total_heap_size_limit_desc

Thanks let us know if it helps 
 
This was selected as the best answer