🔧 [Apache Superset] Topic #6, Timeout? How to optimize performance in Superset
Nachrichtenbereich: 🔧 Programmierung
🔗 Quelle: dev.to
Hello,
I'm Duc Nguyen (Duke) and I'm back
If you have not read the previous articles, please read it before practicing this one.
Topic #1, What is Apache Superset used for and how to install it on Windows 11
Topic #2, Superset ARCHITECTURE
Topic #3, Visualization data from CSV data file
Topic #4, Integrate 2D/3D maps into Superset
Topic #5, Automated Alerts and Reporting via Slack/Email in Superset
Today I will guide you how to optimize response speed and query in Superset
1.Optimize the database query side
- Use `JOINs` instead of `subqueries` when possible
- Avoid using `SELECT *` and select only necessary columns
- Use `EXPLAIN` to analyze queries
- Avoid using functions on columns in `WHERE` clauses
- Indexing
- Materialized views
2.Optimize the Superset side
- Update to the latest version
- Set up the `GLOBAL_ASYNC_QUERIES` to use async queries
- Set up the `SQLLAB_TIMEOUT` and `SUPERSET_WEBSERVER_TIMEOUT`
- Disable unnecessary features by `FEATURE_FLAGS`
- Set up the `WSGI` instead of the Flask (eg. `Gunicorn`)
- Run `superset db upgrade` to update the metadata database
If you are unclear about anything, please leave a comment and wait for the next topic in the Apache Superset tutorial section.
...
⚠️ Apache Superset 2.0.0 Remote Code Execution
📈 22.87 Punkte
⚠️ PoC
⚠️ Apache Superset 2.0.0 Authentication Bypass
📈 22.87 Punkte
⚠️ PoC
⚠️ [webapps] Apache Superset 2.0.0 - Authentication Bypass
📈 22.87 Punkte
⚠️ PoC
🕵️ Low CVE-2021-37839: Apache Superset
📈 22.87 Punkte
🕵️ Sicherheitslücken