Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
Anonymous
Not applicable
Author

Raju, have a look at this post:

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

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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

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

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

Hi, Naresh.

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

Thanks,

Neil