KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Getting result from sql query in 2 sec but pivot is taking much time to render report in format #2668

Open ankit opened this topic on on May 11, 2022 - 1 comments
ankit commented on May 11, 2022

I check my query is taking hardly 1 to 2 sec with 800 rows but pivot is rending very slow please help me

Also you can check on below link by select report type only and submit.

https://crm.emooving.in/baasReports/

Sebastian Morales commented on May 12, 2022

In our latest KoolReport Pro and Pivot package versions there's a new property called "serverPaging" for PivotMatrix:

https://www.koolreport.com/examples/reports/pivot/pivotmatrix_server_paging/

https://www.koolreport.com/docs/pivot/pivottable_and_pivotmatrix/#pivotmatrix-exclusive-properties-serverpaging-(version-%3E=-8.5.0)

Pls try it for your case and see if rendering time improves.

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
None yet
Pivot

Designed and built with by KoolPHP Inc.

Code licensed MIT.