topic Re: how to improve qv loading speed in QlikView https://community.qlik.com/t5/QlikView/how-to-improve-qv-loading-speed/m-p/1209089#M388125 <HTML><HEAD></HEAD><BODY><P>I think I would put the nightly full-load into a qvw and load them binary into another qvw and then concatenate to them the daily data from qvd's.</P><P></P><P>Beside this I suggest to ensure that really all included fields are needed (take a look to the <A href="https://community.qlik.com/message/1083560">Document Analyzer V3.0 Update Available</A> from Rob) and if there are possibilities to reduce the cardinailty from some fields: <A href="https://community.qlik.com/qlik-blogpost/3632">The Importance Of Being Distinct</A>.</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 10 Oct 2016 06:54:09 GMT marcus_sommer 2016-10-10T06:54:09Z how to improve qv loading speed https://community.qlik.com/t5/QlikView/how-to-improve-qv-loading-speed/m-p/1209088#M388124 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I have qvw which loading 2 types of load&nbsp; 1.Daily&nbsp; 2. Nightly -&gt;&nbsp; Nightly is full reload , and daily is current data reload while reloading daily we are concatenating history records which are big size approx 230,078,097 nos (Reload frequency is 10 mins)&nbsp;&nbsp; So I want to avoid loading such a big record sets again and again I want this records should load once' in qvw and remain as it is and current data can be concatenated with this records</P><P></P><P>Any thoughts , Idea's Please share .</P><P></P><P>Thanks in adv</P><P></P><P>Vikas</P></BODY></HTML> Mon, 10 Oct 2016 06:18:03 GMT https://community.qlik.com/t5/QlikView/how-to-improve-qv-loading-speed/m-p/1209088#M388124 vikasmahajan 2016-10-10T06:18:03Z Re: how to improve qv loading speed https://community.qlik.com/t5/QlikView/how-to-improve-qv-loading-speed/m-p/1209089#M388125 <HTML><HEAD></HEAD><BODY><P>I think I would put the nightly full-load into a qvw and load them binary into another qvw and then concatenate to them the daily data from qvd's.</P><P></P><P>Beside this I suggest to ensure that really all included fields are needed (take a look to the <A href="https://community.qlik.com/message/1083560">Document Analyzer V3.0 Update Available</A> from Rob) and if there are possibilities to reduce the cardinailty from some fields: <A href="https://community.qlik.com/qlik-blogpost/3632">The Importance Of Being Distinct</A>.</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 10 Oct 2016 06:54:09 GMT https://community.qlik.com/t5/QlikView/how-to-improve-qv-loading-speed/m-p/1209089#M388125 marcus_sommer 2016-10-10T06:54:09Z