QVWs responce speed becomes very slow when it occupies most of the RAM

[yujiyamane]

Hi there,

I am new to QlikView. Our QlikView server’s RAM keeps increasing up and our QVW's responce speed becomes very slow when it occupies most of the RAM. So I have to restart the QV services in a couple of weeks manually and I am sure it is not the best solution.

Does anybody have same experience? Any idea?

Yuji

[Clint_Carr]

Hi Yuji,

I believe you have posted this in the wrong area as this is a QlikView Server question.

However in response,  QlikView Server is designed to use as much RAM (up to Working Set limits) as needed by the application.

The following have direct influence on the performance of QlikView:

• Server type (amount of RAM / CPUs , Physical or Virtual etc)
• Application size (number of rows/columns)
• Application design (Number of calculations, variables, UI elements)
• Number and Type of Users

Kind Regards,

Clint

[yujiyamane]

Thank you for your quick responce.

> I believe you have posted this in the wrong area as this is a QlikView Server question.

Thank you. I have modified the area.

> The following have direct influence on the performance of QlikView:

Thank you for the information. I am just wondering why it becomes very slow only when it occupies most of RAM...

Yuji

[Clint_Carr · Accepted solution]

What QlikView does is perform calculations in real time from data loaded into RAM.

I suspect what you are experiencing is CPU resources being over utilised.  When your users are effected by the slow performance what is happening with the CPU?

Clint

[Colin-Albert]

There are many factor that influence server performance.

• How much RAM is installed on the server?
• How many CPUs are installed and which model are they?
• How many users are accessing the server?
• Is the server a physical server or virtual?

The application design can be a big influence. A poorly designed application can use excessive RAM and run slowly.

Does the data model have synthetic keys?

Can you post an image of the data model from the table viewer?

Do the expressions include "if" statements rather than set analysis?

[yujiyamane]

Hi Colin,

Apologies not to get back to you any earlier,  I have been away from community for long.

The issue has been solved by optimizing the document.

Thanks a lot for your kind respond.

Best regards,

Yuji