Performance Optimization: Master Your Caching

One way to ensure the query load on your database is reduced is to enable caching. If I click on my canvas to ensure nothing is selected, in the right hand design panel I will see that I can change my caching settings. I have three options here for caching. If I never cache results, this will mean that every time I open my report or canvas, queries for visible cells will be sent back to my database. But maybe I don't need my data to be refreshed as often as that, in which case I can choose to cache results for a certain amount of time. It could be an hour, a day, twice a day, or I could look to cache results indefinitely. So this is the most efficient option. This will mean that queries will not rerun unless you edit cells or unless you execute them manually using the run cell button. And you can also use caching in combination with scheduled runs. So perhaps you want to schedule your run daily very early in the morning, let's say five AM, and this will ensure that data is already run and refreshed in time for any reporting that is looked out that morning.