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?