QVD-file grows after each rewrite

Peony — Wed, 06 Dec 2017 10:40:48 GMT

Hi all.

I have problem with qvd file. I have a script with two params. When I set this params changeble value and reload scripr - qvd file becomes bigger. But even when I set this params as constant value - qvd still grows and rows in it becomes more and more. Reload by reload. Tables in sourse is slill the same, with same data.

I have no idea why it is happens.

Example of script:

Load_T_tmp:
load
TIMEPART_ID,
ADDRESS_ID,
CLIENT_ID,
CITY;
sql
SELECT (some fields with "case")FROM some_view($(vStart),$(vEnd));
Join(Load_T_tmp)
LOAD
GOODS_ID,
LINK_GOODS_ID;
SQl
SELECT (some fields with "case") FROM some_table;

ResTab:
load
TIMEPART_ID,
ADDRESS_ID,
CLIENT_ID,
CITY,

GOODS_ID,
LINK_GOODS_ID;

Resident Load_T_tmp;

DROP Table Load_T_tmp;

Period_List:
LOAD Distinct
TIMEPART_ID as [Period_list]
Resident ResTab;

ResTab:
load
TIMEPART_ID,
ADDRESS_ID,
CLIENT_ID,
CITY,

GOODS_ID,
LINK_GOODS_ID;

FROM $(vMyPath)SaveResTab.qvd (qvd)
WHERE NOT EXISTS (Period_list,TIMEPART_ID);
store ResTab into $(vMyPath)SaveResTab.qvd;

drop Table ResTab;
drop Table Period_List;

Re: QVD-file grows after each rewrite

Gysbert_Wassenaar — Wed, 06 Dec 2017 12:02:58 GMT

Could be the lineage info:

Expansion of QVD file size during iterated process

QVD fragmentation

Re: QVD-file grows after each rewrite

Peony — Wed, 06 Dec 2017 12:53:45 GMT

Gysbert, thank you for your advice. I saw this topics and tried to use knowledge about "AllowDataLineage", but got no result

topic Re: QVD-file grows after each rewrite in QlikView

QVD-file grows after each rewrite

Re: QVD-file grows after each rewrite

Re: QVD-file grows after each rewrite