This section summarizes some of the performance issues of Analytics Data Tables and their possible resolutions.

...

Issue: Data Tables may become really slow to load, and this is due to SmartGWT's processing of the grouping levels (well noticeable from 5 to 8 levels). (SmartGWT is a 3rd party underlying UI framework.) It is quite common to experience loading 4000+ rows for about one minute on a fast machine (i7 quad with 16GB of RAM) in any browser. 

Resolution: See 1159462922 Conclusions below. 

Unresponsive Application in Firefox

...

Issue: Once a Data Table has been displayed, the UI may become less responsive – even after switching to a different PFX tab. This behavior was observed on Mac with Chrome and Safari; presumably Chrome on Windows will perform similarly. It happens when 1000+ rows are displayed, either when the table is totally ungrouped, or when it is grouped with most or all of its nodes expanded.

Resolution: See 1159462922 Conclusions below. 

Conclusions

To deal with the issues above, try the following:

• Make sure to filter the data if more group by levels are required.
• Check out the rollups functionality and use it where appropriate. Unless the tree view (the Group button below the grid) is required, rollups will solve these limitations.
• Save the Data Table in a grouped state. This is strongly recommended if the grouping functionality is indeed required and the performance impact becomes noticeable. The table will take longer to load but will have less of an impact if the tab remains open.