7 Replies Latest reply: Oct 4, 2010 7:01 PM by bryankoch RSS

    Size limit?

    bryankoch

      Does anyone know how many lines Qlikview can hold in one table?

       

      I have one table up to 16,642,147 lines and I'm kind of impressed. But I know I'll need to tack more onto that.

        • Size limit?
          Miguel Angel Baeyens de Arce

          Hi,

          If you mean how many records can be handled in a QlikView table, and don't affect performance, I'd say it depends on the hardware you are running QlikView. In my experience, 100M+ are loaded fine, actually stored in one or several QVD files.

          Regards.

            • Size limit?
              bryankoch

              So basically, Qlikview will hold as much as your computer can handle? Sweet.

               

              Speaking of one or several files, performance wise, is it better load one big file or to load several smaller files?

                • Size limit?
                  Miguel Angel Baeyens de Arce

                  Hello,

                  If possible I'd prefer to use one big table (big fact table and several dimension tables around it, following the snow flake model when possible), although it will depend on your datamodel. Let's see what the other users say.

                  Regards.

                    • Size limit?
                      John Witherspoon

                       


                      Miguel A. Baeyens wrote:If possible I'd prefer to use one big table (big fact table and several dimension tables around it, following the snow flake model when possible), although it will depend on your datamodel. Let's see what the other users say.


                      That's what I'd say. My applications don't all have an identifiable central table, but I'd consider it the best practice in general. QlikView is usually pretty flexible in what it allows, though. It very firmly disallows any possible loops, though.