Hello,
I have a dataset with 121M rows and 109GB at the lowest granularity needed in order to allow the filters to work. The spice takes about 30 - 60 mins to refresh daily. The charts, however, sometimes can’t be loaded (“Getting data for this visualization took too long” error), or take a very long time to load.
Is there anything I can do to improve the performance of the charts?
Thanks
Hi @haolunw ,
There’s a good write up here on creating performant dashboards and visualizations.
Additionally, likely you’ll want to tweak how users consume your dashboards and optimize their interactions for performance. For instance, you might only show high level aggregations on the ‘landing’ dashboard and require a navigation action to another sheet/dashboard for details.
Another thought is to partition and filter the data in some way, maybe by hotness; e.g. filter by this month or today and show that data on a single dashboard, then require navigation for historical data.
I’ve found this book a good reference for crafting those sort of interactions.
If you don’t mind sharing screen shots and other details, we can chat through some specifics.
Hope that helps. Let me know if it doesn’t.
ws