Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi Haikuo,
Can see the data fragments of the source tables and what do you want to get as a result?
Regards,
Andrey
Ans 1. Resident table increase minor Qlik sense app size.
Ans 2. Drop table will release the memory.
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)
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.