if I have more than 50000 orders (custom object) in salesforce. Then, wirting the code:

List<Order__c> ord_list = [Select id, source__c from Order__c];

would end up in governor limits. As the maximum number of records taht can be fetched by a SOQL is 50000.

What is the best way to do this?

(i have to get all the records in a single variable)

Thanks.

Hi,

I need to count the TOTAL Record of Account Object using SOQL and display the record count in the Visualforce page, I am already having more than 50,000 records. How can I get the record count and display the total record count in VF Page? Is there is any other way to get the count in Vf page?

Thanks,

Arunraj