What is limit of QVD size & how we can optimize the over sized QVD

[#1]

What is limit of QVD size & how we can optimize the over sized QVD

[Anonymous]

Raju, have a look at this post:

http://community.qlik.com/thread/35687

[stevedark]

Hi Raju,

As far as I am aware there is no physical limit on the size of your QVD.  In order to create a QVD though the data first has to be in memory - so the amount of RAM you have is a limiting factor.  Given the excellent compression that QlikView brings though it is generally not an issue.

Recently I was working on a QVD with 180 million rows, and forty odd dimensional columns.

Regarding optimising QVD's, I have written a blog post that covers this very topic: http://bit.ly/YnAMqT

Hope that is of use.

Regards,

Steve

http://www.quickintelligence.co.uk/

[#4]

As per my knowledge there no limit on QVD Size, That is depending on the Server Memory and RAW.

[ngulliver]

Hi, Raju.

If you need any pointers on optimisation, have a look at this blog.

http://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/

Cheers,

Neil

[jaimeaguilar]

According to release notes, if you try load more than 2,147,483,647 unique values into QV, it won't work properly. So it can be a parameter, even if a QVD file could store more records than this, it won't be possible to load them completely in QlikView. Not to mention that 2,147,483,647 is quite a lot of data.

regards

[#7]

Hi

                could you please tell me what are dashboard functionalaties

[saikatghosh]

Hi Raju,

Please note that as per my knowledge there is no limit of qvd. its depends how you optimize the data.

Regards

Saikat

[#9]

No limit size. Big enough that will still fit in your server's memory.

[ngulliver]

Hi, Naresh.

Please create a separate discussion for your question or you are not likely to get the answer you need.

Thanks,

Neil