topic Re: Performance issue in QlikView

Performance issue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have fact table which is having almost 200 millions of records and almost 12 dimensions joining with with this table. With tables prepared data model and dash board. It is taking long time to open dashboard and charts.

Is there any way to increase the performance of loading records into dash board.

And also how to increase(taking long time to open) the opening time of charts.

Please share any thoughts on this issue.

Regards,

Kumar

Re: Performance issue

Chanty4u — Thu, 07 Apr 2016 11:49:55 GMT

1.Try to avoid complex expressions in front end.

2)Create a flags in back end and call in front end expressions.

3)which the fileds not required in front end or back end just drop the fileds .

Re: Performance issue

Chanty4u — Thu, 07 Apr 2016 11:50:48 GMT

Meanwhile look into this

Re: QV App performance

Re: Performance tuning in QlikView?

Re: Performance issue

Anonymous — Thu, 07 Apr 2016 11:58:48 GMT

Hi Chanty,

Thanks for responding.

Here I am excluding unused columns and I don't have any long keys. It is simple joins directly with one to one.

My application size is almost 50 gb. Here is the problem

Re: Performance issue

Chanty4u — Thu, 07 Apr 2016 12:01:31 GMT

Try to reduce ur application size..

chk with ur RAM usage and

Re: High memory usage (RAM)

RAM & CPU in the system

Re: Performance issue

Colin-Albert — Thu, 07 Apr 2016 12:05:03 GMT

This post may be a few years old but the information in it is still relevant.

*** 6 Weeks in to QV Development, 30 Million Records QV Document and Help Needed!!! ****

Thanks to swuehl‌ for bringing the post to light!

*** 6 Weeks in to QV Development, 30 Million Records QV Document and Help Needed!!! ****

Re: Performance issue

HirisH_V7 — Thu, 07 Apr 2016 12:10:04 GMT

Thanks for info Colin_Albert‌.

Re: Performance issue

manojkulkarni — Thu, 07 Apr 2016 12:17:16 GMT

You could try to avoid time stamps if not being used. Use only date part of it.

Try to make aggregates for dimensions,if details are not required

Re: Performance issue

engishfaque — Thu, 07 Apr 2016 14:06:38 GMT

Dear Kumar,

First, I would suggest you don't use "Aggr Function" on UI Level.

Second, try to use N-Tier Architecture (i. Extraction Layer, ii. Transformation Layer, iii. Visualization or Presentation Layer).

Please note, 20 million records are not more to degrade your dashboard performance. I think you are doing all of the things on a same QVW and not dropping tables after use.

Kind regards,

Ishfaque Ahmed

Re: Performance issue

Thu, 07 Apr 2016 14:22:28 GMT

Hi Kumar,

Simple things you can do are to avoid showing frequencies in list box and sort based on numerical fields and using keeps instead of joins.

Re: Performance issue

engishfaque — Fri, 08 Apr 2016 14:45:25 GMT

Dear Kumar,

Deep dig to your QlikView App using listed below ways and with attached App,

1st way:

You can check that which object on which sheet is consuming more memory. So, here is the way:

Open your QlikView App > Menu > Settings > Document Properties (Ctrl + Alt + D) > Sheets > Memory (check memory).

2nd way:

Open your QlikView App > Menu > Settings > Document Properties (Ctrl + Alt + D) > General > Memory Statistics (Export your File, you can export that file text format as well) > Open exported file in Notepad (check complete detail).

Analyzing Exported File "Memory Statistics" in QlikView:

Kindly find attached App for analyzing your exported file "Memory Statistics".

Kind regards,

Ishfaque Ahmed