topic Re: Qlikview Application performance very bad in QlikView

Qlikview Application performance very bad

Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

We are using qlikview application which was working fine. Now we have a new customer with huge data. Performance has degraded very badly. Please provide me some suggestions to improve performance when dimension values are increased.

I have checked community posts and did all changes but there is no improvement in performance. Start schema with 10 Dimensions and Fact table.

I did not get much information on how to improve when dimension values are increased. We have 10 dimensions but only 3 dimensions are not working due to huge data.

Each of 3 dimensions is having around '235390' rows and Fact table contains '3187068'.

Please provide your valuable suggestions to improve performance. We are using Ajax UI application.

Regards,

Sai Krishna.

Re: Qlikview Application performance very bad

Tue, 09 Aug 2016 18:35:30 GMT

Hello Sai,

I would start with using rwunderlich's Document Analyzer: Search Recipes | Qlikview Cookbook

It's free, checking qvw file using it is fast and almost always it will suggest some performance improving changes.

Additional resources:

http://www.quickintelligence.co.uk/perfect-your-qlikview-data-model/

Large amount of data (120 million rows) ... anyone got experience?

Performance tuning in QlikView?

Performance Tuning issues | Qlik Community

Recipe for a Memory Statistics analysis

BR,

Kuba

Re: Qlikview Application performance very bad

Wed, 10 Aug 2016 08:21:14 GMT

Thanks Kuba for providing reference, those are really helpful. We have built a application and loading qlikview object through Ajax client. Few objects are loading when accessed from Access Point but from UI it is taking lot of time to load.

Any suggestions on this?

Thank You.

Re: Qlikview Application performance very bad

Wed, 10 Aug 2016 15:49:53 GMT

Maybe it is not the app which is problematic, but the server is just not good enough? Not enough RAM maybe?

Some information here:

QlikView Scalability Overview

Correctly sizing a QlikView Publisher server

QlikView Capacity Benchmark Whitepaper

RAM Calculation QlikView App

Qlikview server sizing

In general:

https://community.qlik.com/search.jspa?q=RAM,%20CPU‌

BR,

Kuba

Re: Qlikview Application performance very bad

Fri, 02 Sep 2016 06:30:57 GMT

I gone through all of them and made some changes. Charts are working fine from "Access Point" but am not able to access from "UI Application", getting time out error.

Can any suggest some tips to improve the performance to load from UI?

Re: Qlikview Application performance very bad

Ronnie_Taborn — Fri, 02 Sep 2016 17:59:48 GMT

How much has the performance decreased? How many users have the issue? What version are you using?

Re: Qlikview Application performance very bad

Jason_Michaelides — Fri, 02 Sep 2016 18:38:08 GMT

On an app with only 3m rows in the fact table you should not be getting bad performance unless something extreme is going on in there. Can you share the app at all? Maybe with scrambled data?

Re: Qlikview Application performance very bad

Mon, 05 Sep 2016 18:02:25 GMT

we are testing with only one user, and it is not loading. We are using QV 11 SR9.

Re: Qlikview Application performance very bad

Mon, 05 Sep 2016 18:13:20 GMT

The issue is not with fact table. As I mentioned other dimensions with less data is loading fine. The 3 dimensions with huge data are not loading.

I am having single chart with variable as dimension. I have drop down to select dimensions. When I select dimension with huge data chart is not loading. The chart with same dimension in loading properly from access point.

am using simple and single expression as SUM(Sales).

Re: Qlikview Application performance very bad

Mon, 05 Sep 2016 18:22:11 GMT

Hi Rambo,

Thanks for sharing link. I increase session timeout, the chart is still not loading after waiting for 10 minutes. I am using simple expressions "SUM(Sales)" of entire data with chart dimension limit set to 6 + Others.

Re: Qlikview Application performance very bad

Jason_Michaelides — Tue, 06 Sep 2016 06:55:34 GMT

‌wwhat is the spec of your server? How much RAM? What CPUs?

Re: Qlikview Application performance very bad

marcus_sommer — Tue, 06 Sep 2016 06:58:30 GMT

Could it be that your fact- and dimension-tables aren't properly associated and you tried to calculate over loosen tables or that there are synthetic keys or even circular loops? Then like Jason mentioned by such few records and simple expressions like sum(Sales) you couldn't get a bad performance with a proper datamodel. Please post a screenshot from your tableviewer and your used script.

- Marcus

Re: Qlikview Application performance very bad

Thu, 08 Sep 2016 08:00:54 GMT

15.3 GB RAM

Intel Xenon 2.50Ghz

2 Cores

Re: Qlikview Application performance very bad

Jason_Michaelides — Thu, 08 Sep 2016 16:26:19 GMT

That's not much RAM at all....

Can you please post a screenshot of your Table Viewer (data model)

Re: Qlikview Application performance very bad

Wed, 21 Sep 2016 12:10:24 GMT

Hi All,

UI team has designed application by integrating qlikview objects into HTML/Ajax.

This particular QVW is loading fine in Access Point. But in application it is not loading, taking lot of time and refreshing to main page.

We have increased RAM to 60 GB with 8 core processor. we are following star schema. Fact table has 60 M rows and ten dimensions in which 3 dimensions have 2.5 M rows and others dimensions between 1000 to 10,000 rows.

Can you please tell me or share any knowledge base to improve performance of QVW loading with Ajax.?

I have seen some post with IIS settings, I have followed those tips as well.

The main page is taking around 15 to 18 seconds to load and other tabs are taking around 7 - 10 seconds to loads. Customer wants real quick.

New to QlikView‌QlikView Forums & Resources‌QlikView App Development‌QlikView Deployment‌QlikView Layout & Visualizations‌QlikView Performance‌