topic Re: How to reduce the Loading time in Access Point dashboard? in QlikView

How to reduce the Loading time in Access Point dashboard?

lawrance — Fri, 13 Jan 2017 22:34:12 GMT

Hi,

Please tell me how to reduce the below Loading time in QMC

(2017-01-13 15:56:07) Information: Loading. LoadTime=00:00:01.0140260

(2017-01-13 15:56:09) Information: Loading. LoadTime=00:00:03.0420780

(2017-01-13 15:56:13) Information: Loading. LoadTime=00:00:07.0981820

(2017-01-13 15:56:21) Information: Loading. LoadTime=00:00:15.2103900

(2017-01-13 15:56:37) Information: Loading. LoadTime=00:00:31.4348060

(2017-01-13 15:57:09) Information: Loading. LoadTime=00:01:03.8836380

(2017-01-13 15:58:10) Information: Loading. LoadTime=00:02:04.7251980

(2017-01-13 15:59:11) Information: Loading. LoadTime=00:03:05.5667580

(2017-01-13 16:00:12) Information: Loading. LoadTime=00:04:06.4083180

(2017-01-13 16:01:13) Information: Loading. LoadTime=00:05:07.2498780

(2017-01-13 16:02:14) Information: Loading. LoadTime=00:06:08.0914380

(2017-01-13 16:03:15) Information: Loading. LoadTime=00:07:08.9329980

(2017-01-13 16:04:15) Information: Loading. LoadTime=00:08:09.7745580

(2017-01-13 16:05:16) Information: Loading. LoadTime=00:09:10.6161180

(2017-01-13 16:06:17) Information: Loading. LoadTime=00:10:11.4576780

Thanks,

Lawrance. a

Re: How to reduce the Loading time in Access Point dashboard?

marcus_sommer — Sat, 14 Jan 2017 13:56:17 GMT

You need to optimize the datamodel within the qvw - disabling compression, removing unneeded fields and granularities, optimizing high cardinality fields: The Importance Of Being Distinct and maybe some further changes on the datamodel.

To get more specific answers you need to provide detailed informations about the application - filesize, number of records, essential parts from script, screenshots from tableviewer ...

- Marcus

Re: How to reduce the Loading time in Access Point dashboard?

lawrance — Sun, 15 Jan 2017 23:26:38 GMT

Hi,

Sorry for late response. The QVW file size is 1.2 GB and total records 50 lakhs in qvd.

Thanks,

Lawrance A

Re: How to reduce the Loading time in Access Point dashboard?

lawrance — Sun, 15 Jan 2017 23:29:32 GMT

Hi Marcus Sommer,

I have a problem when I open and saving it takes more time and when I reload it takes less amount of time.

Open / Saving - 10 minutes

Reload - 3 minutes.

Same thing happens in Access Point after reloading the job in QMC,when I try to open in Access Point it takes 30 minutes.

Thanks,

Lawrance A

Re: How to reduce the Loading time in Access Point dashboard?

amit_saini — Mon, 16 Jan 2017 04:24:01 GMT

Hi Lawrance,

Please try QV Document Analyzer , this might help you to get rid off unwanted stuff within ur application and can help you to improve the performance.

Search Recipes | Qlikview Cookbook

Thanks,

Re: How to reduce the Loading time in Access Point dashboard?

marcus_sommer — Mon, 16 Jan 2017 07:37:26 GMT

I assume that there is a bigger problem within your application because 50 lakhs isn't very much and by this number of records is the file probably not compressed and must be rather wide to result in 1 GB filesize - reasons for the slow opening could be a lot of synthetic keys and/or large link-table structures.

Further you should take a look to your machine resources because a lack of CPU or RAM could slow down an application quite heavily and another point willl be the storage where your applications are stored - this shouldn't be a slow network-storage else some fast hd/ssd-drives.

- Marcus

Re: How to reduce the Loading time in Access Point dashboard?

lawrance — Wed, 25 Jan 2017 11:55:42 GMT

Hi Sommer,

I have checked there is no synthetic key in my script, and also when simply open close it's working fine but when i reload it takes to open 10 minutes.

Thanks,

Lawrance A

Re: How to reduce the Loading time in Access Point dashboard?

marcus_sommer — Wed, 25 Jan 2017 12:16:47 GMT

Take a look on the compression-settings from the application and disable them. After them you could check if there is any section access implemented and if then disable them, too - maybe in a privat copy of the application - it's only for checking the differences with and without section access.

Beside them try to optimize the application itself with my suggestions from above.

- Marcus

Re: How to reduce the Loading time in Access Point dashboard?

lawrance — Wed, 25 Jan 2017 13:59:01 GMT

Hi Sommer,

Thanks, but there is no section access in my application and also i tried to disable compression setting same issue facing and also all qvd 's are optimized state.

Thanks,

Lawrance A

Re: How to reduce the Loading time in Access Point dashboard?

marcus_sommer — Wed, 25 Jan 2017 14:19:41 GMT

Then it seems that it is not possible to solve the case remotely and you will need a local consultancy.

- Marcus

Re: How to reduce the Loading time in Access Point dashboard?

lawrance — Wed, 25 Jan 2017 18:23:35 GMT

Hi Sommer,

Could you please explain how to resolve this problem, if any other solution

Thanks,

Lawrance A

Re: How to reduce the Loading time in Access Point dashboard?

rwunderlich — Wed, 25 Jan 2017 18:56:23 GMT

I recommend you start by taking a look at the Document log to see where is the script the time is spent.

-Rob

Re: How to reduce the Loading time in Access Point dashboard?

lawrance — Wed, 25 Jan 2017 19:53:05 GMT

I checked the Document Log there is no delay. Reload time takes only 5 minutes but distribution takes more time. Please find the attached screenshot for your reference.

Thanks,

Lawrance A

Re: How to reduce the Loading time in Access Point dashboard?

Dhirendra_Kharwar__13373 — Wed, 30 Nov 2022 12:55:14 GMT

My datamodel qvf file size is 3.5 GB and my dashboard loading time is 7 minutes. please help how can I reduce the datamodel loading time.

I used the aggr() with a date range in the set expression it is required.

and also distinct count.

Re: How to reduce the Loading time in Access Point dashboard?

marcus_sommer — Wed, 30 Nov 2022 13:56:53 GMT

There might be no easy way ... else it could mean that a re-design of the application would be needed to develop the application in the direction of a star-scheme (only a single fact-table + n dimension-tables) and avoiding if-loop and aggr() within the UI.

- Marcus