topic Re: Saving App Very Slow in QlikView

Saving App Very Slow

Anonymous — Wed, 15 Jul 2015 19:29:26 GMT

I have an app which is taking a enormously long time to save. The app's script simply contains a binary statement to load the data. The GUI contained within the app is 95% hidden during save so charts, etc. should be inactive. There are maybe 3 text objects on the "splash" screen displayed during the save with no calculations. I've disabled compression - yet the save process can take up to 5 or more minutes to complete.

Any suggestions/ideas?

Re: Saving App Very Slow

dionverbeke — Wed, 15 Jul 2015 19:48:47 GMT

Actually enabling compression saves you time if you have a slow disk as there is less data to write on disk.

Are you by any chance saving to a network drive? That usually takes a long time.

Also try defragmenting your disk.

How big is the document you are trying to save?

Usually disks are saving at a speed of 20MB/s. If you have 1 Gig to save,

it will take you at least 1000/20 = 50 seconds to save.

Dion

Re: Saving App Very Slow

rwunderlich — Wed, 15 Jul 2015 22:26:57 GMT

How big is he file on disk when it's saved?

-Rob

Re: Saving App Very Slow

Anonymous — Thu, 16 Jul 2015 17:17:49 GMT

File is right at 1 GB on disk after save. The app containing the script to build the data model is the same size (and same settings) but saves in less than 5 seconds.

Re: Saving App Very Slow

settu_periasamy — Thu, 16 Jul 2015 17:34:21 GMT

Hi,

i also faced the same issue.

Can you check the below links.

QV document save - not responding

What affects the application saving time?

Re: Saving App Very Slow

swuehl — Thu, 16 Jul 2015 17:39:18 GMT

settu_periasamy wrote:

Hi,

i also faced the same issue.

Can you check the below links.

QV document save - not responding

What affects the application saving time?

Me too, see second link (which I just was about to search for).

Re: Saving App Very Slow

Anonymous — Thu, 16 Jul 2015 18:04:03 GMT

Swuehl / settu_periasamy,

Thanks for the suggestion -however, I've seen these discussions and neither offer a solution that resolves the issue.

Re: Saving App Very Slow

rwunderlich — Fri, 17 Jul 2015 01:18:25 GMT

Try this as a debugging exercise. Binary load the data model in a new qvw with no UI elements. What's the save time of this one relative to the qvw that has UI elements?

-Rob

Re: Saving App Very Slow

Anonymous — Fri, 17 Jul 2015 14:15:33 GMT

Rob - following your suggestion, the save time for the test app was less than 10 seconds (compared to 5+ mins. save time for app with UI elements).

So this isolates the UI as the root cause for the slow save time - but there are no calculation driven objects visible during save...???

Re: Saving App Very Slow

rwunderlich — Sat, 18 Jul 2015 01:35:26 GMT

Good info. what's the difference in the file size between the file saved without ui and the file saved with? Are both compression off?

Re: Saving App Very Slow

Anonymous — Mon, 20 Jul 2015 14:47:18 GMT

file size with UI = 933,027 kb

file size without UI = 928,772 kb

yes - compression is off in both.

Re: Saving App Very Slow

rwunderlich — Mon, 20 Jul 2015 22:15:39 GMT

My next suggestion would be to start deleting UI objects -- perhaps a sheet at a time -- to try and isolate where the problem is. That doesn't solve your problem, but if you can identify a "bad guy" maybe a fix or workaround can be created.

-Rob