Is it possible to load a QVD to an app and then update that app throughout the day with only current data?
I am currently creating a QVD in the morning -- it covers the last two years through the prior week. I then load the current week's data via an ODBC call and refresh it every few minutes throughout the day. This currently entails also loading the QVD (concatenate load). My question is this: is it possible to load the QVD and keep it loaded in the app so I'm only loading the ODBC data on the scheduler? Some key word or command in the script that keeps that QVD load intact so it doesn't have to be done over and over again with concatenating the ODBC data?
1. In the morning do a full load of the app from QVD
2. Throughout the day load the app using partially reloads.
In the script you can check if it is a full or partially reload by using IsPartialReload() . When false then you load using qvds as a source when True then you use Merge Load only fetching the missing data from your ODBC source.
By this method you will be able to first fill the app with historical data and then just add the new missing data rows throughout the day.
Thanks for the tip - I looked at Merge Load and that seems the way to go, but I don't understand how to implement it. I'm also not sure how to use IsPartialReload()...reading the page you linked it just seems like it's a function that will return True or False -- how does it know if it's partial or not? In my situation, I will be rebuilding the QVD every morning and then just adding to it with a concatenate load throughout the day until about 9 p.m.
