Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Currently, I am using extractor as well as transformed level QVD's. Bur for one of the table QVD load time is very high.
Could you please suggest how to avoid this.
Thanks,
Kishor
Hi @kishorj1982
Have you read these articles?
Best Practice: Loading QVD files
Performance Takes Longer Time in preceding load when loading from QVD
QlikView Folder And Files To Exclude From Anti-Virus Scanning
When searching for solutions we recommend to visit our Qlik Support Portal ( https://qliksupport.force.com/QS_CoveoSearch) or our Qlik Help site (https://help.qlik.com) .
Kishor, did Nadia's link get you what you needed? I would expect the issue is you have done something in the Load script from that QVD that is braking the optimized load, which will cause things to be slower. The 'fix' for this is to load the QVD into a temp resident table, then reload the resident table to perform any transforms, and then drop the temp table. Hopefully that makes sense, let us know if you got things sorted, if you did something different, consider posting what you did and use the Accept as Solution button to mark it as the correct solution after you post. If you are still stuck, leave an update for us.
Regards,
Brett