How does combined custom widgets query the data sources?

In Bold BI, each widget, including custom widgets, is designed to query the data source independently. This means that when you have multiple widgets on a dashboard, each one will send a separate query to its respective data source to fetch the data it requires.

Dashboard Performance

The independent querying mechanism allows for flexibility and customization but also means that the performance of a dashboard can be influenced by the number and complexity of widgets it contains. Each widget’s query can potentially be a separate transaction with the data source, which may impact loading times and responsiveness.

Optimizing Data Queries

To optimize the performance of a dashboard with multiple custom widgets, consider the following strategies:

• Data Refresh Intervals: Adjust the data refresh intervals to balance real-time needs with performance.
• Query Efficiency: Ensure that the queries are as efficient as possible, fetching only the necessary data.
• Dashboard Design: Strategically design the dashboard to minimize the number of widgets that need to query large datasets.
• Caching: Utilize caching mechanisms to reduce the frequency of data source queries.

Additional References

• Bold BI Widgets
• Bold BI Custom Widgets
• Bold BI Combine Widgets
• Data Caching in Bold BI
• How can I optimize my query performance?