I find the delay / difference is down to the allocation of memory as QV Loads. If you watch Qv.exe in task manager you can see it grabbing additional memory in chunks,populating with load and then grabbing more memory.
If you are on the same box as sqlserver.exe you may have an additional conflict as sql and QV fight for memory allocation.In QV Server you can pre-allocate the amount of memory given to QV server process and loads are initially fast until you hit this memory limit.
Also QV is additionaly attemtpting to compress and Optimise the data as its loaded into memory something that Studio isnt being tasked with.
This may be why an optimized QVD load is faster than a db Load something that has "concerned" me since starting to use the product as im not a fan of my company implementing the QVD's as a Warehouse and citing performance as one reason.
However I cant get round the fact that Store into QVD and load * from QVD is faster than select from db when both are stored on the same disk hardware (Raid 5 San).
Colin R
