Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
raju_salmon
Creator II
Creator II

Resident vs QVD load

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.

Labels (1)
10 Replies
Anonymous
Not applicable

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.