topic QVD in QlikView

QVD

Thu, 29 Mar 2012 15:37:23 GMT

What is optimize QVD??????

QVD

Thu, 29 Mar 2012 15:39:20 GMT

with example?????

QVD

Thu, 29 Mar 2012 17:09:35 GMT

Whe you load a qvd file without making any transformations to the fields, in the progress window shows (optimized qvd).

That is the fastest load for a qvw.

QVD

Thu, 29 Mar 2012 17:16:28 GMT

See this post By Oleg Troyansky:

http://community.qlik.com/message/185953#185953

Optimized load is much faster and therefore preferable, especially for larger data sets.

Optimized loads are possible if no transformations (calculations) are made during the load, and no (almost) filtering is done in a WHERE clause.

The only acceptable filter is using function Exists:

WHERE Exists(Field)

So for example this load can't be optimized:

Load * From ... WHERE Country = 'US'

but this load can:

Load * From ... WHERE EXISTS(Country)

================================

On the other hand, the only time you want the load not to be optimized, is if you load a Mapping table from a QVD file. In this case, Optimized load doesn't quite work, so you want to make the load non-optimized deliberately.

QVD

Bill_Britt — Thu, 29 Mar 2012 19:21:56 GMT

Also,

Test:

load

Day(date) as Day

from QVD

anything that is not a straight table read will break the optimized QVD.

QVD

Sun, 01 Apr 2012 11:59:10 GMT

Hi,

I reccomend you to read the post by Rob Wunderlich:

http://qlikviewnotes.blogspot.com/2008/05/when-less-data-means-more-ram.html

Re: QVD

ngulliver — Thu, 21 Feb 2013 15:25:56 GMT

Have a look at Steve's blog he has just written re Optimisation

http://bit.ly/YnAMqT

Regards,

Neil