How can I optimize my query performance?

To enhance the performance of your queries in Bold BI, we recommend referring to the following articles:

• “Improving Query Performance in Bold BI through Indexing and Views” (Link: https://support.boldbi.com/kb/article/12584/improving-query-performance-in-bold-bi-through-indexing-and-views)

• “How to Effectively Handle Millions of Rows in Bold BI” (Link: https://www.boldbi.com/blog/handle-millions-of-rows-in-boldbi)

• “How to use the Code View mode effectively in Bold BI” (Link: https://support.boldbi.com/kb/article/12586/how-to-use-the-code-view-mode-effectively-in-bold-bi)

• “Best Practices for Optimizing Data Models and Dashboards for Server Performance” (Link: https://support.boldbi.com/kb/article/12910/best-practices-for-optimizing-data-models-and-dashboards-for-server-performance)

• “How to Utilize Bold BI’s Database Configuration for Managing Large Data Sets” (Link: https://support.boldbi.com/kb/article/911/how-to-utilize-bold-bis-database-configuration-for-managing-large-data-sets)

• Optimizing Database Performance with Materialized Views and Pre-Aggregated Tables:

  • PostgreSQL (Link: https://support.boldbi.com/kb/article/14344/optimizing-database-performance-with-materialized-views-and-pre-aggregated-tables)
  • MySQL (Link: https://support.boldbi.com/kb/article/15018/materialized-views-in-mysql-optimizing-dashboard-performance)
  • SQL Server Indexed Views (Link: https://support.boldbi.com/kb/article/15123/optimizing-database-performance-with-indexed-views-in-sql-server)
  • Google BigQuery (Link: https://support.boldbi.com/kb/article/15038/optimizing-database-performance-in-google-bigquery-using-materialized-views)
  • Snowflake (Link: https://support.boldbi.com/kb/article/15392/materialized-views-in-snowflake-optimizing-dashboard-performance)