9_Datastudio

Question 1

Caching

• Query cache
• • Remembers queries issued by reports components (i.e. charts)
• • When performing same query, pulls from cache
• • If query cache cannot help, go to prefetch cache
• • Cannot be turned of
• Prefetch cache
• • ‘Smart cache’: predicts what ‘might’ be requested
• • If prefetch cache cannot serve data, pulls from live data set
• • Only active for data sources that use owner’s credentials for data access
• • Can be turned off
• When to turn caching off:
• • Need to view ‘fresh data’ from rapidly changing data set