5 Replies Latest reply: Nov 13, 2013 8:00 AM by Bill Markham RSS

    Slow distribution of a huge report.

    GINES RUEDA

      Hello all,

       

      I have developed a report with this parameters:

       

      • Fact table 14M rows.
      • Several dimension tables, sum of all rows 7,6M rows, huge dimension 2,8M.

       

      All developed in a star schema.

       

      So the load of the data from the database to the QVD's takes around 10 minutes.

       

      Then the load of the report from that QVD's takes less than 2 min, but the distribution to "all users" in a mounted folder with QlikView publisher takes around 20 min!!

       

      The size of the report once distributed is 217mb.

       

      It is normal this time to distribute a report of this size?

       

      Do you have some recommendation or solution?

       

      Thanks.

       

      Ginés.