You need to sign in to do that
Don't have an account?
Vigneshwaran Loganathan
Need help on following
I need clarification on below things which are confusion lot,
1) How many Queries we can do in Trigger? (??)
2) How many Queries we can do in a Apex Class? (150??)
3) How many DMLs we can do in Trigger for an instance? (??)
4) How many DML we can do in class for an instance? (50k??)
5) how many records will be retrieved in a single query in Apex class?
6) how many records will be retrieved in a single query in Trigger?
** In trigger we can do 100soql per cycle. (What does it mean?)
if there is a query like
I have seen somewhere that we can do 20 DML in Trigger for an Instance, another site its 150.. what is true?
Correct me if some questions are wrong, it really confusing a lot :))
Thanks folks.
1) How many Queries we can do in Trigger? (??)
2) How many Queries we can do in a Apex Class? (150??)
3) How many DMLs we can do in Trigger for an instance? (??)
4) How many DML we can do in class for an instance? (50k??)
5) how many records will be retrieved in a single query in Apex class?
6) how many records will be retrieved in a single query in Trigger?
** In trigger we can do 100soql per cycle. (What does it mean?)
if there is a query like
SELECT id,name from Account where status='Active'; // consider if there are 7000 active recordswill it retrieve all the 7000 records on next to query line?
I have seen somewhere that we can do 20 DML in Trigger for an Instance, another site its 150.. what is true?
Correct me if some questions are wrong, it really confusing a lot :))
Thanks folks.
1) How many Queries we can do in Trigger? (??)
Amit:- 100 SOQL in one context.
2) How many Queries we can do in a Apex Class? (150??)
Amit:- 100 SOQL in one context. Limit is same of Trigger and Apex class. Only difference in Batch job that is 200.
3) How many DMLs we can do in Trigger for an instance? (??)
Amit:- 10,000 in one context
4) How many DML we can do in class for an instance? (50k??)
Amit:- 10,000 in one context
5) how many records will be retrieved in a single query in Apex class?
Amit:- 50,000 in one context
6) how many records will be retrieved in a single query in Trigger?
Amit:- 50,000 in one context
In trigger we can do 100soql per cycle. (What does it mean?)
Means if trigger will execute one time it may process one or 200 record at a time. means one process(one context)
Please check all below link to check salesforce goverment limit
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_gov_limits.htm
Total number of records retrieved by SOQL queries 50,000
Total number of records retrieved by Database.getQueryLocator 10,000
Total number of SOSL queries issued 20
Total number of records retrieved by a single SOSL query 2,000
Please let us know if this will help you
Thanks,
Amit Chaudhary
All Answers
1) How many Queries we can do in Trigger? (??)
Amit:- 100 SOQL in one context.
2) How many Queries we can do in a Apex Class? (150??)
Amit:- 100 SOQL in one context. Limit is same of Trigger and Apex class. Only difference in Batch job that is 200.
3) How many DMLs we can do in Trigger for an instance? (??)
Amit:- 10,000 in one context
4) How many DML we can do in class for an instance? (50k??)
Amit:- 10,000 in one context
5) how many records will be retrieved in a single query in Apex class?
Amit:- 10,000 in one context
6) how many records will be retrieved in a single query in Trigger?
Amit:- 10,000 in one context
In trigger we can do 100soql per cycle. (What does it mean?)
Means if trigger will execute one time it may process one or 200 record at a time. means one process(one context)
Please check all below link to check salesforce goverment limit
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_gov_limits.htm
Total number of records retrieved by SOQL queries 50,000
Total number of records retrieved by Database.getQueryLocator 10,000
Total number of SOSL queries issued 20
Total number of records retrieved by a single SOSL query 2,000
Please let us know if this will help you
Thanks,
Amit Chaudhary
Thanks for the reply.
how many records will be retrieved in a single query in Apex class?
Amit:- 10,000 in one context
Total number of records retrieved by SOQL queries 50,000
what is the different between these two?
1) How many Queries we can do in Trigger? (??)
Amit:- 100 SOQL in one context.
2) How many Queries we can do in a Apex Class? (150??)
Amit:- 100 SOQL in one context. Limit is same of Trigger and Apex class. Only difference in Batch job that is 200.
3) How many DMLs we can do in Trigger for an instance? (??)
Amit:- 10,000 in one context
4) How many DML we can do in class for an instance? (50k??)
Amit:- 10,000 in one context
5) how many records will be retrieved in a single query in Apex class?
Amit:- 50,000 in one context
6) how many records will be retrieved in a single query in Trigger?
Amit:- 50,000 in one context
In trigger we can do 100soql per cycle. (What does it mean?)
Means if trigger will execute one time it may process one or 200 record at a time. means one process(one context)
Please check all below link to check salesforce goverment limit
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_gov_limits.htm
Total number of records retrieved by SOQL queries 50,000
Total number of records retrieved by Database.getQueryLocator 10,000
Total number of SOSL queries issued 20
Total number of records retrieved by a single SOSL query 2,000
Please let us know if this will help you
Thanks,
Amit Chaudhary