topic Re: how to improve the perfomance ? in QlikView

how to improve the perfomance ?

Sat, 21 Mar 2015 14:55:23 GMT

how to improve the perfomance ?

Re: how to improve the perfomance ?

Anonymous — Sat, 21 Mar 2015 15:04:28 GMT

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

Re: how to improve the perfomance ?

fred_s — Sat, 21 Mar 2015 15:14:53 GMT

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

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

Re: how to improve the perfomance ?

Anonymous — Sun, 22 Mar 2015 14:45:51 GMT

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.

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

Re: how to improve the perfomance ?

Mon, 23 Mar 2015 04:39:39 GMT

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