Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

datalakeyu
Valued Contributor

Qlik sense resident table issue

I am trying to use Qlik sense resident table to calculate two columns from two different tables.

However, there is a big issue when use resident table: each time I do a resident table it doubles the size of the output file even if I’m only adding one column of data and also use the Drop table.

My question is:

1: will using resident table increase Qlik sense app size?

2: will Drop table not release the memory and still increase the app size?

Thanks!


4 Replies
ahaahaaha
Honored Contributor

Re: Qlik sense resident table issue

Hi Haikuo,

Can see the data fragments of the source tables and what do you want to get as a result?

Regards,

Andrey

srivastava_sarv
Contributor III

Re: Qlik sense resident table issue

Ans 1.  Resident table increase minor Qlik sense app size.

Ans 2.  Drop table will release the memory.

sasiparupudi1
Honored Contributor III

Re: Qlik sense resident table issue

Make sure that your Resident table not doing a full outer join

Dropping a resident table will certainly drop the memory usage(depends upon the size of the table to notice the difference though)

Highlighted
rittermd
Honored Contributor

Re: Qlik sense resident table issue

When you use resident table in your script you are using a table that is already loaded in memory.  So that will not increase the size of what is being used. 

The size increase would depend on what you are trying to do and how you are doing it.  Can you share your code?

Dropping the table at the end when you don't need it any longer should free up the memory as you are getting rid of one of the tables possibly.  Again, depending on what exactly you are doing.