function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
syamkishore1.3906536981992773E12syamkishore1.3906536981992773E12 

How many records can we display in a single vf page?for example my contrller has fetched 10,000 records.out of 10,000 records how many records can i display?

Adnubis LLCAdnubis LLC
It really depends on how you would like to show them. Typicallly if are using one of the iteration elements (apex:repeat, apex:dataTable, etc..) you are only permitted to use a list of 1000 records. If you put the page into Read Only mode that limit is relaxed to 10,000. You put it into Read Only mode by including the attribute readOnly="true" in your apex:page element. When you use ReadOnly you sacrafice the ability to perform any DML statements so no inserting,updating, or deleting.

The second option is not display all the results at once but use a pagination technique and allow the user to view previous and next records. In this case your limit would really just be the limitations of your query. A single query can return 50,000 records typically and 1,000,000 in read only mode (different then setting your page to read only)
vamsi krishna 198vamsi krishna 198
can you show the program how to display the 1,000,000 records in read only mode