3 Replies Latest reply: Apr 5, 2017 12:50 PM by Wouter Mak RSS

    Nprinting Optimization

    Elie Issa

      Hi Guys,

       

      I have the below Nprinting Log about my nprinting schedule job that has around 600 excel reports(filter) to generate.

      As you can see in the screen below that every single report is taking around 1 minute to be produced.(highlighted in yellow)

      I was running the same schedule from several months and the Report was produced in around 25 seconds.

       

      What should i change from my side to make the Report Producing faster.

       

       

      Nprinting Log.PNG

        • Re: Nprinting Optimization
          Wouter Mak

          I think that the amount of data in your Qlik app is also larger then it was a few months ago. More data will slowdown the speed of creating your reports. You can speed up your reports if you can work with aggregated data instead of all details. For example: Aggregate your data by week

            • Re: Nprinting Optimization
              Elie Issa

              Thanks for your reply but the size of the files is still the same about 450 KB.

              Our report is taking specific dates and specific criteria so the data is not accumulating from month to month.

                • Re: Nprinting Optimization
                  Wouter Mak

                  hi,

                  more important is the amount of data in Qlik. Not your final document. Nprinting must filter throug all the data.

                  Besides Qlik are there many other things. How busy is your Qlik server and your nprinting server.

                  You can creatie a Qlik document with only the data and objects for nprinting. This will speed up your process.