1 Reply Latest reply: Jan 10, 2010 6:27 PM by MManders RSS

    Need to optimise performance

    Blessy Jeyantha

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