druid Query Performance

We have a select query taking 30 to 35 seconds to return 500,000 records. Of I wanted to look into speeding up this response, would I look into better query cache options....checking my configuration....?

Looking for some advice. Thanks

Is it possible for you to use Scan query instead. Select queries are slower, please see the below docs

https://druid.apache.org/docs/latest/querying/select-query.html

https://druid.apache.org/docs/latest/querying/scan-query.html

Thank you Muthu. I will send this to the Development team.