display more records beyond the supported limit on the VF page in salesforce

Hello Madhulika,

To display more records beyond the supported limit on the VF page you need to enable readOnly attribute value as true for the page tag so that -

• Number of query rows will increased from 50000 to 1 million rows.
• Number of records displayed on VF page will be increased from 1000 to 10000

Hi,

Pagination is the best option -

Try this  -

Visual Force Page:

<apex:outputLabel ><B>Showing {!pageNum} page out of {!totPages} pages and your viewing from {!index} record to {!pagevalue} out of Total {!totalRecs} </B></apex:outputLabel>
<c:PageBlockTableEnhancerADV targetPbTableIds="mid,mid2" paginate="true" defaultPageSize="600" pageSizeOptions="100,400,600,700,900,1000"/>
<apex:pageblockTable value="{!tempMemb}" var="m" id="mid">

<apex:column > <apex:inputText value="{!m.Name}"> </apex:inputText> </apex:column>
<apex:column value="{!m.id}"/>
<apex:column value="{!m.Name}"/>

</apex:pageblockTable>
<apex:pageblockButtons >
<apex:commandButton value="First" rerender="details" action="{!beginning}" disabled="{!prev}" oncomplete="initPageBlockTableEnhancerADV()"/>
<apex:commandButton value="Prev" rerender="details" action="{!previous}" disabled="{!prev}" oncomplete="initPageBlockTableEnhancerADV()"/>
<apex:commandButton value="Next" rerender="details" action="{!next}" disabled="{!nxt}" oncomplete="initPageBlockTableEnhancerADV()"/>
<apex:commandButton value="Last" rerender="details" action="{!end}" disabled="{!nxt}" oncomplete="initPageBlockTableEnhancerADV()"/>
<apex:commandButton value="Mass Update" reRender="details" action="{!massUpdate}" status="Load" oncomplete="initPageBlockTableEnhancerADV()"/>
</apex:pageblockButtons>

<apex:actionStatus id="Load"> Loading........</apex:actionStatus>

</apex:pageBlock>
 

Controller:

public class PaginationCtrl2
{
public integer totalRecs{get;set;}
public integer index {get;set;}
public integer blockSize{get;set;}
public integer pagevalue{get;set;}
public integer pageNum{get;set;}
public integer totPages{get;set;}
public list<review__c> tempMemb{get;set;}

public PaginationCtrl2()
{
tempMemb=new List<review__c>();
totalRecs = 0;
index = 0;
pageNum =1;
blockSize = 1000;
pagevalue = 1000;
totalRecs = [select count() from review__c];
totPages = (totalRecs /1000)+1;
gettempMemb();
}

public List<review__c> gettempMemb()
{
tempMemb=Database.Query('SELECT id,Name FROM review__c LIMIT :blockSize OFFSET :index');
return tempMemb;
}

public void beginning()
{
index = 0;
pagevalue = index +1000;
pageNum =0;

gettempMemb();
}

public void previous()
{
pagevalue = index;
index = index - blockSize;
pageNum = (pageNum -1)==-1?0:pageNum-1;

gettempMemb();
}

public void next()
{
index = index + blockSize;
pagevalue = (index +1000)>totalRecs ?totalRecs :(index +1000);
pageNum = (pageNum == totPages || pageNum+1>totPages) ?totPages :pageNum+1;
gettempMemb();
}

public void end()
{
index = totalrecs - math.mod(totalRecs,blockSize);
pagevalue = totalRecs-1000;
pageNum = totPages;
gettempMemb();
}

public boolean getprev()
{
if(index == 0)
return true;
else
return false;
}

public boolean getnxt()
{
if((index + blockSize) > totalRecs)
return true;
else
return false;
}

public void massUpdate()
{
update tempMemb;
}
}

Hope this helps.