Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have some scripts in my application which takes longer time to load.
example:
for i = 1 to 365
load
f1,f2,f3,f4,f5,
$(i) as day,
sum (if($(i) < f1,f3,0) as g3
group by
f1,f2,f3,f4,f5;
How can I optimise this...?
Group by takes more time...
Is there a specific reason you need the group by?
I have never needed to use a GROUP BY with QV, since you can do that in the tables/chart easily. But I don't know the background of your request of course 🙂