Code View Mode in Bold BI: Understanding its Impact on Performance

In Bold BI, the Code View Mode offers users the flexibility to manually write and execute custom SQL queries, opening up possibilities for complex data transformations. While this feature grants advanced control, users need to be aware of performance considerations when using Code View Mode for custom SQL queries, particularly when compared to Design Mode.

Understanding Code View Mode in Bold BI

The Code View Mode in Bold BI allows users to directly input custom SQL queries for data analysis purposes, as outlined in the help documentation. It is essential to realize that Code View Mode submits the SQL query as a subquery, which can influence performance metrics.

Maximizing Performance in Code View Mode

To ensure optimal performance when using custom SQL queries in Bold BI’s Code View Mode, consider the following guidelines:

1. Prioritize Design View Mode: Whenever possible, use the Design view mode as it is typically faster and more efficient than writing custom queries.

2. Syntax Matters: Ensure your custom SQL queries are syntactically correct. Proper syntax reduces the risk of errors and minimizes execution time.

3. Optimize Data Aggregation: Implement appropriate aggregations in your custom SQL queries to improve performance.

4. Monitor Query Execution and Results: Be cognizant of the execution time and the data set size that your custom SQL query will yield. Keeping the data result set at a manageable size can prevent performance issues.

5. Use Database Views: If possible, create materialized views or standard views in your database and connect them through the design mode to increase processing efficiency.

6. Leverage Extract Mode: If materialized views are not an option, consider using Bold BI’s extract mode with custom SQL. The query runs only once at data source creation or refresh, thus enhancing dashboard performance.

7. Database Performance Tuning: Regular performance reviews and tuning can profoundly impact the overall efficiency. This may include updating database statistics, optimizing configurations, and ensuring the database server has adequate hardware resources.

Implementing these strategies can significantly enhance the user experience when working with Code View Mode in Bold BI, leading to faster insights and a more responsive dashboard environment.

Additional References

• Connecting through Custom SQL Query
• How to use the Code View mode effectively in Bold BI
• Connecting Materialized Views in Bold BI
• Working with custom query extract mode in Bold BI
• Data Transformation in connected Data Source