can you display the memory and cpu usage on the machine when it is loading?
Note that even with a WHERE clause, enough memory must be available to hold the entire unfiltered QVD. The complete QVD is read and then the WHERE filtering is applied to the in-memory copy.