Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

15 Replies
thnkgreen
Creator
Creator

Raju, have a look at this post:

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

stevedark
Luminary Alumni
Luminary Alumni

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/

Not applicable
Author

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

ngulliver
Partner
Partner

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
Partner
Partner

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

Not applicable
Author

Hi

                could you please tell me what are dashboard functionalaties

saikatghosh
Contributor III
Contributor III

Hi Raju,

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

Regards

Saikat

Not applicable
Author

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

ngulliver
Partner
Partner

Hi, Naresh.

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

Thanks,

Neil