Expected performance when printing a FlexGrid with many rows/columns/data

Expected performance when printing a FlexGrid with many rows/columns/data

Posted by: eh1160 on 4 January 2021, 6:14 pm EST

• 

  eh1160

  • Post Options:
  • Link
    Copy

  Posted 4 January 2021, 6:14 pm EST

  We are running into performance problems when we attempt to print FlexGrids with many rows of data. It is taking about 5 seconds for anything under 1,000 rows and 30-50 seconds when over 1,000.

  So what is the expected performance? And is it impacted by the number of columns or the type of data? What if we use an wjFlexGridCellTemplate within the column?

  FYI that we also notice that virtualizationThreshold is interfering with the ability to print. If there are more than 200 rows, then the printed page only shows 3 or 4 rows. But we see more rows if we increase the virtualizationThreshold.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 5 January 2021, 3:28 am EST

  Hi Eric,

  We are sorry but we are unable to replicate the issue at our end. We used the following demo to test the performance but were unable to notice any significant drop in performance when print 3000 rows as compared to 1000 rows. Please have a look at it and let us know something is missing in the demo to replicate the issue:
  
  https://www.grapecity.com/wijmo/demos/Core/PrintDocument/purejs

  Regarding virtualization threshold
  
  To improve rendering/load time performance, flexgrid virtualizes cells and only the cells which are currently in the view port/range are rendered/created due to which during the default printing only the rendered cells gets printed and virtualized once are skipped, if you need to print all the cells then you may use the PrintDocument class as demonstrated in the above-shared sample.

  Regards
  
  Sharad