Query Performance and Management

Once you've written your queries in Count, you have control over how they execute and perform. This section covers optimizing database load, managing query execution, and troubleshooting issues.

What you'll find here

Query caching and scheduling - Store query results for a set duration to reduce database load, and schedule automatic refreshes during off-peak hours so your data is ready when teams need it.

Manage queries and results - Control which queries execute and when, cancel running queries, and manage result size limits. Most queries run automatically, but you can take manual control when working with expensive queries or during high database load.

Query troubleshooting - Diagnose inconsistencies between Count and other tools, understand non-deterministic query behavior, and resolve common query execution issues.