4 Replies Latest reply: Dec 15, 2016 2:15 PM by Rob Wunderlich RSS

    Reload Structure

    Andre Costa

      Good afternoon,

       

      I have a project in which our reload structure is like this:

       

      -everyday a daily qvd is generated.

      -everyday a monthly qvd is generated (with the qvds from all days)

      -everyday a yearly qvd is generated (with the qvds from all months)

       

      Sometimes new fields are added to the DB, which will cause inconsistencies between the qvds (for example if 2016 has field A and 2015 hasn't it will create a new table-1 while reading).

       

      What is the best practice and faster way to update every qvd without having to re-read every single day from the DB?

       

      Thanks in advance.