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.
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 ?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.