Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
kishorj1982
Creator II
Creator II

Table is taking a long reload time from already created QVD

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

2 Replies
NadiaB
Support
Support

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) .

 

Note: if this suggestion helps to resolve the issue or answers your question, it will be appreciated if you select the "Accept as Solution" option.
We encourage you to visit our Knowledge Base https://qliksupport.force.com/QS_CoveoSearch when trying to find a solution related and not limited to: errors, feature requests, product defects. You can also visit our Qlik Help portal https://help.qlik.com/
Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.