2 Replies Latest reply: Dec 6, 2017 7:53 AM by Nataliia Skliar RSS

    QVD-file grows after each rewrite

    Nataliia Skliar

      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;