Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Muthu
Partner
Partner

Required RAM size to open QV Application

Hi Team,

I have my application size which is of 4 GB,

what would be the required RAM size to open the QV application in my PC.

As of now I have a RAM size of 4 GB but I am not able to open the app.

Regards,

Muthu

2 Replies
mayankraoka
Specialist
Specialist

Hi Muthu,

It depends on multiple factors.below likn and simulator can help you to identify the system requirments.

Qlikview Server RAM Calculator.xlsx

Download it and make your simulation.

Regards,

Mayank

petter
MVP
MVP

A QVW-file with a fully developed application and non-trivial data size always take more space in memory than on disk. The file image is hghly compressed. So an application might easily expand to twice and much more when it is opened. It is hard to give an exact figure due to several factors that determine in-memory compression vs on file compression.

So I would say that 4GB memory for a 4GB QVW-file is impossible or next to impossible. My gut feeling tells me that at least 8GB but maybe even 16 GB of RAM would be necessary to run the app at speed. The Windows itself needs quite a bit of memory to run at normal speeds.

The good news is that if you are in control of the application it is possible to tune an application to use much less memory and become much speedier even without doing much about the number of rows in each table. The important thing is to get rid of unneccessary fields and tuning the cardinality of values for each field (if possible) that has many values (rows). Even splitting fields with high cardinality into multiple fields of much lower cardinality. Timestamps are really often the bad guys that require lots of memory if not rounded off to a precision that is necessary for analysis purposes.