Need to optimise performance

[#1]

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...

[#2]

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 🙂