Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
sundarakumar
Valued Contributor 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
MVP
MVP

Re: Memory of Hidden objects in server

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
12 Replies
sundarakumar
Valued Contributor II

Re: Memory of Hidden objects in server

Hi All,

Any thoughts please......

MVP & Luminary
MVP & Luminary

Re: Memory of Hidden objects in server

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
Valued Contributor II

Re: Memory of Hidden objects in server

is it calctime or memory?

MVP & Luminary
MVP & Luminary

Re: Memory of Hidden objects in server

Hi,

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

Regards,

Jagan.

sundarakumar
Valued Contributor II

Re: Memory of Hidden objects in server

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

gupta_n8
Valued Contributor II

Re: Memory of Hidden objects in server

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

MVP
MVP

Re: Memory of Hidden objects in server

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
Valued Contributor II

Re: Memory of Hidden objects in server

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

gupta_n8
Valued Contributor II

Re: Memory of Hidden objects in server

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

It do not take RAM .

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