Forum Discussion

MVP

Mar 07, 2017

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 ...

developer

Pieter Veenstra

MVP

Mar 07, 2017

Hi Brent Ellis,

That is exactly what we are doing.

Pieter Veenstra

MVP

Mar 08, 2017

I wrote up the details on my blog and a uservoice

https://veenstra.me.uk/2017/03/07/office-365-bcs-performance-issues-dont-use-it/

https://sharepoint.uservoice.com/forums/330318-sharepoint-administration/suggestions/18550603-bcs-on-office-365-doesn-t-perform-very-well-and-n

Dean_Gross
Silver Contributor
Mar 08, 2017
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.
- Pieter Veenstra
  MVP
  Mar 08, 2017
  Hi Dean_Gross, was this on-premises? For us it works fine in an on-premises environment but in Offic e365 it is very poor
  - Dean_Gross
    Silver Contributor
    Mar 08, 2017
    No, it was in SPOnline, the webservice was running in an on-premises server