Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
Here is a helpful post on performance tunning. Hope it helps.
http://community.qlik.com/thread/18473?start=0&tstart=0
Ash