Expandable Row Grouping VERY slow

Expandable Row Grouping VERY slow

psenechalpsenechal Posts: 32Questions: 2Answers: 0
edited January 2013 in DataTables 1.9
Hoping someone has a work-around or other possible solution for this...

I have a datatable with about 750 rows (3 columns per row) that is being grouped by row using the row grouping plugin. There ends up being about 75 groups. Pagination is not an option on this page.

This datatable is also on a tab in a Bootstrap tabset.

Without row grouping, the 750 rows load in about 3-4 seconds (not bad and totally acceptable)

With row grouping, the 750 rows load in about 5-6 seconds (still not bad and totally acceptable)

With row grouping and Expand/Collapse option turned on, the 750 rows load in about 45 seconds (not acceptable)

Interesting option...if I disable the Bootstrap tab so the user can't click on it for 10 seconds, the 750 rows with row grouping and expand/collapse turned on will load within that 10 seconds. It's only if I'm actually on the tab that it takes 45 seconds.

I would really like to use expand/collapse, but I can't if it's going to take 45 seconds to load the table.

Has anyone found a different way to do this, or has been able to optimize the row grouping with expand/collapse?

Any help is greatly appreciated. Thanks!
This discussion has been closed.