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

    Issue with ram usage

    Pedro de Matos Souza

      Hi,

       

      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?

       

      Regards,

       

      Pedro.