topic Re: Exploding memory usage AFTER reload in QlikView

Exploding memory usage AFTER reload

Fri, 19 Dec 2014 17:20:22 GMT

Hi,

I have a relatively simple qvw I've been developing. I developed a few applications previously, and haven't encountered this issue before.

I'm using 64-bit, 11.2 SR9 Desktop.

I reload my file, and this successfully completes. After manual reload, Windows Task Manager shows QV memory usage sitting at around 700MB. However, after I click 'Close' on the reload dialog, memory usage climbs to approx 5GB (99% Physical Memory) and just sits there. I have to reset my dev machine.

The internal model is simple, no synthetic keys or circular references, and only consists of a few tables:

In terms of rows (this is the reload dialog after a successful reload before I hit 'close'):

Press 'Close' and boom. Within seconds my system is un-usable.

Anyone else come across this?

Thanks,

Rory.

Re: Exploding memory usage AFTER reload

Gysbert_Wassenaar — Fri, 19 Dec 2014 17:25:31 GMT

Does your document contain any chart objects or table boxes?

Does the same happen if you create a new document using the same load script?

Re: Exploding memory usage AFTER reload

Ricardo_Gerhard — Fri, 19 Dec 2014 18:03:19 GMT

Your problem could be the total of rows in tables. When you open Qlikview, all objects are calculatet and data are accessed. When you have a fact table, it works fine, but in your case, you have multiple facts tables doing your issue.

I recomend the simple test:

- Reduce the total or rows in tables: product, city, cfrooms, headers;

- Put the maximum of data in rqrooms fact table;

Re: Exploding memory usage AFTER reload

rwunderlich — Fri, 19 Dec 2014 19:06:56 GMT

My guess is that you have inadvertently introduced a large synthetic key and are not seeing it because you have to crash the program. Try doing a limited load of 1 row and take a look at the data model.

-Rob

Re: Exploding memory usage AFTER reload

Ricardo_Gerhard — Fri, 19 Dec 2014 19:28:30 GMT

I believe Rob is correct. I didn't read the issue about machine crash.

Re: Exploding memory usage AFTER reload

MarcoWedel — Sat, 20 Dec 2014 01:14:05 GMT

Are there any complex expressions involved in chart objects?

Re: Exploding memory usage AFTER reload

Mon, 12 Jan 2015 14:43:16 GMT

Hi All,

I was being a numpty. Turns out it was a chart issue in my application that was causing the issue when it was refreshing immediately after the closure of the load. Put a calculation condition against the chart and everything was fine.

Thanks for the assistance everyone.

Rory.