Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
lawrance
Creator II
Creator II

How to reduce Loading time in QlikView Access Point?

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

6 Replies
saimahasan
Partner - Creator III
Partner - Creator III

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

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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.

giakoum
Partner - Master II
Partner - Master II

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

Capture.PNG

awhitfield
Partner - Champion
Partner - Champion

Hi Lawrance,

FYi check out the following:

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

Preload in particular

HTH

Andy

lawrance
Creator II
Creator II
Author

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

marcus_sommer

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