4 Replies Latest reply: Jul 22, 2014 12:49 PM by Giuseppe Novello RSS

    server

    shweta singh

      Can you create a server cluster with a QlikView Server SBE license?

        • Re: server
          shweta singh

          one more question

          Which is the main benefit of using the Publisher QVD generation task?

            • Re: server
              shweta singh

              . Which is the main advantage for using Loop & Reduce for data reduction over Section Access?

              • Re: server
                Giuseppe Novello

                A QVD (QlikView Data) file is a file containing a table of data exported from QlikView. QVD is a native QlikView format and can only be written to and read by QlikView. The file format is optimized for speed when reading data from a QlikView script but it is still very compact. Reading data from a QVD file is typically 10-100 times faster than reading from other data sources.

                QVD files can be read in two modes: standard (fast) and optimized (faster). The selected mode is determined automatically by the QlikView script engine. Optimized mode can be utilized only when all loaded fields are read without any transformations (formulas acting upon the fields), though the renaming of fields is allowed. A WHERE clause causing QlikView to unpack the records will also disable the optimized load.

                 

                 

                In summary, is much faster to load data.

              • Re: server
                Giuseppe Novello

                Yes, but not sure why you want to cluster SBE when the number of users are going to be low, Qlikview cluster is a farm that helps each node on resources not a disaster recovery.