Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to improve the perfomance ?

how to improve the perfomance ?

4 Replies
bill_markham
Champion III
Champion III

That is a very open question, to solicit a sensible answer you need to be specific as to what your issue is.

fred_s
Partner
Partner

You're right Bill 🙂

You have to provide a bit more information..

1. The first thing to check is the way you have created your keys, the links between tables.

2. Reconsider no. 1

3.

How many records are there?

Show us your data structure (Ctrl-T in Qlikview).

Do you have synthetic keys in your structure?

Perhaps there are too many or too few hubs.

Have a look at

Settings (menu) > Document properties > Tables > Fields (below)

Reconsider fields with big numbers of #Distinct.

Do you really need these fields?

If not, drop them ath the end of your script:

DROP FIELD x;

or DROP FIELDS A, B, C;

Grtz Fred

bestofwest
Creator II
Creator II

Generically:

Simplify Data Model - if possible no Synthetic Keys.


Avoid ODBC. OLEDB has more performance.

Simplify SQL


Tunning SQL.

Reduce data (remove columns unnecessary).

Split Timestamp fields in Data and Time.

Simplify Design Model - Avoid use of images.

Minimize number of Triggers

Test Macro code if used.

Avoid use of peek.

Use Set Analysis.

............................................

Not applicable
Author

1) first we can check any synthtic keys and circulr loop is there .then we can avoid things

join,concatnate,alias after thatIn addition to that, using set analysis and removing unused fields from the application is also would improve the performance of the application.

If i didn’t use any tables means i vl drop the unnecessary tables