Looking for ideas to optimize a QlikView reload task
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)
Re: Looking for ideas to optimize a QlikView reload task
When QlikView finished reloading, it has to build the Data Model. The process of building the Data Model sometimes takes time depending on the number of joins / associations QlikView has to create.
If it takes long to then you need to look at your code and see how you can optimized your application.
As there's no QVW file attached, there's no way to suggest how to optimized your application. However, there are several way to do this. If you need further suggestions from community post sample file.