topic Re: RE:Perfomance in QlikView https://community.qlik.com/t5/QlikView/RE-Perfomance/m-p/914055#M983646 <HTML><HEAD></HEAD><BODY><P>Reload time is affected by how much data you are loading and how this data is loaded,</P><P>usually:</P><P>(slower) Databases time &gt; Text files &gt; QVD Files (faster)</P><P></P><P>I recommend you using <A href="http://qlikviewcookbook.com/tools/" title="http://qlikviewcookbook.com/tools/">Tools | Qlikview Cookbook</A> "Script Log Analyser" in order to identify which steps of your script are slower</P><P></P><P>Memory comsumption is affected mainly by your data model (Search community for "Data Model") </P><P><SPAN style="font-size: 13.3333330154419px;">I recommend you using </SPAN><A href="http://qlikviewcookbook.com/tools/" style="font-size: 13.3333330154419px;" title="http://qlikviewcookbook.com/tools/">Tools | Qlikview Cookbook</A><SPAN style="font-size: 13.3333330154419px;"> "QV Document Analyzer" which objects are taking more time to render</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">And of couse, thanks <A href="https://community.qlik.com/qlik-users/2286">rwunderlich</A>‌, for sharing so usefull tools<BR /></SPAN></P></BODY></HTML> Thu, 06 Aug 2015 16:00:17 GMT Clever_Anjos 2015-08-06T16:00:17Z RE:Perfomance https://community.qlik.com/t5/QlikView/RE-Perfomance/m-p/914050#M983641 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>what are the sollutions to increase the perfomance of the dashboard,..?</P><P></P><P>can any one help me on this...any procedure to follow?or there are any steps please let me know.</P><P></P><P>Thank you</P><P></P><P>Suresh</P></BODY></HTML> Thu, 06 Aug 2015 14:37:11 GMT https://community.qlik.com/t5/QlikView/RE-Perfomance/m-p/914050#M983641 Chanty4u 2015-08-06T14:37:11Z Re: RE:Perfomance https://community.qlik.com/t5/QlikView/RE-Perfomance/m-p/914051#M983642 <HTML><HEAD></HEAD><BODY><P>First of all, which bottlenecks are you experiencing?</P><OL><LI>Reload time?</LI><LI>Memory comsumption?</LI><LI>CP?</LI><LI>Slow response time in your dashboard?</LI></OL></BODY></HTML> Thu, 06 Aug 2015 14:47:03 GMT https://community.qlik.com/t5/QlikView/RE-Perfomance/m-p/914051#M983642 Clever_Anjos 2015-08-06T14:47:03Z Re: RE:Perfomance https://community.qlik.com/t5/QlikView/RE-Perfomance/m-p/914052#M983643 <HTML><HEAD></HEAD><BODY><P>Some ideas...</P><P></P><P>Make sure your data model is in a star or snowflake schema. </P><P>Minimise use of Data islands</P><P>Avoid Synthetic keys</P><P>Only bring through the fields you are using in the Dashboard.</P><P>Only bring through the data that is relevant to the Dashboard.&nbsp; If they are only interested in Last 2 years data don't bring through historical.</P><P></P><P>Hope this helps</P><P></P><P>Regards</P><P></P><P></P><P>Andy</P></BODY></HTML> Thu, 06 Aug 2015 14:51:53 GMT https://community.qlik.com/t5/QlikView/RE-Perfomance/m-p/914052#M983643 ogster1974 2015-08-06T14:51:53Z Re: RE:Perfomance https://community.qlik.com/t5/QlikView/RE-Perfomance/m-p/914053#M983644 <HTML><HEAD></HEAD><BODY><P>Recommended reading: <A href="https://community.qlik.com/space/2060">Performance</A></P></BODY></HTML> Thu, 06 Aug 2015 14:54:53 GMT https://community.qlik.com/t5/QlikView/RE-Perfomance/m-p/914053#M983644 Clever_Anjos 2015-08-06T14:54:53Z Re: RE:Perfomance https://community.qlik.com/t5/QlikView/RE-Perfomance/m-p/914054#M983645 <HTML><HEAD></HEAD><BODY><P>thank u fr response</P><P></P><P>i want reload time and memory consumption?<A _jive_internal="true" data-avatarid="2758" data-externalid="" data-online="false" data-presence="null" data-userid="21667" data-username="cleveranjos" href="https://community.qlik.com/people/cleveranjos">Clever Anjos</A><SPAN class="icon-status-icon icon-mvp" title="Mvp"></SPAN></P></BODY></HTML> Thu, 06 Aug 2015 15:12:48 GMT https://community.qlik.com/t5/QlikView/RE-Perfomance/m-p/914054#M983645 Chanty4u 2015-08-06T15:12:48Z Re: RE:Perfomance https://community.qlik.com/t5/QlikView/RE-Perfomance/m-p/914055#M983646 <HTML><HEAD></HEAD><BODY><P>Reload time is affected by how much data you are loading and how this data is loaded,</P><P>usually:</P><P>(slower) Databases time &gt; Text files &gt; QVD Files (faster)</P><P></P><P>I recommend you using <A href="http://qlikviewcookbook.com/tools/" title="http://qlikviewcookbook.com/tools/">Tools | Qlikview Cookbook</A> "Script Log Analyser" in order to identify which steps of your script are slower</P><P></P><P>Memory comsumption is affected mainly by your data model (Search community for "Data Model") </P><P><SPAN style="font-size: 13.3333330154419px;">I recommend you using </SPAN><A href="http://qlikviewcookbook.com/tools/" style="font-size: 13.3333330154419px;" title="http://qlikviewcookbook.com/tools/">Tools | Qlikview Cookbook</A><SPAN style="font-size: 13.3333330154419px;"> "QV Document Analyzer" which objects are taking more time to render</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">And of couse, thanks <A href="https://community.qlik.com/qlik-users/2286">rwunderlich</A>‌, for sharing so usefull tools<BR /></SPAN></P></BODY></HTML> Thu, 06 Aug 2015 16:00:17 GMT https://community.qlik.com/t5/QlikView/RE-Perfomance/m-p/914055#M983646 Clever_Anjos 2015-08-06T16:00:17Z Re: RE:Perfomance https://community.qlik.com/t5/QlikView/RE-Perfomance/m-p/914056#M983647 <HTML><HEAD></HEAD><BODY><P>use QVD files,using caliculated fields in script level,finally construct STAR datamodel,using variables,avoid macros,use container object,use set expressions instead of if condition</P></BODY></HTML> Thu, 06 Aug 2015 20:51:57 GMT https://community.qlik.com/t5/QlikView/RE-Perfomance/m-p/914056#M983647 pratap6699 2015-08-06T20:51:57Z