locked
ReportViewer too slow RRS feed

  • 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 

    Tuesday, July 23, 2019 8:36 AM

All replies

  • 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 ?

    Tuesday, July 23, 2019 8:47 AM
  • 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

    Wednesday, July 24, 2019 1:52 AM