What is the maximum number of columns and rows supported by DataTables?

What is the maximum number of columns and rows supported by DataTables?

chboccachbocca Posts: 22Questions: 4Answers: 0

Is there a limit? Currently, my tables have 300 plus columns. Just curious.

Ditto on rows.

I'm noticing too long export times when rows get over 300.

For export, I'm using ...

buttons: [ 
{ extend: 'csvHtml5', text: '<a title="Save table to .csv file.">Save</a>', filename: 'export_label', exportOptions: { columns: [ ':not(.label):visible' ] } }              
]

Even though the eventual .csv file is only maybe 500 KB.

Thoughts?

Thanks in advance.

This question has an accepted answers - jump to answer

Answers

  • colincolin Posts: 6,889Questions: 0Answers: 1,176
    edited November 8 Answer ✓

    Hi @chbocca ,

    There's no limit as such, but as you say, the export does become an issue as the row/column count increases. We haven't benchmarked top ends, as it really depends on the third-party libraries that we use for the exports.

    That said, there was a bug in 1.10.18 which caused a slowdown on the exports. It would be worth trying the latest release, 1.10.20, to see if that helps.

    Cheers,

    Colin

  • chboccachbocca Posts: 22Questions: 4Answers: 0

    Thank you Colin! Good to know. Just updated from 1.10.18 to 1.10.20 ... works great now. Yay!

Sign In or Register to comment.