I have some scripts in my application which takes longer time to load.
for i = 1 to 365
$(i) as day,
sum (if($(i) < f1,f3,0) as g3
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 :)
Retrieving data ...