topic Re: Optimization in accesspoint in QlikView

Optimization in accesspoint

varunvarma — Mon, 01 Feb 2016 16:33:34 GMT

Dear All,

Greetings!!

Need to know some optimization technic in access point.

Issue :- In my accesspoint URL, my application QVW (Size around 1 GB) is taking around 2 to 3 mins time to open. So please let me know how to reduce time to open fast.

My Server RAM size : 24 GB.

Please support. Thanks in advance.

Regards,

Varunvarma

Re: Optimization in accesspoint

alexpanjhc — Mon, 01 Feb 2016 19:25:21 GMT

Once it is opened in accesspoint, and it is in the memory, other user should open it pretty fast.

You can also check to see if all your fields are used, if not, comment out those unused fields.

Re: Optimization in accesspoint

maxgro — Mon, 01 Feb 2016 20:05:05 GMT

In the Documents --> Source Documents

you can find a preload option (bottom right in image)

From Qlik Help (top right in QMC)

Preload

To make the current document quickly accessed at all times, by preloading it into the primary memory of the server, tick this check box. To disable the preload function, untick this check box. Note!Using the preload functionality will use memory resources also when no user is accessing the document.

Re: Optimization in accesspoint

varunvarma — Wed, 03 Feb 2016 06:25:55 GMT

Dear M G,

Thanks for the info. But that option is not available in my server. My server is SBE. Please let me know. Thank u.

Re: Optimization in accesspoint

maxgro — Wed, 03 Feb 2016 19:07:45 GMT

I've just Checked in SBE; in SBE there is only one type of Documents

Documents --> User Documents

but the flag is still there