ReportViewer too slow

Question

User-101155366 posted

Hello,

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?

Best Regards

Micco 

Answer 1

User753101303 posted

Hi,

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 ?

Answer 2

User-1174608757 posted

Hi  Micco,

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

Best Regards

Wei