GitHub user dosubot[bot] added a comment to the discussion: What is concept of dashboard by performance?
<!-- Answer --> The performance difference you're experiencing when fetching data from multiple datasets simultaneously compared to a single dataset is likely due to database performance bottlenecks. When multiple charts query the same dataset at the same time, it can overwhelm the database, even if individual queries are fast. This results in slower loading times for the entire dashboard. To resolve this issue, consider the following strategies: 1. **Add Database Indexes**: Ensure that your database has appropriate indexes to speed up query execution. 2. **Data Pre-computation**: Implement data pre-computation to reduce the load on the database during real-time queries. 3. **Enable Caching**: Use caching to store query results and reduce the need for repeated database access. 4. **Optimize Database Filters**: Make sure your queries are as efficient as possible by optimizing database filters. These strategies can help distribute the load more effectively and improve overall dashboard performance <sup>[[1]](https://github.com/apache/superset/discussions/32343)</sup>. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/552f1a73-f2c3-4bc1-b5a2-a7589b372cf5?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/552f1a73-f2c3-4bc1-b5a2-a7589b372cf5?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/552f1a73-f2c3-4bc1-b5a2-a7589b372cf5?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/552f1a73-f2c3-4bc1-b5a2-a7589b372cf5?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/552f1a73-f2c3-4bc1-b5a2-a7589b372cf5?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/552f1a73-f2c3-4bc1-b5a2-a7589b372cf5?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/552f1a73-f2c3-4bc1-b5a2-a7589b372cf5?feedback_type=other)</sup> GitHub link: https://github.com/apache/superset/discussions/33169#discussioncomment-12871524 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
