Skip to main content

Review your database setup

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

M
Written by Mitra Abrahams
Updated over 2 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?