QVD creation

[#1]

....

[#2]

Doesn't it work to do for each qvd:

1) load data
2) export to a qvd file
3) drop the table

I think it could prevent QlikView to do the linking between tables and also reduce the memory footprint of your script.

[john_duffy · Accepted solution]

Hello.

You can delete the QlikView resident table after each QVD is created. Our QVD load process is as follows:

• Load the data from the database to a resident QV table.
• Store the resident table into a QVD.
• Drop the resident table.

There are no tables to link at the end of the application load.

Let me know if this helps,

John.

[#4]

Do you mean to do it in multiple scripts or all in one script?

[john_duffy]

All in one load script.

[#6]

doing it in one single script should be enough

[#7]

Thanks both, i will try that and let you know. Thanks