Forum Discussion
Sound advice on improving Query Refresh
Correct and hopefully it will be part of your long-term solution otherwise the refresh will take as long as the initial load.
Other things to consider : query folding,
auto date/time settings,
not returning fields from the db that are not required,
using table.buffer if the same table is being loaded repeatedly in query transformations,
what's going on in the db when the load is being run, and so on
First of all, I'm a hardcore fan for PQ given so many fantastic native functions to manipulate dataset; but in practice, I still resort to sql for better perfomance either by query folding or by sql on the db side, i.e. join/aggregate/filter dataset by sql rather than by PQ query.
Frankly speaking, sql is more relaible than PQ query in terms of performance.
CNENFRNL I am trying to aggregate some columns but I need all of them as they interact together.