Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
Let us assume My QVD reload time is 1 hours now i want reduce that time without using the filter conditions and resident table how we can get it?
What is the format of your reload time.
Regard,
Anand
hi
started at 09:23:15 and ended at 10:29:15 ..
Hi prabhas
When you add any condition in the where statement of qvd it is not optimized anymore so reload is slow. The only solution is to load qvd without conditions (optimized). also can you please kindly write your example that you are writing in your code it help us to fix up this issue.
Hope this helps
Please use optimized load. Refer below link for details.
https://community.qlik.com/thread/46072
thanks,
Rajesh Vaswani
Hi,
Better way is first load the QVD as normal from the data base like reading Raw Data and make QVD. After this do the transformation and other filter selection in the QVD that will reduce the load time also it is more convenient to you to use this QVD. And if the qvd reading raw data from the source data it will take time depends on your data base rows.
Regards,
Anand
Also, you can check. If you do not need all the data. Then read only required rows. Like say if you have transaction data for various Years, you need only current and previous years data. Then you must limit yourself to read only the current and previous years data. This will bring down the load times. However it depends on your context as well.
thanks,
Rajesh Vaswani