topic How to quantify memory usage of one chart versus the other? in QlikView

How to quantify memory usage of one chart versus the other?

Wed, 23 May 2012 17:25:30 GMT

How can one understand and quantify, how much memory is used in one type of chart/expression versus the other chart/expression. The reason I ask is I want to set some limits for following under Qlikview Enterprise Management console >> System >> Setup >> Performance >> Max Memory

- Calculated Formulae

- Export to Excel

- sort by expression.

Is there a mathemetical way of calculating how much memory/RAM is used by an expression or how much memory is used by a chart when user exports it to excel?

How to quantify memory usage of one chart versus the other?

kaushiknsolanki — Wed, 23 May 2012 17:48:31 GMT

HI,

Go to Settings-> Document Properties -> General Tab-> Click on Memory Statistics.

Save the file and then open that file in another QVW and you will get the memory usage of each chart available in that application.

Regards,

Kaushik Solanki

How to quantify memory usage of one chart versus the other?

garystrader — Fri, 25 May 2012 14:39:49 GMT

There's no mathematical way. The problem is that each new concurrent user on the server will add more RAM overhead to your application. You also don't know which charts each user will view or which filter selections they will make. Each time you reload the data, the memory profile could change.