Forum Discussion
External List performance is poor in Office 365
For one of our customer we have implemented a BCS based solution in Office 365. All is working however the external lists are very slow. ( somethign like 20 seconds to collect infromation); Does ...
I can second this! And been searching for solution for years.
We arent even doing CRUD, just read-only for tagging. It is virtually unusable. I've tried all kinds of paging and filters and search criteria to try and speed things up. Our search results only return only the first 25 items that meet the criteria, and it takes approximately 20 to 30 seconds each query.
In our case we are doing a BCS to ODATA connection with credentials in the Secure Store.
We arent even doing CRUD, just read-only for tagging. It is virtually unusable. I've tried all kinds of paging and filters and search criteria to try and speed things up. Our search results only return only the first 25 items that meet the criteria, and it takes approximately 20 to 30 seconds each query.
In our case we are doing a BCS to ODATA connection with credentials in the Secure Store.
Several years ago, I used BCS with a web service to get data and I don't remember it being that bad, it was not snappy but I seem to recall getting several thousand records in a few seconds. You may want to reach out to @Brett Lonsdale at Lightning Tools to see if they have any suggestions.
