3 Replies Latest reply: Aug 7, 2013 2:53 AM by Sathish G RSS

    QlikView Performance

      We have a large QV file with 2 billion rows of data (1 year of data)

       

      We observed that QV takes roughly the same time (20-30 seconds) to display 1 year of data vs 1 month of data

       

      If possible, we would appreciate your insights with 2 questions:

       

      -- Q1: It appears that the long running time (20-30 secs) is due to the fact that QV always queries the full data set (1 year) ... even if we only need to display 1 month of data

       

      -- Q2:  Is it possible to force QV to only query 1 month of data ... if we only want to display 1 month of data?

       

      Regards.. Khai Le

      Cell:  919-730-9899

      EMail:  kle@powercosts.com

        • Re: QlikView Performance
          jagan mohan rao appala

          Hi,

           

          Qlikview stores all data into main memory(RAM), so if the file size is less then the calculation would be bit faster, it is better to load only one month data if you don't require the old data.

           

          HOpe this helps you.

           

          Regards,

          Jagan.

            • Re: QlikView Performance

              Hi Jagan,

               

              Thanks for your feedback and suggestion!

               

              Our users would like to use QV to display 1 month to 1 year of data (2 Billion rows of data) using the QV drill-down method.  Originally, we thought that the QV display time is linear with the volume of data to be displayed using the drill-down method:

               

              -- 1-2 sec to display 1 month of data

              -- 6-12 sec to display 6 months of data

              -- 12-24 sec to display 1 year of data

               

              Instead, the QV display time is:

               

              -- 15-20 sec to display 1 month of data

              -- 15-20 sec to display 6 months of data

              -- 15-20 sec to display 1 year of data

               

              It appears that QV always queries the full data set (2 billion rows of data) whether we display 1 month, 6 months, or 12 months of data

               

              What can we do to speed up the QV display time when we only display 1 month of data?

               

              Regards.. Khai Le

              Cell:  919-730-9899

              EMail:  kle@powercosts.com

                • Re: QlikView Performance
                  Sathish G

                  HI Khai Le, For improving the performance, 1) Remove Unwanted fields 2) In expression, use set analysis 3) Avoid IF condition in expression 4) Avoid count function 5) Avoid calculated dimension 6) Use variable in the expression (Example : sum(sales); Instead of sum(sales) in expression, Variable1 = sum(sales) and pass Variable1 in expression 7) remove synthetic keys and circular loop in the QVW Hope this will helpful for you. Regards Sathish