Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Iam developed one incremental QVD but it is getting much time to complete in QMC.
QVD file size : 4 GB
each day data is 11000 rows with 240+ columns like we have last 2 years data in table to store in one QVD.
Central Node CPU is 100 GB only whenever running this qvd it is reaching above 95%.
Attached the script for reference , Request to Please suggest how to reload fast the qvd
Tq : Bhaskar
1) Replace the max date check with the file's update date, resulting in one fewer read.
2) Use basic Exists/Not Exists statements (with the field name being identical) to allow for optimized QVD loads. Using two different field names breaks the optimization.
3) Optimize your SQL queries if they aren't already optimized. It looks like you're loading the entire history, where you could be loading only things that have been updated if you have a last-update type field in your table.