Currently i'm working with an Apache Druid Warehouse that stores near of 300 Millions of rows and have a size of 44GB. We are developing a Flask API that uses Gunicorn and Celery to develop SQL query in Druid. It exist a React App that generate multiple request to the Flask API and then API request Data to Druid in a properly SQL query. Our problem is that Druid response last a lot of time. i.e. When we send near of 50 request to druid, it can take near of 1.3 minutes until return the last response. We work a lot in our front end and the API optimization , however, we suspect that problem is located in Druid datasource.
This is a companion discussion topic for the original entry at https://stackoverflow.com/questions/71684879/so-slow-apache-druid-query