Hi all ,
i am creating visualforce in that i am using picklist  in that picklist containing 10 object if select the one object in back end i want to delete all the duplicate records and display the remaining records 
i am using SOQL to fetch the records but it will lead to problem suppose in account object there are l lakh records
plz help  me to  reslove this  ,thanks in advance

Thanks & Regards
Ravindra

Hi ,
i am writing extension class for account and when i am running the code i getting above error , here i am posting code also
public class myControllerExtension {
    private final Account acct;
    public myControllerExtension(ApexPages.StandardSetController stdController){
        this.acct=(Account)stdController.getRecord();
    }
    public String getGreeting(){
        return 'hello'+acct.name+'('+acct.id+')';
    }

}
vf page
apex:page standardController="Account" extensions="myControllerExtension" >
    {!greeting}
    <apex:form>
        <apex:inputField value="{!account.name}"/>
        <apex:commandButton value="save" action="{!save}"/>
    </apex:form>
</apex:page>

please help me to slove the issue

Hi all ,
i am creating visualforce in that i am using picklist  in that picklist containing 10 object if select the one object in back end i want to delete all the duplicate records and display the remaining records 
i am using SOQL to fetch the records but it will lead to problem suppose in account object there are l lakh records
plz help  me to  reslove this  ,thanks in advance

Thanks & Regards
Ravindra

Hi ,
i am writing extension class for account and when i am running the code i getting above error , here i am posting code also
public class myControllerExtension {
    private final Account acct;
    public myControllerExtension(ApexPages.StandardSetController stdController){
        this.acct=(Account)stdController.getRecord();
    }
    public String getGreeting(){
        return 'hello'+acct.name+'('+acct.id+')';
    }

}
vf page
apex:page standardController="Account" extensions="myControllerExtension" >
    {!greeting}
    <apex:form>
        <apex:inputField value="{!account.name}"/>
        <apex:commandButton value="save" action="{!save}"/>
    </apex:form>
</apex:page>

please help me to slove the issue