+ Start a Discussion
SFDC developer999SFDC developer999 

how to retrieve more than 50,000 records for 1 Visual Force page

Hi All,
  I know the VF limit is 50,000 records for 1 VF page request.
 Business wants to have all accounts (more than 50,000 ) retrieved for the VF page so that users can search for certain accounts on the screen.

Please advise.
Ankit SehgalAnkit Sehgal
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.