6 Replies Latest reply: May 29, 2016 4:30 PM by Peter Cammaert RSS

    Issue with ram usage

    Pedro Souza



      I have an application that uses data from a huge SQL database. When I open it takes more than 60 gbs of ram, so I started to look for optimization tips.


      I created a mem file and noticed that most of the RAM is being used by database (class), field (type) and symbols (subtype). The field that uses more memory is hash128(field1,field2,field3). Field 1 to 3  is a complex SQL key... I can't get rid of it. It connects the 3 biggest tables in the script.


      All three are integer fields.


      Should I use another function other than hash? Should I "treat" these fields somehow in SQL before loading them into Qlikview?


      What should I do to free RAM?