Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can any body telll me what is optimized QVD and how to do this optimization.
basic things to do for qvd optimization
Hi,
There is no concept of Optimized QVD, the qvd just has data stored in it. There is a concept of Optimized QVD load, it is the one which loads the data in QVD as such without any transformation, filtering etc.
Check this link hope it helps you.
Regards,
Jagan.
Hi,
There is no concept of Optimized QVD, the qvd just has data stored in it. There is a concept of Optimized QVD load, it is the one which loads the data in QVD as such without any transformation, filtering etc.
Check this link hope it helps you.
Regards,
Jagan.
Hi Jagan,
in some cases we use transformations to the fields and we can store as QVds can we make those things as optimized loads can u pls expain with your words.
regrds
Mahesh T
Hi,
After transformation if you store data in QVD, and if you reload this QVD again using
LOAD * FROM MyQVD.qvd
Then it is a Optimized load.
Whatever the data in QVD when you load without any transformation, filtering etc. is called Optimized QVD loading.
For example:
LOAD * FROM MyQVD.qvd;
This data will load very faster, you donot find the difference for smaller number of records.
LOAD *, Year(Date) AS Year
FROM MyQVD.qvd;
This is not an Optimized load since you are transforming the data. Hope this helps you.
Regards,
Jagan.
Hi, Mahesh.
There is a blog written by Steve Dark on this subject:
http://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/
Regards,
Neil
Thank U .I got clarified my doubt.