Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to improve the perfomance ?

how to improve the perfomance ?

4 Replies
Anonymous
Not applicable
Author

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 - Creator III
Partner - Creator III

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

Anonymous
Not applicable
Author

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