idea Re: Drop Mapping Table in Suggest an Idea

Drop Mapping Table

blaise — Mon, 14 Dec 2020 20:17:32 GMT

Sometimes when you use large mapping tables, or using mapping tables inside a loop it would be good if the mapping table could be dropped. There is no reason to keep a huge mapping table in memory if is not to be used anymore (i do know mapping tables are dropped at the end of script execution).

So my suggestion is one of the following;

* Enable drop of mapping table with the Drop Table(s) cmd;

* Create a new Drop Mapping Table(s) statement

I initially thought that UnMap could be used to drop mapping tables but that one only works on fields names used for map.. using

Re: Drop Mapping Table - Status changed to: Open - Collecting Feedback

Patric_Nordstrom — Tue, 23 Feb 2021 09:26:46 GMT

Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

Thanks,

Patric

Re: Drop Mapping Table

mdescamps — Tue, 27 Apr 2021 11:57:07 GMT

Definitely a functionality IQVIA is looking for as well !

Re: Drop Mapping Table

AronC — Fri, 11 Jun 2021 22:44:31 GMT

I would like to create a mapping-table within a loop witch would be causing trobble now when I cant drop it. It would have been nice to be able to use mappingtables in loops but would require possibility to drop it.

Re: Drop Mapping Table

AlexOmetis — Mon, 14 Jun 2021 09:36:36 GMT

@AronC - when I need to loop through creating non-concatenated tables (including mapping tables), I put a variable into the map name - e.g. something like:

for vNumber = 0 to 10

Map_$(vNumber):
mapping load x, y resident table;

next vNumber

Re: Drop Mapping Table

christopherkramer — Thu, 24 Nov 2022 07:34:05 GMT

@AlexOmetis that works but is basically a memory leak. Our maps currently have about 4 million rows and we loop 12 times, so we get about 50 million rows in memory and only need 4 of them. We estimate that it wastes something like 60GB of memory during reload. So it strongly limits us how far we can scale, as looping 50 times is just not feasible.

So please: Introduce support to drop mapping tables.

Re: Drop Mapping Table

AlexOmetis — Thu, 24 Nov 2022 09:23:39 GMT

@christopherkramer - yes, we've had the same issue - we ended up reloading the same app multiple times with different loop configuration each time to minimise the number of mapping loads in memory on each run. We found a significant improvement in performance and reduction in memory usage by doing that.

So yes, would be so nice to be able to drop them like you can normal tables.

Re: Drop Mapping Table

MichelLalancette — Thu, 23 Feb 2023 18:36:41 GMT

This is something I've been thinking about recently as my data grows and more business logic is added.

+1 vote from me!

Re: Drop Mapping Table

KL1 — Thu, 02 Mar 2023 06:54:38 GMT

Allowing dropping of Mapping tables makes sense, this gives control to the developer. And mainly minimises substantial memory leaks, a concept not a lot of QS/QV developers understand. I cringe every time I suspect memory leak in qlik programs/code, as managing memory leaks is something etched into my brain coming from C/C++ background. To be frank Qlik is very poor in managing memory leaks, in the middle of execution itself.

Re: Drop Mapping Table

simonaubert — Tue, 06 Jun 2023 05:29:46 GMT

I have exactly this issue today, dropping useless tables is a huge improvement of a script.

Best regards,

Simon

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Mon, 18 Sep 2023 17:12:23 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Drop Mapping Table - Status changed to: Closed - Archived

Ideation — Mon, 18 Sep 2023 17:12:25 GMT