topic Re: What affects the application saving time? in QlikView

What affects the application saving time?

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

There is an application about 70 MB (compressed). If I open and save it in QV Desktop, the saving process takes about 40 sec. An updated version of this application (just some front end changes) takes four minutes to save.

In both cases application is opened (and saved) on a tab that has nothing but one list box. I don’t expect any calculations at all. Both applications are compressed (high). Speaking of compression – I tried to save the “slow” version without compression, usually it helps to reduce save and open time. Surprisingly, the saving time was almost the same, maybe only 15-20 sec faster.

Any ideas what may affect saving time?

Thank you,

Michael

Re: What affects the application saving time?

Anonymous — Thu, 03 Oct 2013 13:48:35 GMT

Looks like I've figured out the reason. Now trying to find a cure.

Reason.

Both versions of application have charts with complex calculations, and the newer version has more of that. All charts are on the hidden tabs at the time of saving. That is, before saving the only visible object is a list box (and it is a data island). By theory, no calculatios should be performed on the charts which are on the inactive tabs, but apparently it doesn't work per theory. To test, I removed the charts on a hidden tab and saved the file. It took just 20 sec to save.

Cure.

The first thought was to add calculation conditions to all charts (on top of the fact that tha tabs are hidden). Charts are (should be) calculated on the same condition as the tab with the charts is visible. It didn't help a bit. Only removing the charts makes the difference.

Willing to try any crazy ideas.

Thanks,

Michael

Re: What affects the application saving time?

Clever_Anjos — Thu, 03 Oct 2013 14:09:43 GMT

Does your app have synthetic keys?

Re: What affects the application saving time?

Anonymous — Thu, 03 Oct 2013 14:22:15 GMT

The application doesn't have synthetic keys.

In any case, it looks like the data model is not an issue - the front end is. If I remove several charts, it doesn't change data model, but the saving time is very good. And, the older version of application has the same data model, the difference is on the front end.

Thanks,

Michael

Re: What affects the application saving time?

swuehl — Mon, 14 Oct 2013 14:25:36 GMT

Michael,

you just saved my life.

I had a similar issue, which really frustrated me:

I created an app (2 GB qvw size, expanded to ca. 9 GB in memory) with some quite complex charts.

Worked ok for a while, until I noticed that the opening time on server and in the desktop increased to some unbelievable value (some 10 minutes on desktop, stopped the server task after some hours).

The system allocated RAM increased as usual to some 9 GB in short time, but then keep allocating slowly changing (allocating 10-100 kB per sec) with very small CPU usage (single core only). This could go for ages (on the server), also seems to blocking opening / working with other apps.

After desparately searching the release notes (the client still uses 11.0 SR1) and the forum, I came across your post.

Only then I remembered that I also had some charts copied to a hidden tab. After removing the tabs completely, performance turned to be fine again.

Thanks for getting me on the right track, never had thought that hidden tabs would prevent me from opening an application.

Regards,

Stefan

Re: What affects the application saving time?

Anonymous — Mon, 14 Oct 2013 15:51:27 GMT

Sometimes saving lives is easy...

I'm wondering why it works this way. Hidden and minimized charts, and charts on other tabs than the active one(hidden or not) should not be calcualted, according to QlikTech. Something's changed.

Regards,

Michael

Re: What affects the application saving time?

Wed, 01 Jan 2014 06:30:21 GMT

Is there a way to save the META-DATA only (scripts, objects, layouts, variables) without saving the DATA?

Re: What affects the application saving time?

Wed, 01 Jan 2014 07:08:40 GMT

Hi Michael Solomovich and swuehl

I previously had problems in QV desktop with the calculation time and memory usage for hidden objects in an activated sheet.

After raising this to QT, they fixed it in version 11.20 SR4 (bug 62101).

But I didn't check if this was also affecting the saving time.

It could be worth trying to upgrade in case you're using an earlier version, at least hidden objects won't be calculated anymore which has a performance impact in big apps.

Happy New Year !

Re: What affects the application saving time?

Anonymous — Thu, 02 Jan 2014 14:36:28 GMT

Sure.

Go to File - Reduce Data - Remove All Values. Save, better as a different file.

Regards,

Michael

Re: What affects the application saving time?

Anonymous — Thu, 02 Jan 2014 14:50:42 GMT

Hi Jean-Pierre Bakhache,

Yes, it was an older version - 11.20 IR. Now I have SR5, and saving time is 6 min. Oh well...

Thank you anyway, Happy New Year!

Re: What affects the application saving time?

Thu, 02 Jan 2014 14:51:40 GMT

I have a 4GB datamodel which takes over 30 minutes to save everytime i make some design changes. I cannot figure out what the problem is, cause i do not have some complex expressions. Only large data (around 100 mil).

The ram usuage is fine - i have over 15 GB free. But it takes up all my CPU when saving.

Re: What affects the application saving time?

Anonymous — Thu, 02 Jan 2014 14:58:10 GMT

Thomas,

It is natural that the large file takes long time to save. My situation is quite different - the problem is in the front end. If I remove the charts but keep the data, saving takes short time.

Regards,

Michael

Re: What affects the application saving time?

Thu, 02 Jan 2014 16:10:30 GMT

Hi Michael,

Try to increase your CPU virtual memory size,

My Computer ->then right click -> Properties -> Advanced- > Performance -> Settings(Press) -> Advanced(Tab) -> Change->Custom Size .

Re: What affects the application saving time?

Anonymous — Thu, 02 Jan 2014 18:46:15 GMT

Thanks Raja, but it is not relevant in my case. Virtual memory may speedup charts calculations - but they should not be calculated on save, especially if they are on the inactive tabs.

And the computer has enough RAM already, so adding virtual memory doesn't make any difference.

Thanks anyway,

Michael

Re: What affects the application saving time?

Thu, 02 Jan 2014 19:02:44 GMT

Thanks Michael...

Re: What affects the application saving time?

Tue, 14 Jan 2014 14:21:54 GMT

Thanks Michael, very useful post, you have solved a big problem for me!