Apex Code Development You need to sign in to do that
Don't have an account?
sk aleem how to display 70000 records on visualforce page below scenario.can any slove urgent and reply me
scenario: in an object there are two fields called field1 and field2 and i have 100000 records,out of 70000 record values are equal in field1 and field2.now dispaly those 70000 records on visualforce page.
Once formula field is created, since there is a limit of 50,000 records that can be fetched in 1 context, you will have to fetch records in chunks, preferably, in chunks of 1000 or less, otherwise the page load will have performance problems. So either you can use a pagination or if you want show all data in the same page, you can use "Show more" button.
You can also use datatables.net for showing records in a tabular layout providing features like filters, search, pagination. It might require some learning but you will have better performance and there is a server side data loading feature too.
Harpreet
OSI technologies
How to paginate > 10000 records. SOQL OFFSET and StandardSetController too limiting (http://salesforce.stackexchange.com/questions/42702/how-to-paginate-10000-records-soql-offset-and-standardsetcontroller-too-limit)
If your purpose is to display the records only, then you can set the readOnly='true' in apex:page tag. Using this, the SOQL limit will be relaxed from 50000 to 100000.
Your scenario seems to be an interview question which usually asked.:)
Thanks,
Pankaj
Annotate you apex method with @ReadOnly