Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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
Author

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
Author

Glad you found a solution.