Lessons Learned: Improving Business Connectivity Services Performance

by John Bonfardeci Are you developing a client-side JavaScript application on the SharePoint platform? Is your data in an external database such as Azure or SQL Server? Are you using views and/or stored procedures to join two or more tables? If you’ve answered “yes” to these questions, this lessons learned article is for you. It’s relatively simple to create external content types in SharePoint Designer via Business Connectivity Services (BCS) and many articles have been published covering the steps. Furthermore, you can filter data with the REST `$filter` parameter. However, SQL server will return all the data in a view or table and only then will SharePoint filter the results. For example, if a view returns 10,000 rows and you…