Last post Jul 24, 2019 01:52 AM by Wei Zhang
Jul 23, 2019 08:36 AM|Micco|LINK
I have a report which uses ReportViewer and Data is read from Database using Stored Procedure. Problem is that when report is opened into Web Forms page it's very slow. Second problem is that the whole site seems to become slower to other users when report
is opened to Browser. If I run Stored Procedures in SQL Management Studio Data is coming quite fast.
Have anyone of you seen same kind of performance problems?
I read somewhere that defining trust levels and legacyCasModels into Web.Config could help in this kind of situation but haven't succeeded.
Any one have any ideas how to solve this kind of issue?
Jul 23, 2019 08:47 AM|PatriceSc|LINK
See rather what happens maybe using F12 Network or audit. Could be it be that report you are loading does have a quite big size causing this time being spent in downloading it ?
Jul 24, 2019 01:52 AM|Wei Zhang|LINK
According to your description, the performance is slow because it will waste time to build connection to database and render data in browser. So when it has a large amount of data ,it will cause much time.So to solve this problem, you could try below ways.
1. Adding <trust legacyCasModel="true" level="Full"/> to web.config.
2.It will save time if you set your .net framework to 3.5
3.Try to optimize your sql query