I have data (get from stored proceduce in SQL). Telerik report show data very slow (data have 16828 row) about 2 - 3 minute. I have attach database and report .Can you help me. Thank you very much.
https://www.mediafire.com/folder/tfos9wtsxxttp/
1 Answer, 1 is accepted
0
Hello Tuan,
Thank you for providing the report definition along with the data. I successfully downloaded it from the posted link.
Let me start with some general information concerning Report processing and rendering. They 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 (aggregates, filtering, sorting, conditional formatting, expression evaluation, events) and rendering (fonts measurements, layout calculations, paging and etc.). For more information on what and when happens you may check the Report Life Cycle help 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 you may check Performance Considerations help article.
I have tested to reproduce the issue locally with the provided files, but it seems that the report is rendering for around 30 seconds. I have captured a small demonstration for your reference - https://www.screencast.com/t/GMD8v2seMDM. Please note that the video is silent and could be opened with browser with Flash plugin installed (for example IE browser).
In large reports scenarios, the machine should have enough memory and CPU to handle the amount of data and the document processing for this amount of data. For data intensive reports, we would recommend a minimum of a dual core processor with at least 2 GB of RAM.
Based on the Performance factors in the developer’s control section of the mentioned above article, I can highlight the one which I think is relevant to your case:
Regards,
Silviya
Progress Telerik
Thank you for providing the report definition along with the data. I successfully downloaded it from the posted link.
Let me start with some general information concerning Report processing and rendering. They 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 (aggregates, filtering, sorting, conditional formatting, expression evaluation, events) and rendering (fonts measurements, layout calculations, paging and etc.). For more information on what and when happens you may check the Report Life Cycle help 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 you may check Performance Considerations help article.
I have tested to reproduce the issue locally with the provided files, but it seems that the report is rendering for around 30 seconds. I have captured a small demonstration for your reference - https://www.screencast.com/t/GMD8v2seMDM. Please note that the video is silent and could be opened with browser with Flash plugin installed (for example IE browser).
In large reports scenarios, the machine should have enough memory and CPU to handle the amount of data and the document processing for this amount of data. For data intensive reports, we would recommend a minimum of a dual core processor with at least 2 GB of RAM.
Based on the Performance factors in the developer’s control section of the mentioned above article, I can highlight the one which I think is relevant to your case:
- Volume of the data retrieved from the data source: you might consider narrowing the amount of data that needs to be retrieved by using data source parameters - filtering data on data retrieval. When data source parameters are mapped to report parameters the end user can control what amount of data needs to be displayed in the report - Using Parameters with the SqlDataSource component(Binding SQL Query Parameters to Report Parameters).
Regards,
Silviya
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