What exactly happens when you open an application in Qlik Sense?

[bwisealiahmad]

Hi,

I was wondering if anyone here can give me some insight to what actually happens process wise when you open an application in Qlik Sense?

Reason I am asking is I have an application that is becoming increasingly slower to open and to get into the Data Load Editor. The entire purpose of the application is to Extract data and store into QVDs and the average reload time has increased over time. When I finally get it opened and in Data Load Editor the actual reload doesn't take long.

1. Is a task reload execution considered from when application is "opened" to finished loaded?
2. What is actually happening when you open an application? Does it check connections? Does it create any variables? What is it that could make it go slower when it comes to opening the actual application?

Thanks for any replies, hints, tips etc.

//

AA

[petter]

If the entire purpose is to create QVDs check if the load script has

DROP TABLE <tablename>;

after each

STORE <tablename> INTO <tablename>.QVD (QVD);

If you don't you will store unnecessarily the data in your QVW for no purpose. It takes time at the end of the load script to create indexes and create the associations. It takes space on disk with a larger QVW and it takes time when reloading and opening because it is burdened with an unnecessary data model....

[bwisealiahmad]

It has the store and drop statement for each table it loads.

I created a new app and copied scripts for each tab over and now it runs fine again. I think this is a bug.

Opening the app on the old one is very slow, but the actual load of data and storing into qvds is fast and fine.

Få Outlook for Android<https://aka.ms/ghei36>

[petter]

Are you running the latest version of Qlik Sense 3.2 SR 1?

[bwisealiahmad]

Yes.

I've opened a case with Qlik and very curious to see what they say about this. It's simply a QVD generator with script from qlik deployment framework for generating qvds and stores and drops everything. No sheets with objects and average reload time has increased gradually over time.

Opening the application is very slow and entering data load editor is very slow, but when I get to the point and I can press reload data and run it that actual process runs fine. About a minute or so.

Få Outlook for Android<https://aka.ms/ghei36>