Business Connectivity Services (BCS) throttling limits

BCS can only fetch 2000 records at one fetch due to throttling issues. we can resolve this issues in two ways

1. Switch off the BCS throttling using powershell. This not the best way as it will cause performance issues in future.
   
   $bdcProxy = Get-SPServiceApplicationProxy | where {$_.GetType().FullName -eq (‘Microsoft.SharePoint.BusinessData.SharedService.’ + ‘BdcServiceApplicationProxy’)}
   $dbRule = Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $bdcProxy
   Set-SPBusinessDataCatalogThrottleConfig -Identity $dbRule -Enforced:$false
2.  Modifying the BCS model to include the Key to Filter Methods.