- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- « Previous Replies
-
- 1
- 2
- Next Replies »
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Raju, have a look at this post:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
As per my knowledge there no limit on QVD Size, That is depending on the Server Memory and RAW.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
could you please tell me what are dashboard functionalaties
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Raju,
Please note that as per my knowledge there is no limit of qvd. its depends how you optimize the data.
Regards
Saikat
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No limit size. Big enough that will still fit in your server's memory.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, Naresh.
Please create a separate discussion for your question or you are not likely to get the answer you need.
Thanks,
Neil
- « Previous Replies
-
- 1
- 2
- Next Replies »