Querying Multiple database at once - best practices
We have the need to query multiple databases (over 200) at once but require a reload of the application every 20 minutes. Currently the reload task is taking over 50 minutes. This is not optimal. I am looking for best practices as to how to go about this. Our database model can not change at this time, so we need to find a way to summarize the data, fine/tune the query or hopefully there's a better way within Qlik Sense to achieve this. Any help would be appreciated.