topic Re: application taking more time...... in QlikView

application taking more time......

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

Hi Experts,

Hope all are doing well...!!

My application opening time taking more than 15 mins..

I have many Hide/Show objects, is that effect ???

Like.....

Above image ie not container, those are textboxes, I have given condition, based on selections ClientName, Product..... it appears related objects (charts).

Note: Actually earlier it was container, i don't know what happens all container objects are has gone empty, so i have made like using textboxes using hide and Show objects.

How to optimize, Please can you give suggestions...

I'm fed up this......

Thanks in Advance.....

Re: application taking more time......

MK9885 — Wed, 20 Dec 2017 15:05:05 GMT

There are many things that goes into optimizing the app.

Most important is size of the app, data and size of your ram on server or desktop.

Show/Hide is in a way good to optimize, the object will only load if it satisfies the condition.

Using too many If conditions, instead use Pickmatch or Set Analysis.

Load data from QVD

If possible use expressions in script

Do not create too many objects

Maybe load on top 100 or 1000 values at a time or show current year or latest month data as default.

Re: application taking more time......

rwunderlich — Wed, 20 Dec 2017 16:58:30 GMT

1. Save your app on a blank sheet. Then open and track the time. This will isolate the actual open time -- read from disk and decompression.

2. If it is slow only when opening or moving to the sheet with objects. use the Sheet Properties, Objects view to see which objects are taking a long time. How many objects to you have on the sheet?

Also make sure you have enough RAM for this app. If you are using virtual storage (paging) then it can be very slow.

-Rob