Applications takes "Pauses"

[sebastiandperei]

Dear All.

I have worked with many applications, even larger and more complex than this one, and this never happened to me.

My qvw takes 120Mb disk space, and 4Gb RAM. Sometimes, for some expressions, takes about 10 sec of 99% CPU (in a Phenom II x6, 4Ghz, 16GB RAM 2100Mhz Kingston Beast, 2 RAID SATA 3 HD), but it isn't the problem.

Sometimes, even if I go from a tab with a very simple table to another with the same table, the client is not responding by 15 seconds. The mouse cursor looks like it is "waiting to response" only in the QV app, and CPU charge value starts to change in random values between 5 and 99 %.

This application, in another pc, has no problems. What could be bad in my PC?

Thanks in advance!!

[patricio]

When loading documents in my desktop I have noticed that even if the script is simple, When there is an aggregation (group by) and the number of records is big there is a period of time where the document stays frozen. Also noticed that all the memory of my pc is used by that aggregation. Only released when I close all qlikview occurrences on my pc.

[sebastiandperei]

Thanks Patricio (o gracias Pato!)

This app is a Front End app. The tabs when it happens doesn't have any Aggr expression (only sum).

I have tried to increase de RAM limits and it's improved the App performance.

Anyway, i will take note about your comment!!! Thanks!!

[andrewpettit]

I would first ask what are the spec differences between your two machines? 

The next questions on my mind would be:

Are you using the Now() function anywhere in the application?  Including within a variable value.  If you are using the Now() function QlikView may be continuously reevaluating the expressions that utilize this function considering now is a constantly changing value.  For example is your create a text object where the text property is "=Now()" you can watch the time change constantly as QlikView keeps recalculating and updating the object.

Do you have any non-associated "data-islands" in your QVW?  If you have two fields from two decent sized tables that share no method of associating the data between QlikView will try to process all rows from one table with a full outer join to the other table, basically joining everything to everything.  This can be highly inefficient and can cause performance problems when this happens.

Are you utilizing any document triggers and actions?  If there is a circular reference here is it possible you are also using two different versions of QlikView; one where QlikView detects and terminates the self referencing loop and another where it does not do so near as quickly.

Do you have a lot of Hidden Objects or Hidden chart columns/expressions?  Again if your two machines are by chance running different versions of QlikView I believe in one of the 11.2 release a bug was introduced that caused hidden objects to still calculate.  This was corrected in 11.2 SR4 according to the release notes.

[sebastiandperei]

Hi Andrew, thanks for your answer!

1) Im not using Now

2) I haven´t

3) I was using, but i have checked it before

4) I will consider this bug! But in this case, it wasn't the problem.

Finally, increasing RAM was the solution. Thanks!!!!