topic Re: Max Charts in QV in QlikView

Max Charts in QV

Fri, 15 Feb 2013 10:27:03 GMT

Hello.

I've currently deployed a QV10 solution in a QV10 SR2 Publisher (AJAXClient), ~10 million records, and I'm having a trouble with the two biggest sheets.

In one I have 10 charts and 6 straight tables that can be filtered by the values of 5 listboxes and 14 multiboxes. In this sheet, when I have more than 6 or 7 multiboxes with values, it starts to get slow. But I can still manage to filter by all the conditions (listboxes/multiboxes) with a little patience.

But when it comes to the biggest sheet (16 charts, 82 straight tables, 5 listboxes and 17 multiboxes), I can only select / filter ~5 multiboxes and afterwards the solution becomes unresponsive until it crashes...

I currently have 9GBs RAM for this application. I could get 12GBs RAM but I'm afraid that I can't still manage this sheet completely.

Do you think this is too much for QV to handle? Or what amount of memory do you think I'll need?

Thanks in advance

Re: Max Charts in QV

Fri, 15 Feb 2013 13:04:53 GMT

Hi,

The ideal RAM size would be 8* size of the application

Vivek

Re: Max Charts in QV

Fri, 15 Feb 2013 13:46:04 GMT

What do you mean by "size of application"? Cause my .qvw has 230MBs after reloading :s

Re: Max Charts in QV

phaneendra_kunc — Sun, 17 Feb 2013 09:07:42 GMT

Ideally any QVW expands 4 times the original size and there after ~10% per the user.

But that is ideal...Real deal comes in with your expressions vs the #of records in you dataset..

For your case the memory expansion will be arround 1GB. Check by using Taskmanager..

I would suggest track the memory expansion of your QVW while making selections on your biggest sheet..

One suggestion would be Minimize the objects that are not necessary and use calculated conditions.

Phani