Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sundarakumar
Specialist II
Specialist II

Memory of Hidden objects in server

Hi All,

Will a Hidden object consume server memory while the user access the particular sheet, where this hidden object is present? or is it like a minimised object.

This hidden object a Pivot table which will be shown only on a filter selection. The hide condition is set in layout tab.

Can someone pls help with this?

-Sundar

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

I doubt that memory consumption is causing poor performance in your dashboard, unless your server has too little RAM for your application.

I would look at the structure of your model -

     Is your data model a well formed star schema, or is it more complicated?

     Are the tables associated using a single key, or a simple composite key?

     Are there a lot of rows in tables that are not associated with any other tables?


And the expressions -

     Do you use calculated dimensions (especially if these could be replaced by derived fields during load)?

     Do you use sum(if()) structures or similar structures requiring massive joins

     Are your expressions very complex (Pick(Match()) or deeply nested If() statements, many terms...

Any of these can cause performance issues, especially when the fact table(s) contain millions of rows.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

12 Replies
sundarakumar
Specialist II
Specialist II
Author

Hi All,

Any thoughts please......

jagan
Luminary Alumni
Luminary Alumni

Hi,

Hidden objects won't consume memory, you can test like this.

Step 1: For unhidden object

Sheet Properties -> Objects-> Check the corresponding Object Memory value.

Step 2:

Now hide the object by using Chart Properties -> Layout -> Show - Conditional = 0

Now check memory size

Sheet Properties -> Objects-> Check the corresponding Object Memory value.

you will get memory size as 0.

Hope this helps you.

Regards,

Jagan.

sundarakumar
Specialist II
Specialist II
Author

is it calctime or memory?

jagan
Luminary Alumni
Luminary Alumni

Hi,

Calctime is for calculation time and Memory is for memory occupied, in your case it is Memory.

Regards,

Jagan.

sundarakumar
Specialist II
Specialist II
Author

Hi jagan,

I tried out what u have suggested in Step1 and step2 above, Looks like there is no change in memory for a object when it is hidded or shown. Only the calctime changes to zero when i hide the object. Does that mean hidden object takes ram? Pls suggest..

-Sundar

Anonymous
Not applicable

No , it will also not take any memory while hidden.....

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

A hidden object may consume memory. If it has been un-hidden at some point, then it will have been calculated, and the calculation results would be stored in cache memory. I don't think that the cache would be cleared if the object is hidden again using an action. Perhaps someone from Qlik would like to add to this discussion.

HTH

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
sundarakumar
Specialist II
Specialist II
Author

Nitin,

I have  a pivot table which will return me millions of rows by default. In layout condition I have given a condition to make to chart pop up only if a shop is selected. with a single shop selected it would be only hundred rows in pivot table. My Dashboard porformance is not good. Do u think this hidden pivot table takes ram and makes the dashboard perform slow. Am aware of "calculation condition" in general tab. But i have not give any condition to it. Will a hidden object take memory for calculations on user selections? what if the user selects a country? will my pivot table which is hidded consume memory?

Pelase advise..

-Sundar

Anonymous
Not applicable

Until the object is hidden (Layout>Show>Conditional),

It do not take RAM .

The abject will be calculated only when it is shown......