topic Re: application performance tuning in QlikView

application performance tuning

sonikajain — Fri, 22 Jun 2012 15:21:42 GMT

Dear all,

Please provide me some ideas on performance tuning of a qlikview application, the general ones as well as the ones specific to the usage of pivot tables.

Your reponses will be of tremendous help to me.

Thanks in advance.

Sonika

Re: application performance tuning

Fri, 22 Jun 2012 16:07:45 GMT

Hi Sonika,

Application performance tuning can be done in few ways.

when specificly you are asking about pivote tables, how many rows of data you have in pivote tables and how long it's going for you to access data from pivote table.

these are critical issue when you are dealing with pivote table, if you are dealing with huge set of data in pivotes it's not advisory to use many dimensions so that when you are pivoting to the last dimension performance will be impacted.

Mean while if you are dealing with data aggregation try to aggregate them in script side instead of doing them on UI/ by eexpressions.

If possible try to apply fiters on pivote selections which helps you to reduce data in tyour table.

Thank you

Meher

Re: application performance tuning

cesaraccardi — Fri, 22 Jun 2012 16:54:09 GMT

Hi,

Other thing that is important and is related to the entire application is the data modeling, avoid synthetic keys and disconnected fields (without relationship between its tables) in the same object.

Cesar.

Re: application performance tuning

regowins — Fri, 22 Jun 2012 17:28:49 GMT

Here is a helpful post on performance tunning. Hope it helps.

http://community.qlik.com/thread/18473?start=0&tstart=0

Ash