topic Re: Resident vs QVD load in QlikView

Resident vs QVD load

raju_salmon — Mon, 20 Jun 2016 03:27:48 GMT

Hi,

I have one QVD where i need to use multiple time.

Performance wise, which option is good? Resident load or can i load QVD at multiple instances?

Thanks.

Re: Resident vs QVD load

vardhancse — Mon, 20 Jun 2016 03:33:21 GMT

Hi,

any reason for using the QVD twice.

If you want to create any calculated fields, Yes we can use resident reload.

Re: Resident vs QVD load

Mon, 20 Jun 2016 04:12:01 GMT

It's better to use Resident load instead of load QVD multiple times

Re: Resident vs QVD load

varshavig12 — Mon, 20 Jun 2016 04:14:23 GMT

Load QVD once and use resident for further calculations.

I think Loading always takes more time than calculation.

Still do you have any specific requirement ?

Re: Resident vs QVD load

Anonymous — Mon, 20 Jun 2016 04:21:06 GMT

calculation wise resident load is good

Re: Resident vs QVD load

raju_salmon — Mon, 20 Jun 2016 04:36:28 GMT

I have scenario where i need to use same QVD multiple time with different filters. This is the requirement, there is no calculations specifically. I do not wanna use SET ANALYSIS here.

Re: Resident vs QVD load

varshavig12 — Mon, 20 Jun 2016 04:56:13 GMT

Then load QVD once,

n then use resident.

Then you can use where clause or something for your filters.

Re: Resident vs QVD load

jonathandienst — Mon, 20 Jun 2016 05:04:22 GMT

I assume that you have multiple date fields to be linked to calendar tables. One option is to load multiple instances of the calendar linked to the respective dates. You can do this by loading from QVD multiple times, or by using a resident load. Either will work and a load from a QVD is not necessarily slower than a resident load.

Or else use a canonical date using a link table. See here for more:

Canonical Date

Re: Resident vs QVD load

PrashantSangle — Mon, 20 Jun 2016 05:37:11 GMT

Hi,

go through below thread

Non Optimized QVD Load vs Resident Load - qlikview

Regards,

Re: Resident vs QVD load

muthukumar77 — Mon, 20 Jun 2016 07:22:35 GMT

Hi,

Performance wise, QVD load is good.

Re: Resident vs QVD load

Anonymous — Mon, 20 Jun 2016 07:30:36 GMT

may be helpful for you?

QVD is much faster then other load because in QVD data is in the compressed format. But the resident load is with in the application and resident load depends on the other table data that is in the resident table or any other qvd may be and if it joins or concatenate to the other table it may cause to increase the load depends on the key it is unique or duplicate. If it is duplicate then data increases and also load time increases.

1. Depends on the data load and condition in the table load if we say about the resident load if there are any conditional loads then time increases.

2. If we use optimized QVD then loading is faster then any other load also compare with the resident tables load.

3. Resident is used for minimum data and minimum rows which is used for mapping the data or mapping loads so data is less there so it loads faster.