topic Re: Scalability Matrix calculation in QlikView

Scalability Matrix calculation

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

We have 32GB RAM and approx average 100 mb size of application.
Average application count is 80. Concurrent users-30 and currently cpu utilization 40%.
we have 300 license on the server we want to increase 100 more.We are using QV 10.

I have gone through the scalability matrix but not understood the below formula.

It will be great if anyone help me abot this.

RAM = (RAMuser × No. users) + RAMinitial
Where
RAM〗initial = QVWsizedisk × FileSizeMultiplier; this is the initial RAM footprint for any application
RAM〗user =〖RAMinitial × userRAMratio; this is the RAM each incremental user consumes
QVWsizedisk = SourceData × (1 - CompressionRatio); this is the size, on disk, of a
QlikView file

Re: Scalability Matrix calculation

Clint_Carr — Tue, 29 Apr 2014 06:13:44 GMT

Hi Suman,

The RAM footprint is typically calculated as:

1. Source Data Size on Disk is compressed approximately 90%.

2. When the application is loaded into RAM as a QVW the size expands ~4 times

3. Each subsequent user typically adds ~2 - 5% of the inital load (discovered in step 3). This amount changes based upon usage of the application, more caching reduces size.

So if we have 1000Mb (1Gb) of source data we can predict the size of the QVW file will be ~100Mb.

If this application is loaded into RAM we can expect ~400Mb of RAM being used.

Each additional user will then add 2-5% so 8 - 20Mb of RAM.

So total RAM used = (Initial Load) + ((RAM Per User)*Concurrent Users)

The above can fluctuate up or down depending on cardinality of the data.

Clint

Re: Scalability Matrix calculation

jagan — Tue, 29 Apr 2014 07:32:11 GMT

Hi,

Please find attached PDF and refer Page 6.

Regards,

Jagan.

Re: Scalability Matrix calculation

Anonymous — Tue, 29 Apr 2014 08:59:49 GMT

Hi Jagan,

Thanks for your time.

I have the document but somehow I could not understand.

Regards