Apex Code Development You need to sign in to do that
Don't have an account?
What to use 2 queries or for loop?
Hi,
I have one situation in my code where i need a list or Map of records as well as sum of a fields from them. What is the best way to achieve this? i can think 2 ways
1) Use 1 SOQL query to get the Map of records and 1 aggregate query to get the sum of field OR
2) Use 1 SOQL query only to get the record, the loop through them and get the some of field using some variable
In approach first, i think i will have to use 1 extra query and in 2nd approrach, if number of records are more, i could take longer time.
I am confused which approach i should use. Any suggestions would be great.
Thanks,
I have one situation in my code where i need a list or Map of records as well as sum of a fields from them. What is the best way to achieve this? i can think 2 ways
1) Use 1 SOQL query to get the Map of records and 1 aggregate query to get the sum of field OR
2) Use 1 SOQL query only to get the record, the loop through them and get the some of field using some variable
In approach first, i think i will have to use 1 extra query and in 2nd approrach, if number of records are more, i could take longer time.
I am confused which approach i should use. Any suggestions would be great.
Thanks,
If you choose option
1) You have to write 1 SOQL query & Aggregation query
& option
2) You have to write only 1 SOQL query
Go with option 1, As first option heap size less than second option & tale less Apex CPU time.
Perfomace wise option 1 is better.
1) Use 1 SOQL query to get the Map of records and 1 aggregate query to get the sum of field OR that way is best
https://developer.salesforce.com/forums/?id=906F0000000909tIAA
you can also see that code