Re: Optimized in QVW - Qlik Community

Report Inappropriate Content · ‎2014-08-06

Hello Community,

I'm new to qlikview what is meant by Optimized in qvw? and may i have knowledge on optimized and unoptimized QVD Load Situations?

Request to can anyone help me in this in detail.

Thanks&Regards,

Sattish

israrkhan · ‎2014-08-07

Kindly see these post, you will get fully idea

Hope it helps....

if not clear , Please ask...

sujeetsingh · ‎2014-08-07

Just go through this doc

Report Inappropriate Content · ‎2014-08-07

Hi Sattish,

see with out transformations if u create a qvd is called Optimized qvd ... and when u load data from optimized qvd called optimized load ...

There is a blog written by Steve Dark on this subject: this explains u very good way

jansen28 · ‎2014-08-07

Optimized QVD: When you extract data from data sources and load that directly into QVD without using any filters then that is Optimized QVD.

Resident1:

Load column1, Cloumn2;

sql select * from Table1;

Un-Optimized QVD: Using filters while loading i.e transforming data from its original view.

Resident1:

Load column1, Cloumn2

Where column1 = 'A';

sql select * from Table1;