Regain map table memory

Thu, 19 Apr 2012 10:55:15 GMT

Hello,

I have to apply maptable to 14 columns in a 15 million rows table.

The trouble is that I have to make 14 maptable of 15 millions rows and this uses too much memory.

I tried to divide the job in different jobs, 3 maptables at a time and temproary qvd.

The trouble is that during the script, I cannot regain the memory used by the tables.

Drop xxx does not work for maptables.

The memory used by the maptables is not given back during the scrict, not even at the end of the script, not even when the qvw is closed. I have to quit and relauch qulick view application to get the memory back and do the next part.

Is there a possibility to drop those maptables during a script.

Thank you

topic Regain map table memory in QlikView

Regain map table memory