Skip to main content

Review your database setup

Consider how your database and connection settings could impact on the speed of queries in Count

Mitra Abrahams avatar
Written by Mitra Abrahams
Updated over 7 months ago
  • Improve raw tables in your database
    Could improvements be made with indexing and partitioning, or by creating more aggregated tables?

  • Advanced settings: max concurrent connections and timeout
    These are advanced setting that is supported by some databases in Count (Snowflake, Redshift and PostgreSQL).
    ​


    You can change the number of maximum number of simultaneous connections between Count and your database. Note, If your database has a lower limit than the value set here, then the lower limit will take precedence.
    ​
    ​Reducing the timeout setting will allow your queries will fail faster.
    ​
    You can access these settings by:

    • clicking on your database name in the 'Connections' panel from your Count homepage

    • clicking 'Manage connection' under the 'About' information

More information can be found on database connections in our documentation here.

Did this answer your question?