0 Replies Latest reply: Oct 19, 2012 3:39 AM by Jagan Vijayakumar RSS

    Script takes more time to execute in server

    Jagan Vijayakumar



      Desktop: Qlikview Enterprise Edition 10 SR1

      Server: Qlikview 11


      I developed an application using Qlikview 10 SR1 which less than 3 mins to reload.


      When I deployed in Qlikview server 11 it takes more than 6 mins to reload.


      Could some one please let me know why it happens like this?


      I also generated the log file, the log file shows thaat after fetching data from first qvd it waits for a long time and goes for second qvd.


      First QVD START Time: 19/10/2012 08:11:25

      First QVD END Time:  19/10/2012 08:11:25

      SECOND QVD START TIME: 19/10/2012 08:16:52

      SECOND QVD END TIME: 19/10/2012 08:16:52

      THIRD QVD START TIME: 19/10/2012 08:17:24

      THIRD QVD END TIME: 19/10/2012 08:17:30


      All the 3 QVD's are autoconcatenated by qlikview.


      I use the following functions given belwo inside all the 3 QVD's


      date(date#(trim(month),'MMMM YYYY'),'DD/MM/YYYY') as monthdate,

      date(floor(MonthEnd(date(date#(trim(month),'MMMM YYYY'),'DD/MM/YYYY')))) as date,

      FLOOR(num(MonthEnd(date(date#(trim(month),'MMMM YYYY'),'DD/MM/YYYY')))) as date1,


      Please let me know the issue.


      Also when the task is run in server, the performance of server goes to 100% usage.


      Please let me know what should I have to do.



      Jagan. V