topic Re: QlikView UI slowness in QlikView

QlikView UI slowness

innashna — Sat, 16 Nov 2024 20:47:51 GMT

Hello,

I have a small model of 185 MB . I can filter on it fast when it is in developer mode. But when it is in Access Point, each step takes 20 sec.! Please advise what can be the reason and how to check it.

Re: QlikView UI slowness

Vegar — Sun, 26 May 2019 08:25:46 GMT

Could you describe your environment(s)?

Do you have a QlikView Publisher? What's the specs (RAM/CPU) on the QV server (and on the QV publisher server)?

Re: QlikView UI slowness

innashna — Sun, 26 May 2019 08:37:51 GMT

Hi,

please see below and attached : we have QV publisher on QV server . In the attached I put RAM/CPU information.

Re: QlikView UI slowness

Vegar — Sun, 26 May 2019 08:51:31 GMT

I only see one screenshot, are you running QlikView server and Publisher on
the same server?

>From my experience QlikView need at least 4 CPUs to perform optimal. With
one or two you can get in trouble. In the system requirements it written
Multi-core but multicore should be interpreted as 4+.

Re: QlikView UI slowness

innashna — Sun, 26 May 2019 10:30:31 GMT

Hi, yes. We have publisher installed, but we don't use it.

Re: QlikView UI slowness

Vegar — Sun, 26 May 2019 18:36:27 GMT

Have you monitored the system resources when accessing the application from accesspoint? Compare it with using the desktop client. It could give you a hint of what's happening.

Off topic: Why aren't you using the publisher? It has many great features/benefits even when it's installed on the same server as the QlikView Server installation.

Re: QlikView UI slowness

innashna — Mon, 27 May 2019 12:42:31 GMT

Hi,
Not sure why we are not using a publisher, I think it is a matter of license cost.
Regarding the performance. I followed up the task manager while filtering the model in AP, seems like CPU get stuck - when I click on filter they up to 17%, then they get down to 0%, but seems they are stuck like the model itself:
[cid:image001.png@01D514A2.B9118BD0]

Re: QlikView UI slowness

Vegar — Mon, 27 May 2019 13:30:29 GMT

Are you using Internet Explorer and IE Plugin? If yyes then read this support document. https://support.qlik.com/articles/000070544

Re: QlikView UI slowness

innashna — Tue, 28 May 2019 07:56:31 GMT

Hi,
I use Google Chrome.

Re: QlikView UI slowness

Vegar — Tue, 28 May 2019 09:16:59 GMT

You got how many locgical CPUs? Four or more?

Re: QlikView UI slowness

TechResource — Wed, 29 May 2019 02:29:31 GMT

Check if you have sufficient RAM and the RAM is not consumed fully by any other application.

Try using I.EPlugin to access the application.

Re: QlikView UI slowness

marcus_sommer — Wed, 29 May 2019 12:54:46 GMT

Beside the available resources from the server it's possible (but IMO rather unlikely whereby you could check if there are any proxy-server between your browser and the Qlik server) that there is a network-delay (if so it should be noticable with nearly all applications and not only a few).

Another more probable cause could be that there is any section access which might break some calculations. The easiest check would be just to disable it.

Furthermore take a look on the used releases from the client and the server - both should be the same.

- Marcus

Re: QlikView UI slowness

brandk — Fri, 14 Feb 2020 10:20:47 GMT

Hi @Vegar we are also having a similar problem. We are considering increasing the RAM but this will obviously cost money. Is there a way or test to find out if increasing RAM would actually improve our performance before actually committing? We have very large datasets

Re: QlikView UI slowness

Vegar — Fri, 14 Feb 2020 10:40:25 GMT

You could monitor your RAM usage and how much you use swap memory.