Ive tested using excel and it made little difference
The qvd load took under 1 sec (and it was optimised as I loaded everything). But the Excel load took about a minute regardless of approach used. ie if I loaded everything (No qvd) or nothing (100% from qvd)
So excel is not the best to test with. Searching excel to see if a record should be loaded took as long as loading the record
I will test at work tomorrow and record the results. I just thought the database having a selection to be more than (using peek) would take less time than comparing every field line with another table. But I will be interested to see what the results are.