Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
The SQL query in the extractor takes 1.5 hours to load the data. It has 2 where conditions and sum(cost). There are 15 columns in the query.
My question is if I load all the 15 columns with the 2 where conditions and without aggregation in the SQL and then do a preceding load where I calculate the sum, will it improve the performance? Will it take less time to execute?
Doing the aggregations in qlik is faster?
Stay Safe!!
Regards
Anusha
@anuhegde I think it all comes down to which of the two locations have more system resources. Most of the times database are more efficient to perform the aggregations and pass the aggregated values to Qlik, but if database is running low on resources or have low resources, Qlik might work better.
I would say give it a shot and see what works better out of the two.
Only other thing I can offer is some best practices info:
Regards,
Brett