Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

QVD Reload Problem

Dear All,

I am reloading one QVD in my App ...but after optimizing some records the timer on Script Execution process is continue to flow till u will not click on Abort and remaining records in QVD is not optimizing.

This is happening only in the case when i am giving condition in where clause in Script. Without condition the QVD is optimizing Successfully.

But i want to extract the records as per my condition/expectation. I do not know what to do in this case

Kindly help to resolve the same .

Sarfaraz

16 Replies
Highlighted

Re: QVD Reload Problem

You can load the QVD as-is (all of it = optimized), then copy the data you want to keep in a new resident table using the original WHERE clause and finally drop the initial QVD table. Should load faster...

Of course, if this is a big QVD you'll need sufficient RAM.

Highlighted
Not applicable

Re: QVD Reload Problem

Hi,

1st time load data completely without any condition as sometimes queries take more time to respond compare to entire load (i.e Select *) and then take resident load along with where clause. Store this residented data into QVD.

Hope this helps.

BR,

Neha

Highlighted

Re: QVD Reload Problem

When you add any condition in the where statement of qvd it is not optimized anymore so reload is slow. The only solution is to load qvd without conditions (optimized).
Hope this helps

Highlighted
Contributor III
Contributor III

Re: QVD Reload Problem

Dear Peter,

can you write some example here....so it will be good to understand .

Sarfaraz

Highlighted
Contributor III
Contributor III

Re: QVD Reload Problem

Dear All,

Request you to please give any small example if possible.

Sarfaraz

Highlighted

Re: QVD Reload Problem

Of course. But you'll have to fill in the blanks because you didn't post your original script (that would have been better for simply cutting and pasting a possible solution)

RawQVD:

LOAD * FROM [.\MyQVD.QVD] (qvd);    // Optimized LOAD

FilteredQVD:

NOCONCATENATE

LOAD *

RESIDENT RawQVD

WHERE ...;                         // Add your condition(s)

DROP Table RawQVD;

Highlighted
Not applicable

Re: QVD Reload Problem

You can actually use exists and still retain an optimised load, so not quite any condition. So might be able to do the load in this way to resolve

Highlighted
Contributor III
Contributor III

Re: QVD Reload Problem

Dear Joe,

kindly write  any Example if possible as you said !!!!

sarfaraz

Highlighted
Not applicable

Re: QVD Reload Problem

What is the condition you are trying to use? What code are you doing at the moment?