function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
VSK98VSK98 

How can we retrieve more than 50k records in apex class

Hi All,

As we know in batch class, we can able to retrieve more than 50k records but in normal apex class i need to fetch more than 50K records.Is there any workaround?

Regards,
VSK98
Sohan Raj GuptaSohan Raj Gupta
Hi,

You should look at using Batch Apex to accomplish your goals.
 
You cannot retrieve more than 50,000 records your SOQL calls in a single context.
 
However, with  Batch Apex your logic will be processed in chunks of anywhere from 1 to 200 records in a batch.
 
You'd need to modify your business logic to take the batching into account if necessary.
 
http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_batch_interface.htm

Hope this will help you. Let me know if it helped or you need any more assistance. 

Please mark this is as the solution if it solved your purpose.

Thanks,
Sohan Raj Gupta 
Niraj Kr SinghNiraj Kr Singh
Hi VKS98,

You can try through REST API.

Or if you are having VF page for the class, then use @ReadOnly annotation.

plz let me know if this idea works for you...

Thanks
Niraj