Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Limit RAM usage for loads

We are running Qlikview desktop on a machine with 24GB of RAM and have a load from a qvd with a group by clause.  While loading Qlikview creeps up to using all the available RAM and this is causing issues with other processes on the box.  Is there a way to limit the amount RAM Qlikview uses for loads?  We'd like to limit it the 16GB or so.

3 Replies
Not applicable

Limit RAM usage for loads

A group by clause is expensive when reloading from a qvd. Can you post your current script? Maybe there's a better way to load the data that we can come up with.

Not applicable

Re: Limit RAM usage for loads

Thanks, the load is very straight forward with just the grouping that complicates it.  While waiting for an answer here, I have been in discussion with support and they confirmed that QV is acting as designed.  I have since fallen back to doing the group by with a SQL select instead of the load from the qvd it's slower but doesn't impact the system resources nearly as much.

Not applicable

Limit RAM usage for loads

Glad you found a solution.