Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.