Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When it is used optimized and non optimized qvd situation?
Hi,
Understood like this-----
optimized qvd-- data fetch from data source and store into qvd without any where clause,conditions is called optimized qvd.in optimized qvd only you use exits function in where clause.
non optimized qvd- data fetch from data source with conditions and calculations then store in to qvd is known as non-optimized qvd.
Regards
Qvd optimization is not about fetching data from database and storing to qvd .
Its about loading data from qvd to RAM.
So when we are loading our application from qvd without any transformation , without any where clause load is optimized
if we do any transformation load is not optimized except exists() function.
Hi,
You should check out the post from a while ago from stevedark
http://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/
It's one of the nicer explanations i have seen of optimised loads.
Regards,
Brian