Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Tanalex
Creator II
Creator II

Tips For Identifying Issues In a Data Model?

I have inherited someone else's application.  Large amounts of data and a less than optimal data model.  Any tips for more quickly spotting issues to address to speed up a load, currently 25+min?  Eg. While I know their definition, would looking at INFORMATION DENSITY and/or SUBSET RATIO reveal a good opportunity for improvement?  What other things do you look at to troubleshoot? Rewriting the app/model is not an option at this point.

So what guiding principles does the community use in situations such as this?  Thanks in advance for any and all constructive comments, suggestions, links, etc.

1 Solution

Accepted Solutions
Siva_Sankar
Master II
Master II

6 Replies
maxgro
MVP
MVP

you can start with log analyzer (thanks to rwunderlich‌)

to identify the statement where the script is taking more time

Qlikview log analyser

cheburashka
Creator III
Creator III

Hello,

Did you check/validate the links between the tables? If you want to do some tests on the keys.

Maybe you'll find the QvM - Key Check‌ useful. I created it to easily to validate my data model links.

Have fun Qlik'n, Koen

QlikViewModules.com

RSvebeck
Specialist
Specialist

Check if all qvd's are qvd-optimized when loading. if they are not, make them optimized if possible by removing where clauses and push the where clause to resident loads instead. And always load the biggest tables first.

Svebeck Consulting AB
Siva_Sankar
Master II
Master II

Hi Michael,

Check this document How Debugging works in QlikView Script Debugger

Siva

Tanalex
Creator II
Creator II
Author

Thanks to all.  Some great resources to dig into and educate myself more.  An amazing community!

I was able to, painstakingly, find two LOADs of the same 19 million row table that was never used in the application.  That alone cut the load time from 25+ minutes to 10 minutes.

Siva_Sankar
Master II
Master II

Great to hear that you find it useful. Please mark it as correct answer or

helpful and close this discussion. It will help others.

-Siva

On 29 May 2017 10:43 pm, "Michael Armentrout" <qcwebmaster@qlikview.com>