topic Re: Application Taking up all the memory in QlikView

Application Taking up all the memory

Tue, 10 Jan 2017 22:28:00 GMT

Hello

I have a qvw that is 2.5 gb in size. When I try to open the file in qlikview it hangs my computer.

I am on Windows 10

Desktop Client: 12.1 SR1

RAM on my computer: 12GB Processing Power

Note: I have been ale to access the application before. I am not sure what is happening now.

Please advise on what should I do?

Thanks

Rizwan Syed

Re: Application Taking up all the memory

marcus_sommer — Wed, 11 Jan 2017 15:23:17 GMT

Take a look on the compressing-settings of this application then if this application is compressed it might be a lot bigger within the RAM - depending on the kind of data within it it could be easily a factor of 8 which would lead to a real filesize of 20 GB and which is more than you have on RAM.

To open the application you could open them without data:

and then to check the compression setting and then to reload the application within the debugger with a reduced number on records and afterwards you could check the datamodel to synthetic keys, the use of the document analyzer from Rob Wunderlich and some other things too - to optimize your application.

If there is really not much to optimize you will need more ressources on (CPU and) RAM to handle it.

- Marcus

Re: Application Taking up all the memory

enriquem — Wed, 11 Jan 2017 15:36:20 GMT

Whow!! I can't believe that you use this amount of data.

You can try to compress the file with the 'High' option in Document properties, but with this set of data maybe you must try to delimit your data by dates (years for examples), do a clean of your data set removing the columns or data that you don't use it.

Regards