6GB App not loading in Qlik Sense

[morenoju]

Hi all,

I've created a Qlik Sense app with quite a lot of data, it weights almost 6GB. Since I loaded the data, I can't access the app overview because it times out. If I open it without data it works.

I've noticed that if I only load two months of data, it weights around 2GB and then it works fine.

I have 16GB of RAM in the server, maybe this is the reason why I can't access very large apps? Are there any recommendations on how much memory is needed to handle large apps? Or maybe this is unrelated? What do you guys think?

Thanks,

Juan

[petter]

6GB on disk could expand to as much as 30-60GB or even more in memory.

There is no single simple way of calculating this as it depends on a number of factors. You data model and the various cardinalities of each field play an important role.

The Windows Task Manager gives you a good indication of the memory footprint of an application when loaded. See how much memory is free before you load your 2GB app and after you have loaded it. This will give you some idea of the expansion factor.

[Ivan_Bozov]

Hi! I suggest that you explore Qlik's On Demand App Generation capability. Sounds like something you can use. Other than that, yes, the more RAM you have, the better the performance should be.

[morenoju]

The Qlik On Demand apps look quite cumbersome to the final user. What if instead of creating a new app we just want to keep the last X months of records in memory and load anything previous only if the user request it?

My users expect to the app to respond very quickly when analyzing recent records, but would accept some delays if going far back in the historical.

Is there any alternative for this?