topic Re: Loading data from QVD but Qvw application got hanged in QlikView

Loading data from QVD but Qvw application got hanged

Tue, 29 Aug 2017 13:37:07 GMT

Hi All,

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.

Re: Loading data from QVD but Qvw application got hanged

rwunderlich — Tue, 29 Aug 2017 17:11:18 GMT

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.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com