Re: Will Qvw with 211 MB in access point fit - Qlik Community

Report Inappropriate Content · ‎2013-11-19

Hi,

I have one qlikview file with size 211MB. will it create any problem to other files or to server if I made this qvw in Access Point. I have to assign 4 Document CALs to this file.

Could anyone let me know will it creates any problem. Please help me as it is urgent based on this I have to make this in access point.

Please help.

Thanks.

marcus_malinow · ‎2013-11-19

Hi Amelia,

as long as you have sufficient RAM on your server this shouldn't cause you any issues. This is a relatively small file, personally I'm used to dealing with QVW's ranging in size from 100Mb or so to tens of Gb's.

Marcus

Report Inappropriate Content · ‎2013-11-19

Hi,

Thanks and I have installed Memory 72.0 GB on Server.

Physical Memory(MB)

Total 73715

Cached 8980

Available 69129

Free 60276

will this sufficient for my file size?

sundarakumar · ‎2013-11-20

Hi Amelia,

I think you have enough RAM to publish the file.

A 1GB .qvw document uses around 4GB in RAM for the first user (based on a multiplier of 4x to establish the initial RAM footprint based on file size). This multiplier is normally between 2x and 10x. User number two may increase this by around 10% as their calculations get cached resulting in a required RAM footprint of 4.4GB. User number 3 requires a further 10%, increasing the footprint to 4.8GB, and so on.

Sundar

Report Inappropriate Content · ‎2013-11-20

Thanks and even for four document CALSsit won't create any problem is that correct?

sundarakumar · ‎2013-11-20

four user accessing the document with document CAL is not gonna make any problem....

To the max the application might take upto 2 GB RAM...... Do you have many other applications in the server??

Report Inappropriate Content · ‎2013-11-20

Yes I have some other qvw's in server but this is big one with size 211MB. will it create any problem?

sundarakumar · ‎2013-11-20

If you have deployed system monitor, please share the RAM usage trend...

Report Inappropriate Content · ‎2013-11-20

What it means system monitor and sharing of RAM usage?

Report Inappropriate Content · ‎2013-11-20

It hard to say without knowing anything about the structure of the document, the number of users, set up of services, usage of other documents and so on.