topic Re: Optimized and unoptimized QVD Load Situations? in QlikView

Optimized and unoptimized QVD Load Situations?

Thu, 08 May 2014 08:04:21 GMT

Optimized and unoptimized QVD Load Situations?

Re: Optimized and unoptimized QVD Load Situations?

its_anandrjs — Thu, 08 May 2014 08:11:04 GMT

In your load if you use where exists key word for the table load and make the QVD then then QVD get optimized due to you load it conditionally and make the QVD if not use it will be Optimized QVD.

Refer this documents

http://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/

Re: Optimized .QVD Confusion

Re: Optimized and unoptimized QVD Load Situations?

alexandros17 — Thu, 08 May 2014 08:19:14 GMT

When you load your qvd, if you use Where or if statement

Ex.

Load

...

if(myfield=cond,1,2) as newfield

...

From ...

Where othercondition

You obtain a not optimized qvd (slow)

If you only use Load .... from.... this is optimized and fast

Re: Optimized and unoptimized QVD Load Situations?

its_anandrjs — Thu, 08 May 2014 08:19:21 GMT

Suppose you load a simple table

TableName:

Load * From QVDLocation;

//The above table is optimized load

TableName:

Load *

Month(DateField) as Month,

Year(DateField) as Year

From QVDLocation;

//This is not optimized load

But if you use Store TableName into TableName.qvd;

then use TableName as load statement then QVD will be optimized

Load * From TableName;

Re: Optimized and unoptimized QVD Load Situations?

Thu, 08 May 2014 08:23:47 GMT

thankyou

Re: Optimized and unoptimized QVD Load Situations?

ngulliver — Thu, 08 May 2014 08:26:44 GMT

Hi, Chandramohan.

If you use the search box in the top right corner you will find many answers to your questions. Your question about optimization was asked quite recently by someone else.

Have a look at their answers:

diffrence b/w optimized load and unoptimized load

Cheers,

Neil

Re: Optimized and unoptimized QVD Load Situations?

Thu, 08 May 2014 08:47:22 GMT

go through this link

file:///C:/Users/Administrator/Downloads/QlikView%20Optimization%20Best%20Practices.pdf

Re: Optimized and unoptimized QVD Load Situations?

Thu, 08 May 2014 09:10:06 GMT

Thankyou

Re: Optimized and unoptimized QVD Load Situations?

Thu, 08 May 2014 09:10:58 GMT

hi chandra r u preparing for interview ?

Re: Optimized and unoptimized QVD Load Situations?

Thu, 08 May 2014 09:12:14 GMT

yes.

Re: Optimized and unoptimized QVD Load Situations?

Thu, 08 May 2014 09:13:19 GMT

k r u from Andhra send me ur mail i can send u quest

Re: Optimized and unoptimized QVD Load Situations?

Thu, 08 May 2014 09:15:00 GMT

chandra18v@gmail.com

Re: Optimized and unoptimized QVD Load Situations?

Thu, 08 May 2014 09:21:05 GMT

go through the questions i have sended through mail

Re: Optimized and unoptimized QVD Load Situations?

rajat2392 — Thu, 08 May 2014 10:37:56 GMT

Hi MVR,

Can you please send me also the questions you have. My Id is rajat2392@gmail.com

Thanks

Rajat

Re: Optimized and unoptimized QVD Load Situations?

Thu, 08 May 2014 10:52:02 GMT

k i wil send you tomorrow

Re: Optimized and unoptimized QVD Load Situations?

rajat2392 — Thu, 08 May 2014 10:55:46 GMT

Thank you

Re: Optimized and unoptimized QVD Load Situations?

Thu, 08 May 2014 10:57:18 GMT

r u working or looking for job

Re: Optimized and unoptimized QVD Load Situations?

ngulliver — Thu, 08 May 2014 11:31:52 GMT

Hi, Chandramohan.

If you don't get what you need on this forum, just to let you know there is a really good site available now called http://www.askqv.com/

It is a new site designed to go through only trusted QlikView related blogs to find matches to any of your Qlikview questions.

Cheers,

Neil

Re: Optimized and unoptimized QVD Load Situations?

IAMDV — Thu, 08 May 2014 13:21:01 GMT

All these questions are Interview Questions. I've listed loads of interview questions on my blog without answers and Chandramohan just copied them from my blog. I wish he could have changed the text format but well he didn't!!

Copied from this URL:

http://qlikshare.com/qlikview-interview-qa/

Cheers,

Re: Optimized and unoptimized QVD Load Situations?

Sat, 13 Sep 2014 03:12:49 GMT

hi bro

i am ashok

please send me interview questions

my mail id :itsmeashokpondy@gmail.com