ビジネスデータカタログ(BDC)の閾値

既定値

Scope	Throttle Type	Enforced	Default	Max
Global	Connections	TRUE	200	500
Global	ModelSize	FALSE	10000000	50000000
Global	MaxNumberOfModels	FALSE	1000	2000
Database	Items	TRUE	2000	1000000
Database	Timeout	TRUE	180000	600000
WebService	Size	TRUE	3000000	150000000
WCF	Size	TRUE	3000000	150000000
WCF	Timeout	TRUE	180000	600000
WCF	MetadataSize	FALSE	3000000	150000000
OData	Size	TRUE	3000000	150000000
OData	Timeout	TRUE	180000	600000
OData	MetadataSize	FALSE	3000000	150000000

出典：Business Connectivity Services: End User Implications – Part two: Changing External System Throttling

変更方法

# ex.)for database:items

# get current setting
$bcs = Get-SPServiceApplicationProxy | where{$_.GetType().FullName -eq (‘Microsoft.SharePoint.BusinessData.SharedService.’ + ‘BdcServiceApplicationProxy’)}
$BCSThrottle = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $bcs

# output current setting
#$BCSThrottle

# set new setting
Set-SPBusinessDataCatalogThrottleConfig -Identity $BCSThrottle -Maximum 1000000 -Default 40000 

参考

• SharePoint 2010: Row Limits in External Lists
• BCS PowerShell: Introduction and Throttle Management
• Large List Throttling for External Lists in SharePoint 2010
• How to: Define Filters for External Item Picker Controls
• A step by step guide in designing BCS entities by using a SQL stored procedure
• Paging and sorting with BCS
• Types of Filters Supported by the Business Data Connectivity Service
• BDC-App for Web Service with paging