Count

The following tutorial demonstrates various best practice techniques that can help improve the performance of your Count canvases, while reducing the query load on your database.

You can also access information about each of these topics using the links below:

<a href="https://help.count.co/en/articles/10607991-how-to-use-caching-and-scheduling" rel="nofollow noopener noreferrer" target="_blank">Make use of caching and scheduling</a>

<a href="https://help.count.co/en/articles/10608095-how-to-disable-manual-cell-execution" rel="nofollow noopener noreferrer" target="_blank">Disable manual cell execution</a>

<a href="https://help.count.co/en/articles/10608148-using-count-s-local-duckdb-database" rel="nofollow noopener noreferrer" target="_blank">Use Count's local database</a>

<a href="https://help.count.co/en/articles/10608189-sql-best-practice-in-count" rel="nofollow noopener noreferrer" target="_blank">Improve your SQL code</a>

<a href="https://help.count.co/en/articles/10608244-how-to-compile-dags-to-fewer-cells" rel="nofollow noopener noreferrer" target="_blank">Compile DAGS to fewer cells</a>

<a href="https://help.count.co/en/articles/10609969-make-use-of-hidden-frames" rel="nofollow noopener noreferrer" target="_blank">Make use of hidden frames</a>

<a href="https://help.count.co/en/articles/10608754-review-your-database-setup" rel="nofollow noopener noreferrer" target="_blank">Review your database setup</a>

<a href="https://help.count.co/en/articles/10608918-monitor-your-usage-with-count-telemetry" rel="nofollow noopener noreferrer" target="_blank">Monitor your usage</a>

<a href="https://help.count.co/en/articles/10609366-cancel-pending-queries" rel="nofollow noopener noreferrer" target="_blank">Cancel pending queries</a>

- <a href="https://help.count.co/en/articles/10607991-how-to-use-caching-and-scheduling" rel="nofollow noopener noreferrer" target="_blank">Make use of caching and scheduling</a>
- <a href="https://help.count.co/en/articles/10608095-how-to-disable-manual-cell-execution" rel="nofollow noopener noreferrer" target="_blank">Disable manual cell execution</a>
- <a href="https://help.count.co/en/articles/10608148-using-count-s-local-duckdb-database" rel="nofollow noopener noreferrer" target="_blank">Use Count's local database</a>
- <a href="https://help.count.co/en/articles/10608189-sql-best-practice-in-count" rel="nofollow noopener noreferrer" target="_blank">Improve your SQL code</a>
- <a href="https://help.count.co/en/articles/10608244-how-to-compile-dags-to-fewer-cells" rel="nofollow noopener noreferrer" target="_blank">Compile DAGS to fewer cells</a>
- <a href="https://help.count.co/en/articles/10609969-make-use-of-hidden-frames" rel="nofollow noopener noreferrer" target="_blank">Make use of hidden frames</a>
- <a href="https://help.count.co/en/articles/10608754-review-your-database-setup" rel="nofollow noopener noreferrer" target="_blank">Review your database setup</a>
- <a href="https://help.count.co/en/articles/10608918-monitor-your-usage-with-count-telemetry" rel="nofollow noopener noreferrer" target="_blank">Monitor your usage</a>
- <a href="https://help.count.co/en/articles/10609366-cancel-pending-queries" rel="nofollow noopener noreferrer" target="_blank">Cancel pending queries</a>

Best practice techniques to help your queries run faster, and to reduce the number of queries going to your database