SharePoint Limitations: Business Connectivity Services Limits

The Business Connectivity Services Limits

The below table shows the Business Connectivity Services Limit in SharePoint 2013 /2010.

Note: Before going to read the below table, please take a look at The External list Limitations in SharePoint 2013 / 2010.

Limit Maximum value Limit type Notes
ECT (in-memory) 5,000 per web server (per tenant) Boundary Total number of external content type (ECT) definitions loaded in memory at a given point in time on a web server.
External system connections 500 per web server Boundary Number of active/open external system connections at a given point in time. The default maximum value is 200; the boundary is 500. This limit is enforced at the web server scope, regardless of the kind of external system (for example, database, .NET assembly, and so on) The default maximum is used to restrict the number of connections. An application can specify a larger limit via execution context; the boundary enforces the maximum even for applications that do not respect the default.
Database items returned per request 2,000 per database connector Threshold Number of items per request the database connector can return.
The default maximum of 2,000 is used by the database connector to restrict the number of result that can be returned per page. The application can specify a larger limit via execution context; the Absolute Max enforces the maximum even for applications that do not respect the default. The boundary for this limit is 1,000,000.
Response latency 600 seconds Threshold Timeout used by the external data connector per request. The default value is 180 seconds, but applications can be configured to specify a larger value up to the maximum of 600 seconds.
Service response size 150,000,000 bytes Threshold The upper volume of data per request the external data connector can return. The default value is 3,000,000 bytes, but applications can be configured to specify a larger value up to the maximum of 150,000,000 bytes.
Filter Descriptor (in-store) 200 per ECT method Boundary The maximum number of Filter Descriptors per ECT method is 200.
ECT Identifier (in-store) 20 per ECT Boundary The maximum number of identifiers per ECT is 20.
Database Item 1,000,000 per request Threshold The default maximum number of items per request the database connector can return is 2,000, and the absolute maximum is 1,000,000.
The default max is used by the database connector to restrict the number of results that can be returned per page. The application can specify a larger limit via execution context; the absolute max enforces the allowed maximum even for applications that do not respect the default such as indexing.

Applies To
  • SharePoint 2013.
  • SharePoint 2010.
See Also
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s