Big data and many pages of the report

5 posts, 0 answers
  1. Igor Kroyn
    Igor Kroyn avatar
    2 posts
    Member since:
    Jul 2018

    Posted 17 Dec 2019 Link to this post

    Good day! Please tell me - What can be done to speed up the work of the Report designer

    , in the case when there is a rendering of more than 1000 pages.
    Sometimes the computer freezes, sometimes errors are issued:
    - internal server error thread was being aborted.
    or
    - unauthorized 
    authorization has been denied for this request

    Is it possible to somehow set the mode to receive a report by several pages?

  2. Simon
    Simon avatar
    77 posts
    Member since:
    Sep 2018

    Posted 17 Dec 2019 Link to this post

    It takes time to load a lot of data.

    But that also depends on your cpu.

    It is better to filtering some datasets.

     

  3. Igor Kroyn
    Igor Kroyn avatar
    2 posts
    Member since:
    Jul 2018

    Posted 18 Dec 2019 in reply to Simon Link to this post

    Some requests are completed in 10-20 seconds, and the problem is not in them, but in rendering, because of which everything hangs and errors are generated
  4. Simon
    Simon avatar
    77 posts
    Member since:
    Sep 2018

    Posted 18 Dec 2019 Link to this post

    Hi,

    which errors are displayed?

    Can you make a screenshot of them?

  5. Todor
    Admin
    Todor avatar
    451 posts

    Posted 20 Dec 2019 Link to this post

    Hello,

    Generally, Report processing and rendering are extremely memory- and time-intensive operations. During the report generation, there are newly created resources. Each item takes memory and time to be processed and rendered in the report. The operations are very complex and include data processing (filtering, sorting, conditional formatting, etc.) and rendering (fonts measurements, layout calculations, paging and etc). For more information on what and when happens you may check the Report Life Cycle article.
    A lot of factors will influence the report's performance: machine capabilities, number of report items, amount of data, report's complexity and rendering format. For more information on how the report could be improved, you may check Performance Considerations help article.

    Consider also switching to PrintPreview mode - see Interactive vs. Print Layout. This display mode respects physical paging and will display the first physical page after it is ready, and the rest will be rendered in the background. The default Interactive mode renders the report with soft page breaks only, hence the first page may be huge, for example, if it is a table with thousands of rows.

    Another way to improve the performance is to run 64-bit version of the Standalone designer. The reason is that 32-bit applications are limited to using up to ~1.8GB of memory - check Memory Limits for Windows and Windows Server Releases.

    You may use Filtering through Report Parameters on a database level to reduce the amount of data. By selecting different values for the filtering parameters you will be able to render different parts of the big data.

    Regards,
    Todor
    Progress Telerik

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top