topic How to increase the speed in QlikView https://community.qlik.com/t5/QlikView/How-to-increase-the-speed/m-p/565477#M477370 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have several tables have same primary keys. Such as table one has Name Number, table two has Name Number date, Table Three has Name Date...Something just like that.</P><P>While I run more than 10 tables it seems that QV will combine different PK from tables. But it takes long time to run this step.</P><P>What should I add to the script in order to increase&nbsp; speed to run the tables?</P><P></P><P>Thanks!!</P></BODY></HTML> Mon, 28 Apr 2014 08:31:57 GMT 2014-04-28T08:31:57Z How to increase the speed https://community.qlik.com/t5/QlikView/How-to-increase-the-speed/m-p/565477#M477370 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have several tables have same primary keys. Such as table one has Name Number, table two has Name Number date, Table Three has Name Date...Something just like that.</P><P>While I run more than 10 tables it seems that QV will combine different PK from tables. But it takes long time to run this step.</P><P>What should I add to the script in order to increase&nbsp; speed to run the tables?</P><P></P><P>Thanks!!</P></BODY></HTML> Mon, 28 Apr 2014 08:31:57 GMT https://community.qlik.com/t5/QlikView/How-to-increase-the-speed/m-p/565477#M477370 2014-04-28T08:31:57Z Re: How to increase the speed https://community.qlik.com/t5/QlikView/How-to-increase-the-speed/m-p/565478#M477371 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> I don't know your data model and I don't know how big are the tables, maybe you could concatenate them</P></BODY></HTML> Mon, 28 Apr 2014 08:33:59 GMT https://community.qlik.com/t5/QlikView/How-to-increase-the-speed/m-p/565478#M477371 bbi_mba_76 2014-04-28T08:33:59Z Re: How to increase the speed https://community.qlik.com/t5/QlikView/How-to-increase-the-speed/m-p/565479#M477372 <HTML><HEAD></HEAD><BODY><P>It's difficult to answer without knowing your data model but if there are synthetic keys, it will slow down your loading process.</P></BODY></HTML> Mon, 28 Apr 2014 08:35:00 GMT https://community.qlik.com/t5/QlikView/How-to-increase-the-speed/m-p/565479#M477372 MK_QSL 2014-04-28T08:35:00Z Re: How to increase the speed https://community.qlik.com/t5/QlikView/How-to-increase-the-speed/m-p/565480#M477373 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">How to write the script for the synthetic keys?</SPAN></P></BODY></HTML> Mon, 28 Apr 2014 08:36:40 GMT https://community.qlik.com/t5/QlikView/How-to-increase-the-speed/m-p/565480#M477373 2014-04-28T08:36:40Z Re: How to increase the speed https://community.qlik.com/t5/QlikView/How-to-increase-the-speed/m-p/565481#M477374 <HTML><HEAD></HEAD><BODY><P>Qlik will join the data using fields with the same name, so make sure it's not creating unecessary synthetic keys. You can use aliases to control what should be the key.</P></BODY></HTML> Thu, 20 Apr 2017 16:17:54 GMT https://community.qlik.com/t5/QlikView/How-to-increase-the-speed/m-p/565481#M477374 tomasz_tru 2017-04-20T16:17:54Z