Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to improve the perfomance ?
That is a very open question, to solicit a sensible answer you need to be specific as to what your issue is.
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
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.
............................................
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