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
vinay Kumar 1004vinay Kumar 1004 

million records in visual force

Hi all,

How to display a million records in a visual force page.

Thnx-Vinay
Amit Chaudhary 8Amit Chaudhary 8
Please check below post. i hope that will help you
1) http://salesforce.stackexchange.com/questions/50305/how-to-query-more-than-50k-records-and-display-in-visualforce-page
2) https://developer.salesforce.com/docs/atlas.en-us.pages.meta/pages/pages_controller_readonly_context_pagelevel.htm
 
<apex:page controller="SummaryStatsController" readOnly="true">
</apex:page>

Normally, queries for a single Visualforce page request may not retrieve more than 50,000 rows. In read-only mode, this limit is relaxed to allow querying up to 1,000,000 rows.

In addition to querying many more rows, the readOnly attribute also increases the maximum number of items in a collection that can be iterated over using components such as <apex:dataTable>, <apex:dataList>, and <apex:repeat>. This limit increased from 1,000 items to 10,000

 
Ragava reddyRagava reddy
Hi Vinay,

Incase you will put it on readonly= true attribute  ( <apex:page controller="SummaryStatsController" readOnly="true"> ) DML operations will not fire on that page.
Please check the below link,
https://anusalesforce.blogspot.in/p/read-only-mode-for-visualforce-page-and.html

Thanks,
Raghavendra Reddy.D