Performance in Excel Exporting

Suma Gowda commented on May 27, 2022

Dear kool Team,

We are planning to purchase Pro version of Kool. We need input on, how the performance in excel export feature? If we download large data (means >1L), any performance issue will occur/ file exporting in Backend process or front end process?

please let me know, if you need more input on the same.

Thanks you.

Sebastian Morales commented on May 30, 2022

Do you use charts in your excel export or just tables?

Suma Gowda commented on May 30, 2022

Need both the scenario. Its depends on our data.

Suma Gowda commented on May 30, 2022

Any performance issue will occur, if we export excel file with chart?

Sebastian Morales commented on May 30, 2022

Pure table export would certainly be faster. You can even export huge data (millions of rows) to CSV in very short time and import them into excel programs, databases. With charts, you would be limited by time and memory. However, even with charts you can export tens of thousands of rows to excel with no problem. Rgds,

Suma Gowda commented on May 30, 2022

Thanks for input. i) XLSX file have any limitations(means max columns and rows)?
ii) File download is happens in backend process right?

Sebastian Morales commented on May 30, 2022

1 . There's no limitation by the export function itself. It's just limited by your PHP maximum memory and execution time.

2 . Yes, excel file export and download are server side processing.

Suma Gowda commented on May 30, 2022

Nice. Thanks your valuable inputs.

KoolReport's Forum

Performance in Excel Exporting #2698

Build Your Excellent Data Report