BCS throttling is at External List level or BDC API level

Question

External list have a default throttling limit of 2000 which ca be increased by powershell scripts.What i wanted to confirm was that if i use BDC API to fetch data and use in a custom grid is throttling applicable here as well.

Answer 1

Hi,

Yes, you will have ExceededLimitException This exception represents the error that occurs when the operation exceeds the throttling limits set by the administrator.

You should always define filters (it can be limit/comparison/wildcard filter) so that you can narrow your search and overcome others restrictions regarding a count of rows in the database. Especially when working with high volume of items, there might be cases in which you may have millions of items to pick, bcs picker will show up to 200 items (this is SharePoint restriction). Take a look at this forum discussion What is the Maximum Row limit in SharePoint 2010 external list ?

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts | Lightning Tools Blog