topic Re: How to reduce Loading time in QlikView Access Point? in QlikView

How to reduce Loading time in QlikView Access Point?

lawrance — Tue, 15 Nov 2016 14:24:32 GMT

Hi,

In Access Point, one of my dashboard loading time is taking more. Could you please tell me how to fix that issue and what are the possibilities are available.

Regards,

Lawrance. A

Re: How to reduce Loading time in QlikView Access Point?

saimahasan — Tue, 15 Nov 2016 14:36:43 GMT

The application would have been heavy and so it takes time to load

Re: How to reduce Loading time in QlikView Access Point?

Peter_Cammaert — Tue, 15 Nov 2016 14:42:38 GMT

This should only happen the first time (after initial load, the document will stay in memory until the document timeout has been reached).

If you want to avoid this set-up time at all costs, you can decide to pre-load a document whenever the QVS service (re)starts. See QMC->Documents->User Documents->Select your document->Server->Performance->Document Control->Preload.

Re: How to reduce Loading time in QlikView Access Point?

giakoum — Tue, 15 Nov 2016 14:44:22 GMT

You can preload the document. There is a setting available for that:

Re: How to reduce Loading time in QlikView Access Point?

awhitfield — Tue, 15 Nov 2016 14:46:19 GMT

Hi Lawrance,

FYi check out the following:

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/QMC/Content/QMC_Documents_SourceDocuments_Templates_Server_Performance.htm

Preload in particular

HTH

Andy

Re: How to reduce Loading time in QlikView Access Point?

lawrance — Wed, 30 Nov 2016 01:41:50 GMT

Hi all,

Still loading issue is happening I enable the Preload option and my qvw size is 1.5 GB. can anyone please fix this issue.

Thanks,

Lawrance. A

Re: How to reduce Loading time in QlikView Access Point?

marcus_sommer — Wed, 30 Nov 2016 07:49:58 GMT

Beside preloading like suggested from the others you should take a look on the compressing-options from the application and disable compression it it's enabled (save only disc-space and need some overhead for compressing and de-compressing). Further if there is implemenented any section access it will slow down the opening because the data-reduction happens while opening - maybe you don't really need these section access or you could use the publisher with a loop and reduce approach.

Another important point is to optimize the datasize from the application itself (removing unneeded fields and fieldvalues, splitting high cardinality fields) and also optimize the objects and the number of objects on your landing page.

- Marcus