topic Re: QVW file size in QlikView

QVW file size

Tue, 22 Oct 2013 15:57:59 GMT

Hi,

I have a qvw application with size 146 MB . will it creates any problem if I make vailble this file in access point. And I have Ajax Client.I need to give to five users to access this file.

Please can anyone let me know.

Re: QVW file size

Clever_Anjos — Tue, 22 Oct 2013 16:15:34 GMT

It depends on:

1) You server RAM

2) Is your app compressed or not

3) How many tables and synth tables you have

4) Complexity of your objects (too many columns into a table for example, can lead to memory overflow)

Re: QVW file size

Tue, 22 Oct 2013 16:18:30 GMT

My application is compressed as High and I need to have too many columns in straight and pivot tables as per business. and I have 72Gb RAM in server and only 40 GB is free. Is all this conditions will meet the application?

Re: QVW file size

jaimeaguilar — Tue, 22 Oct 2013 19:15:52 GMT

Hi,

you may follow these steps (is just an approximation, but it can be useful):

1. Open your .qvw in desktop and change the compression high to none (Document properties > General). This way you can see the actual size of your qvw.

2. Multiply the uncompressed size of your qvw times 4 (it is roughly the size it will use in RAM).

3. Every concurrent user will add roughly 10% in RAM (so it would be the result of step 2 plus 10% RAM of original qvw for every concurrent user).

For example, let's suppose your uncompressed qvw is 500 MB:

500 MB * 4 = 2000 MB in RAM

2000 MB * .10 = 200 MB for every extra concurrent user

2000 MB + ( 200 MB * 5 Users) = 3000 MB. So your worst case would be to use almost 3 GB in RAM, if your 5 users are connected at the same time.

Like I said this is an approximation, but can give you an idea of the sizing of QV Environment,

regards

Re: QVW file size

Clever_Anjos — Tue, 22 Oct 2013 19:23:18 GMT

Complementing the response by Jaime Aguilar, be carefull about tables with too many columns/rows. If your users are "Send to Excel"-Addicted you can experience poor response times

Re: QVW file size

Ricardo_Gerhard — Tue, 22 Oct 2013 19:26:15 GMT

To discover amount of memory you need, try this steps:

- Close your Qlikview Desktop;

- Open Qlikview Desktop and open your document;

- After it, take a look in Task Manager > Process, how many memory was consumed for QV.EXE;

- This value is the document memory.

Use this formula to know approximate amount of memory required:

Document Memory + ((10% of Document Memory) * Total Users) = total memory.

It´s a simple practice.