[Feature] - Sequential Loading of Dashboard Widgets with Query Limit Option

[andremacola]

Description:

Currently, Kibana provides the option for "lazy load" to load widgets on a dashboard, which is helpful to enhance performance in large databases. However, in cases with numerous widgets or heavy queries, even "lazy" loading can be time-consuming and lead to loading errors.

To address this challenge and improve the user experience, I like to propose the implementation of a new feature that allows the sequential loading of widgets instead of all at once. Additionally, it would be beneficial to be able to specify the maximum number of widgets to be loaded/queried at a time.

Details of the Proposed Feature:

• Add an option in the dashboard settings that enables "sequential loading" of widgets.
• Keep "invisible" widgets in a waiting state for subsequent loading.
• Provide visual feedback to users, indicating the loading progress.

Expected Benefits:

• Improvement in the performance of dashboards with large databases and complex aggregated widgets.
• Reduction of loading errors due to heavy queries.
• Enhanced usability for dashboards with numerous widgets on wide and fullscreen monitors.

Use Case Examples:

• Real-time monitoring dashboards with heavy queries.
• Dashboards with many aggregated widgets.
• Cases where monitor size exacerbates loading challenges.

Potential Impact:

This feature could be beneficial for users working with extensive data sets in Kibana, including those with real-time monitoring needs.

Additional Context:

Our organization has faced performance challenges while working with databases generating over 20 million daily inputs with a significant number of fields. We are confident that the implementation of this feature can significantly improve the efficiency of our dashboards.

We appreciate your attention and the outstanding work on Kibana so far. We hope this suggestion will be considered and, if possible, implemented to further enhance the experience for Kibana users.

[elasticmachine]

Pinging @elastic/kibana-presentation (Team:Presentation)

[ThomThomson]

Related to #150459. There is some conversation about sequential loading in that issue. I will keep both of these issues open for the time being because they both capture a portion of the request. @andremacola Thank you for your contribution!