Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Forums,
I know that the QlikView compress the data about from 20% - 90%.
But is there any way to know exactly by how much % the data is compresse by QV of given appl?.
Advance Thanks
SD
I donot think that there is a formula!
my own experience is, that it depends on your data.
I had once a datamodel which took about 500 MB RAM.
I only changed the sort of the maintable (order by) and
the filesize was reduced to 300 MB!!!
That behaviour I noticed more than once!
Hi shan,
you could store the same data twice as txt file and as qvd and compare the file size.
- Ralf
Hi Ralf/Rudolf,
Thanks for response and showing the work around.
But, It is my personal question that, Do u don't think that there should be some tool/mechanism to
know the exact % of data compression done by QV. So, that we can give the Proper RAM Sizing.
Thanks
SD
Qlik professional services will help you with server sizing. As we went thru this in the past we used a complex Excel sheet from Qlik to calc memory size. You can also take a look here: http://community.qlik.com/blogs/qlikviewdesignblog/2013/01/28/memory-statistics#comment-8362
sure it would be nice to know the exact Ratio.
I once had to give an estimate for a new server
but as i wrote, the filesize can differ huge
In Memory there is no difference. so it is only
the way QV stores the data. My assumption is
that QV compares each row and stores only
changed values (that's what I changed the sorting).
BUT MY ASSUMPTION
And again to your question: Yes, it would be good,
Operation Needs to know how much space they should
provide!
Maybe with "medium" compression there might be a better
formula?
hi please go through this doc