Report generation taking so much time with large data.

21 posts, 0 answers
  1. Manoj
    Manoj avatar
    1 posts
    Member since:
    Jul 2010

    Posted 23 Jul 2010 Link to this post

    Hi!!!!! friends
    i  having around 7000 rows of records with 7 column and want to generate report using telerik reportviewer,
    but its taking so much time to generate the report around 1.5 minutes.
    Please suggest a simplest way to speed up the generation of report with large amount of data
    using telerik reportviewer ASAP.

    Thanks in advance.
    Manoj Gupta

  2. janusz
    janusz avatar
    6 posts
    Member since:
    Jan 2007

    Posted 23 Jul 2010 Link to this post

    I have the same problem with the newest version (Q2 2010). It is not possible to create report with large amount of data. When I back to previous version (Q1 2010) everything work fine. 

    Regards
    Janusz Siwy


     
  3. DevCraft banner
  4. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 27 Jul 2010 Link to this post

    Hi guys,

    As far as the processing time and consumed memory is concerned, the complexity of the report layout, the complexity of the data calculations (aggregates, conditional formatting),  the rendering media, the size of the generated document (in pages), and the capabilities of the underlying machine are crucial.

    We would appreciate your thorough explanation of your scenario and a runnable sample project so we can give appropriate advise. That is why we would appreciate if you send us a sample application that we can run on our end and observe the problems you've elaborated on. Once we review it, we would be able to provide you with more info.

    @Janusz - how many rows of data do you have and do you render them directly in the report or you use Table/CrossTab item?

    All the best,
    Steve
    the Telerik team
    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 Public Issue Tracking system and vote to affect the priority of the items
  5. janusz
    janusz avatar
    6 posts
    Member since:
    Jan 2007

    Posted 27 Jul 2010 Link to this post

    Hi Steve
    I use table to report up to 5 000 rows from 60 000 records readed from database. Rows are filtered using four report parameters.  
    Regards

    Janusz
  6. TechSavvySam
    TechSavvySam avatar
    38 posts
    Member since:
    Jul 2009

    Posted 28 Jul 2010 Link to this post

    Are you restricting your SQL query to retrieve only the data you need for the report (i.e. just returning the 5000 of 60,000 rows from the database)?  If you are just using Telerik reporting to filter the rows, then what is happening is all 60,000 rows are being returned to Telerik reporting and then it has to go through each returned row doing the filtering. 

    For example, let us say you have just want records for a certain date range, you need to add something like this to your SQL query to retrieve the data:

    WHERE RowDate>=@MinRequestedDate AND RowDate<@MaxRequestedDate

    this would filter the returned data down to rows on or after MinRequestedDate (inclusive of the limit) but before MaxRequestedDate (exclusive of the limit)

    You have to explicitly make this change to your query.
  7. janusz
    janusz avatar
    6 posts
    Member since:
    Jan 2007

    Posted 28 Jul 2010 Link to this post

    Hi Sam,

    I know that restricting SQL is the best solution. It is simple when you need to use "singlevalue" parameters. But I need to filter my data using multivalue parameters. For example filter customers belonging to 3 of 10 segments.
    I have no idea how to do it without creating sophisticated procedures.
     
    Regards

    Janusz
  8. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 29 Jul 2010 Link to this post

    Hi Janusz,

    As you can see from our Q2 release notes, the observed behavior should be the opposite i.e. the table rendering performance should be better rather than worse compared to the Q1 release and that is why your claim has baffled us.
    That is why we would appreciate if you send us a sample runnable application/report that we can use on our end for testing. Once we review it, we would be able to provide you with more info.

    As to your multivalue inquiry - as far as the SqlDataSourceParameters are concerned, the current implementation is based on ADO.NET and does not allow you to pass a collection of values (set, array). Thus, the SqlDataSourceParameter accepts only single values corresponding to the SqlDataSourceParameter.DbType property. Although this is a known limitation of ADO.NET, we're currently researching on possible solution for it.

    Kind regards,
    Steve
    the Telerik team
    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 Public Issue Tracking system and vote to affect the priority of the items
  9. Kiran
    Kiran avatar
    10 posts
    Member since:
    Sep 2013

    Posted 10 Feb 2014 in reply to Steve Link to this post

    Hi Steve,

    I am simply setting the datatable to the report. and it has around 250 records only. it takes around 80 seconds, No grouping, no sorting, nothing.thing is I have around 55 max columns in the report, and its upto user what are the fields they want to see, as user selected the columns I am setting  text.value = "=Fields.Value1" and rest all textboxes are visible false

    Please advise
  10. Kiran
    Kiran avatar
    10 posts
    Member since:
    Sep 2013

    Posted 10 Feb 2014 in reply to Kiran Link to this post

    I forgot to mentioned about I have three subreports, in this report, but its conditionally loaded, while testing with 250 records, there are no subreports loading in main report
  11. Kiran
    Kiran avatar
    10 posts
    Member since:
    Sep 2013

    Posted 11 Feb 2014 in reply to Kiran Link to this post

    Please give me some idea, we have purchased the telerik reporting tool. but still can not provide the reports to our customers
  12. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 11 Feb 2014 Link to this post

    Hello Kiran,

    The processing time depends on the machine CPU and memory, and the report complexity. Custom code not generated by the designer may slow down the report generation as well.

    In order to investigate the issue, please send us your project, including test data to run and profile it at our side in your support ticket on the same question.

    Regards,
    Stef
    Telerik

    New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.

  13. David
    David avatar
    90 posts
    Member since:
    Jan 2011

    Posted 11 Feb 2014 in reply to Kiran Link to this post

    I can report that the Telerik suite does work.  I am, like you, a customer of theirs who is delivering solutions to my customers.  As part of my day to day duties I code solutions using c# and the Telerik suite.  Amongst the many reports I have written, I have one which is part of a local municipalities monthly billing process.  An average cycle prints out around 880 pages.  While I personally consider it a HUGE waste of paper they still actually print the critter.  The report contains customer information, totals by service, totals by customer, and totals by report.    This report takes around 1.5 minutes of SQL query time and about 2 minutes to render.  Exporting to Adobe, in the attempt to save trees, takes around 2.5 minutes.  Exports to Excel are pretty much instant and render reports in the 18-24000 rows range.

    While this sample might be larger than you are needing it should give you an idea that what you are looking for is possible.

  14. Kiran
    Kiran avatar
    10 posts
    Member since:
    Sep 2013

    Posted 12 Feb 2014 in reply to Stef Link to this post

    Hi Stef, I am not able to attached the project as it required more space then this website allowed, even I tried with attaching single report at a time, but its still consume 3 kb, and this website does not my attachments.
    Please advise.

    or can I send you the text file.(just code) ?

  15. Kiran
    Kiran avatar
    10 posts
    Member since:
    Sep 2013

    Posted 12 Feb 2014 in reply to Stef Link to this post

    Hi Stef, I am not able to attached the project as it required more space then this website allowed, even I tried with attaching single report at a time, but its still consume 3 kb, and this website does not  allowed that Please advise. 
     can I send you the text file.(just code) ?

    Also advise how much system memory is appropriate for telerik

  16. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 12 Feb 2014 Link to this post

    Hi Kiran,

    Check your account's support history, where you can find the support ticket on the same topic. You can also use the Contact Support Team link to send us another support ticket, where you can attach your files - the limitation is up to 20MB per post. Public forums allow only image attachments.

    Regards,
    Stef
    Telerik

    New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.

  17. Kiran
    Kiran avatar
    10 posts
    Member since:
    Sep 2013

    Posted 13 Feb 2014 in reply to Stef Link to this post

    Hi Stef,

    I hope that you have received the reports I sent you from my account support.
  18. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 17 Feb 2014 Link to this post

    Hello Kiran,

    We reviewed the provided project and sent you several suggestions to test at your side. This is a quote from my response:
    "You can find attached the modified project - we added manually 250 rows to the data source of the report and it produced 36 pages for less than 10 seconds.

    Based on the provided report definition, test the following at your side:
    1. There are 10 static groups in the report, which can be merged into a single static group - this will save unnecessary calculations for unneeded sections;
    2. Instead of arranging the layout manually, use a Table/List item with static rows and columns and place the TextBox items in the cells - the arrangement matters for the speed of measuring the items in the rendering media;
    3. Move the logic from the code behind logic into expressions. For example if a TextBox.Format will depend on a field, use the built-in functions and custom functions  to bind the property. Use conditional formatting to set colors based on field's running value;
    4. Move the logic where the user selects the fields to be displayed and the report modifications outside events. For example when you instantiate the report, you can get a whole section and its Items or specific item. Then set items' Value properties. Consider the example in the Access items from report, calling application and Table(Access items from calling application) article.
    "

    Please, let us continue the discussion in your support ticket.

    Regards,
    Stef
    Telerik

    New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.

  19. Maddy
    Maddy avatar
    3 posts
    Member since:
    Jan 2016

    Posted 08 Jan Link to this post

    Hi,

    I have 1 lack record with 20 columns  to display in telerik report.can i create such kind of report with telerik ...

     

  20. Nasko
    Admin
    Nasko avatar
    909 posts

    Posted 08 Jan Link to this post

    Hello Maddy,

    It depends on the complexity of the report and the used machine. In general, Telerik Reporting is capable of showing 1 lakh of records with 20 columns. Depending on the report structure and the available machine resources it may take some time to render the report.

    Regards,
    Nasko
    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
  21. Geethika
    Geethika avatar
    1 posts
    Member since:
    Sep 2015

    Posted 28 Jan in reply to Nasko Link to this post

    Hi Nasko,

    It was mentioned that  report performance depends on the machine resources also.

    Can you please advise how much memory and CPU will be ideal in order to improve performance ?

    Thanks

    Geethika

  22. Nasko
    Admin
    Nasko avatar
    909 posts

    Posted 29 Jan Link to this post

    Hello Geethika,

    Report processing and rendering are memory intensive operations. The CPU power and amount of memory have direct impact on the rendering performance. Obviously, the faster the hardware, the better. For data- and layout-intensive reports, we would suggest a minimum of a dual core processor with at least 2 GB of RAM. Network traffic bandwidth also impacts performance.

    Regards,
    Nasko
    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
DevCraft banner