4 Replies Latest reply: Apr 3, 2015 7:03 AM by sujeet singh RSS

    Looking for ideas to optimize a QlikView reload task

    Bertrand HERARD

      Hi,

      on a QlikView Server 11.2 SBE (without Publisher), I'm trying to optimize the reload of a QlikView File (which is frequently reloaded). Is anyone know what QlikView does in the following part of the task ? (and know how to accelerate it) :

       

      (2015-04-03 10:58:43) Information: Reloading

      (2015-04-03 10:58:50) Information: The Source Document reload complete. DocumentPath=E:\QLIKVIEW\APPLICATIONS\PPD\INTERFACE\NUX\NUX.qvw

      (2015-04-03 10:58:50) Information: Memory Allocation Delta for this file=178.04 Mb. Available Physical Memory Before Reload=21454.67 Mb. Available Physical Memory After Reload=21292.73 Mb. Total Physical Memory=21292.73 Mb.

      (2015-04-03 10:58:53) Information: Reloading.

      (2015-04-03 10:59:03) Information: Reloading..

      (2015-04-03 10:59:04) Information: The Source Document was reloaded successfully.

       

       

      Details : my tasks last 1 min 25 s while the reload last only 34 s. Looking in logs, I found that the 1min34s can be split like this :

      2 s : QlikView task initialization and start (OK)

      9 s : Opening QlikView File (OK, if someone have tips to accelerate It, I'm interesting in).

      34 s : QlikView File reload (OK)

      20 s : don't know what's QlikView is doing and that's my main question (in my example above the QlikView reload is finished at 2015-04-03 10:58:44)

      19s : saving file (OK)

      1s : closing QlikView Reload task (OK)

       

      Regards