BCS Throttle limit of 2000 items

Question

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

Answer 1

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

---

TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact [e-mail].

Answer 2

Is this the only option that the thottle limit has to be increased? Is there any other way to fetch all the data and still not change the throttle limit.