0

I am using SharePoint 2016 on premises. This is a new farm with installation done just now. I created BDC to fetch data from SQL Server view. That view contain less than 8000 records. Then I created External Content Type in SPD and applied a filter so it will fetch around 3300 records. Problem is when I load that external list in browser it takes 50 seconds to show those 3300 records.

Although the view contain more than 30 fields but at this time I am just displaying three field but still it takes a long time. Is this normal?

If I query that view directly in SQL Server then it only takes 1 second.

Both SharePoint and that SQL Server are in same premises and network.

How to speed up this process?

Improve this question

1 Answer 1

Reset to default
2

You can use the SharePoint 2013 developer dashboard to monitor the access process.

You can check which step used a lot of time.

This is a reference about how to use the SharePoint 2013 Developer Dashboard.

Besides, you can also use the fiddler to monitor the Loading process.

This is a reference about how to use the fiddler to monitor loading process.

Improve this answer
2
  • Good idea about using developer dashboard. I have seen ULS logs and didn't find anything unusual just a lot of calls to SQL Server for each record but let's see what DD has to say. Commented Apr 2, 2018 at 7:15
  • Developer Dashboard is showing a lot of these entries in "Service Calls" tab. I wonder how can I make it stop? ExecuteWcfOperationhttp://www.microsoft.com/Office/2009/BusinessDataCatalog/BusinessDataCatalogSharedService Commented Apr 2, 2018 at 8:13

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.