When I am loading data from QVD of size 2.81 GB , my application gets hanged (while running the application).
I am using MIN,GROUP BY and WHERE clause in the script.
Than for testing, I commented out the MAX and GROUP BY clause, but still application getting hanged.
What can be a reason please help.
Note: I have to use a where clause in the script to filter out the data.
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.