topic Re: Qvw file size in QlikView

Qvw file size

Thu, 29 May 2014 15:34:33 GMT

Hi what is normal qvw file size in manufacturing domain projects

give me example fromany manufacturing domain from having 20 to 25 qvds

Re: Qvw file size

Ronnie_Taborn — Thu, 29 May 2014 16:04:07 GMT

The QVW size will vary with your data. It isn't a set size and make sure your server can handle the size of the QVW.

Re: Qvw file size

Ricardo_Gerhard — Thu, 29 May 2014 16:58:48 GMT

The QVW Size is the result about data model and rows.

There isn´t a rule to define what is the qvw size from xx qvds.

Re: Qvw file size

Greg_Williams — Thu, 29 May 2014 17:19:52 GMT

QVW file size depends on numerous factors:

1 - size of data on disk

2 - repeated values

3 - # of objects used in an application (E.g. 20 vs. 100 charts)

4 - types of objects used in the application

...

To provide you with the size of a qvw from qvds, where we do not know the size of the qvds nor the other pertinent information listed above would be erroneous. Side note - often times, customers will tell me I have 100 million records (or list some # of records) but really, this doesn't mean that much to me, instead I want to know the size of the data tables on disk...then I can approximate the potential size of the qvw file (although Qlik's compression algorithm can vary the results).

Hope this helps a bit.

Re: Qvw file size

Ricardo_Gerhard — Thu, 29 May 2014 17:50:38 GMT

Greg, the amount of objects in application there aren´t no relationship with QVW Size.

The type and amount of objects impact in application access time and infrastructure resources as memory and processor.

Re: Qvw file size

Fri, 30 May 2014 07:38:51 GMT

general size will be in MB s or GB s

Re: Qvw file size

Greg_Williams — Fri, 30 May 2014 18:07:13 GMT

Ricardo. I have found increase in file size when images, and numerous text objects, etc. are included with the qvw. You've experienced different behavior? Thanks for keeping me honest/accurate!

Re: Qvw file size

Greg_Williams — Fri, 30 May 2014 18:08:01 GMT

Depends. Generally speaking, smaller data sets...MB...tens of millions+ of records can go into GB range.

Re: Qvw file size

Ricardo_Gerhard — Fri, 30 May 2014 18:24:46 GMT

Off course, sure, no problem.

Images will increase the qvw file size because all images will be included in qvw when it was reloaded.

So, if you have a app with 800MB of data model and 8mb of images, it´s a small increase, 1%.

But, If you have a app with 50MB of data model and 8mb of images, it´s a big increase, more than 10%

Re: Qvw file size

Sat, 31 May 2014 09:59:07 GMT

Thank you for answers >can any body let me know suppose for a project of 300 to 400 Mb qvds are 25 are used.Then approximately how much qvw file size will be there>i am expecting number approximately.

Re: Qvw file size

Sat, 31 May 2014 10:36:19 GMT

Hi Venu

let me take your qvd size as 400MB then your qvw size should be 9.76 GB

qlikviewqvw size = 400*25*8

=80000MB/1024MB

= 78.152 GB

78.152 GB size will loaded in to RAM

Re: Qvw file size

Ricardo_Gerhard — Mon, 02 Jun 2014 12:58:48 GMT

So John, the multiple of 8 is not a rule. There a lot of variables as data model, rows, coluns.

I always recommend to make this formula:

qvw file size * total of simultaneous users * multipilicator factor (8 to 10).

If you have a total of users only, estimated 10% or 20% as simultaneous.

Re: Qvw file size

Mon, 09 Jun 2014 09:24:02 GMT

I Completly agree with you Ricardo Gerhard