topic Re: Limit RAM usage for loads in QlikView https://community.qlik.com/t5/QlikView/Limit-RAM-usage-for-loads/m-p/303524#M710748 <HTML><HEAD></HEAD><BODY><P>Thanks, the load is very straight forward with just the grouping that complicates it.&nbsp; While waiting for an answer here, I have been in discussion with support and they confirmed that QV is acting as designed.&nbsp; 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.</P></BODY></HTML> Tue, 31 May 2011 19:53:22 GMT 2011-05-31T19:53:22Z Limit RAM usage for loads https://community.qlik.com/t5/QlikView/Limit-RAM-usage-for-loads/m-p/303522#M710746 <HTML><HEAD></HEAD><BODY><P>We are running Qlikview desktop on a machine with 24GB of RAM and have a load from a qvd with a group by clause.&nbsp; While loading Qlikview creeps up to using all the available RAM and this is causing issues with other processes on the box.&nbsp; Is there a way to limit the amount RAM Qlikview uses for loads?&nbsp; We'd like to limit it the 16GB or so.</P></BODY></HTML> Mon, 16 May 2011 19:45:00 GMT https://community.qlik.com/t5/QlikView/Limit-RAM-usage-for-loads/m-p/303522#M710746 2011-05-16T19:45:00Z Limit RAM usage for loads https://community.qlik.com/t5/QlikView/Limit-RAM-usage-for-loads/m-p/303523#M710747 <HTML><HEAD></HEAD><BODY><P> 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.</P></BODY></HTML> Tue, 31 May 2011 19:39:43 GMT https://community.qlik.com/t5/QlikView/Limit-RAM-usage-for-loads/m-p/303523#M710747 2011-05-31T19:39:43Z Re: Limit RAM usage for loads https://community.qlik.com/t5/QlikView/Limit-RAM-usage-for-loads/m-p/303524#M710748 <HTML><HEAD></HEAD><BODY><P>Thanks, the load is very straight forward with just the grouping that complicates it.&nbsp; While waiting for an answer here, I have been in discussion with support and they confirmed that QV is acting as designed.&nbsp; 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.</P></BODY></HTML> Tue, 31 May 2011 19:53:22 GMT https://community.qlik.com/t5/QlikView/Limit-RAM-usage-for-loads/m-p/303524#M710748 2011-05-31T19:53:22Z Limit RAM usage for loads https://community.qlik.com/t5/QlikView/Limit-RAM-usage-for-loads/m-p/303525#M710749 <HTML><HEAD></HEAD><BODY><P> Glad you found a solution.</P></BODY></HTML> Tue, 31 May 2011 19:58:30 GMT https://community.qlik.com/t5/QlikView/Limit-RAM-usage-for-loads/m-p/303525#M710749 2011-05-31T19:58:30Z