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?