Hi All

We have a requirement to configure BCS from SQL. The volume of data could 10 million. With the throttle limit of BCS (2000- max 1million), how should one configure to overcome this limit.

The only req., is to display this data in search results page.

Thanks

Vijay

Hi Vijay,

We can increase the BCS Throttle using the PowerShell script as below:

$bdcProxy = Get-SPServiceApplicationProxy | where {$_.GetType().FullName -eq ('Microsoft.SharePoint.BusinessData.SharedService.' + 'BdcServiceApplicationProxy')} 
Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $bdcProxy | Set-SPBusinessDataCatalogThrottleConfig -Maximum 100000000 -Default 500000
Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $bdcProxy

The following articles for your reference:

http://blogs.msdn.com/b/bcs/archive/2010/02/16/bcs-powershell-introduction-and-throttle-management.aspx

https://smartrider.wordpress.com/2011/01/26/increase-the-default-throttle-size-from-2000-for-bcs-in-sharepoint-2010/

Best Regards,

Dennis