Sign Up ›

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

query on array limit

Hi All,
 
what will be the limit of following array of CampaignMember:
 
CampaignMember [ ] countcamp=[select id,Lead.id,Lead.status,Lead.lead_internal_lead_status_pck__c,Lead.RecordTypeid,campaignid from campaignMember where campaignid in :CampIncountcamp];
 
Is it 1000?
 
Thanks,
Mahi
mahimahi
Could following statement  process more than 1000 records?
 
for(CampaignMember countcampLoop1 : [select id,Lead.id,Lead.status,Lead.lead_internal_lead_status_pck__c,Lead.RecordTypeid,campaignid from campaignMember where campaignid in :CampIncountcamp]){
}
 
Thanks,
Mahi
TehNrdTehNrd
It depends on how many records are being processed by the trigger. If it is throught the web UI you are almost always processing only one record with the trigger so your limit is 1000 records.

Yet if you using something like the Excel Connector or data loader you could be inserting up to 200 records at once and the limits will scale upwards.


Only thing confusing is that in the documentation is says:

These limits scale with trigger batch size.The limit is multiplied by the number of records submitted. For example, if your batch process contains 200 records, your script may retrieve as many as 20,000 records.

but 200 times 1000 is 200,000 not 20,000.