I'm using GDS heavily for interactive data analysis using large sheets. There are cases where I need to display lots (more than a hundred) dimension options in a filter. I think I have noticed a large performance degradation recently, so I have some questions.
- Is there any performance difference between linking to a Google sheet and using file upload? Big Query?
- Is there any performance guideline ( a chart would be nice ) showing the load time and responsiveness based on filter size? Is it linear?
- What are the performance implications (if any) of using multiple large filters? By large I mean settings of over 100 items.
- Is there any performance advantage to using multiple pages connected to the same data source but filtering the page for a value to reduce the size of another dimension filter?
- Is there any performance hit for multiple pages in a report linking to larger data sources? Is there a performance penalty for using more pages in a single report? I really like the multiple pages, but would it be better performance wise if I used separate reports?
- Is there a performance advantage to using a smaller data source table compared to table or page filtering?
- Are there any performance tips out there? Clearing cache? Removing caching? Applying filters to pages? Removing unneeded dimensions? Breaking down large data sources?
Many thanks to the community for all your help and insights!