Re: Filtering QV recrods in memory is slower than loading from file
I've just done some quick testing on this and if the QVD is written with the data sorted by the filtering field, I get a big improvement in load times by using an inner join rather than a where clause, so ...
RandNumber FROM [DataSorted.qvd] (qvd); innerjoin load 424372 asRandNumberautogenerate 1;
... gives a better result than ...
RandNumber FROM [DataSorted.qvd] (qvd) where (RandNumber='424372');