Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
brunodec
New Contributor III

Delete mapping tables to free memory

Hello,

Mapping tables are automatically deleted at the end of script execution. However is there a way to delete a mapping table during script. Would that be useful to free memory in case of large mapping tables only used once in the script ?

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Delete mapping tables to free memory

Robert, are you sure about that?

I believe you can only DROP resident tables and I get 'table not found' if I try to DROP mapping tables (and to answer the OPs question, I don't know any other method to delete  mapping tables during script run).

View solution in original post

14 Replies
Highlighted

Re: Delete mapping tables to free memory

You can always drop the table during the scripting execution.

Highlighted
MVP
MVP

Re: Delete mapping tables to free memory

Robert, are you sure about that?

I believe you can only DROP resident tables and I get 'table not found' if I try to DROP mapping tables (and to answer the OPs question, I don't know any other method to delete  mapping tables during script run).

View solution in original post

Highlighted

Re: Delete mapping tables to free memory

You are right Stefan.

I misunderstood the question.

Bruno please ignore my advice.

Highlighted

Re: Delete mapping tables to free memory

your rite, Mapping tables will be automatically deleted at the end of the script and we don't have the control to delete it in the middle .

Highlighted
amit_saini
Honored Contributor III

Re: Delete mapping tables to free memory

Hi Bruno,

Mapping table gets deleted automatically when you are running the script. If they are still present than could be something wrong with ur script.

Thanks,

AS

Highlighted
pradeepreddy
Valued Contributor II

Re: Delete mapping tables to free memory

Mapping Tables will be deleted automatically at the end of the script execution.

We can't drop/delete the mapping tables in middle of the script execution.

Highlighted
HirisH_V7
Honored Contributor

Re: Delete mapping tables to free memory

Hi,

I don't think you need to check, they do get deleted after reload.

If mapping tables were there, your model would be screwed up.

Use a system table to verify.

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
Highlighted
Partner
Partner

Re: Delete mapping tables to free memory

How big is your mapping table?

Does it contain huge number of rows?

Mapping table will not take much memory and doesn't make any difference even if you are able to delete during the script execution as it contains only 2 fields.

Cheers,

Naresh

Highlighted
brunodec
New Contributor III

Re: Delete mapping tables to free memory

Hi Naresh,

Currently I'm building a model in test so impact is small but when going into production I will have about 60 mapping tables with some of them having more than 50k rows, So technically this would mean maximum 3 million rows stored in memory during the whole script run. As of course also the resident tables are in memory I thought it would be good to delete tables from memory - whether it be mapping tables or resident tables. But apparently it is not possible.
If you say mapping tables don't take much memory then this is good news. I felt some compassion with my computer who needs to handle so much data 🙂

Thanks,

Bruno.