I have a requirement that we load the QVD's every x minutes from live data. Live data is going on 8 million records and growing, and since this may take a while, I was thinking of the possibility of loading a QVD with history data (ie, any data from October 2012 going backward) and have another QVD reload only the current month's data.
This should speed things up significantly, right? I have to do a use-case scenario first before suggesting this as an option so I haven't gone as far as just pen & paper, but how would one link the 2 QVD's? They'd have the same result set and columns, would they just link automatically?