This content has been marked as final. Show 2 replies
I've got a lot of data in a SQL database, to speed up the loading time I decided it would make sense to load the data in chunks. Load some of the data, store it in a qvd file, load more data and the qvd file, then repeat, building up a qvd file with all but the most recent data.
When I have tried this the initial load takes 10-15 mins, this is saved to a qvd file fine. I then load the new data (takes the same sort of time), load the qvd file (loads much quicker), but then the CPU shows as maxing out for over an hour, without the Close button on the script execution process becoming available.
Any ideas as to why the process is not completing as normal when the data has finished loading?