Export to excel fails on more than 50,000 rows and with 35 cols approx

Export to excel fails on more than 50,000 rows and with 35 cols approx

bilalhussainbilalhussain Posts: 1Questions: 1Answers: 0

Hi
We are trying to use this DataTables plugin for handling some large amount of data and then export this data into an excel or csv file but whenever the records exceeds than approx 20,000 the export button does not work .
The table just get unresponsive on the population of data and then everything stops working.
Can someone please explain how we can handle this amount of data ?any efficent approach of doing this?

Answers

  • allanallan Posts: 63,794Questions: 1Answers: 10,514 Site admin

    First thing to try is the Buttons nightly. If that doesn't help it would need to be profiled and optimisations made. If you could link to the page showing the issue that would be useful.

    Allan

This discussion has been closed.