Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

QVD

What is optimize QVD??????

6 Replies
Not applicable

QVD

with example?????

Not applicable

QVD

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.

Not applicable

QVD

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.

Employee
Employee

QVD

Also,

Test:

load

     Day(date) as Day

from QVD

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

Not applicable

QVD

Hi,

I reccomend you to read the post by Rob Wunderlich:

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

ngulliver
Valued Contributor III

Re: QVD

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

http://bit.ly/YnAMqT

Regards,

Neil

Community Browser