topic Re: My optimization of data model. in QlikView https://community.qlik.com/t5/QlikView/My-optimization-of-data-model/m-p/1407778#M426106 <HTML><HEAD></HEAD><BODY><P>If you increase the number of year of your data model (from 1 to 3) the link table could be bigger, it depends on which are the keys inside your link table.</P></BODY></HTML> Fri, 03 Nov 2017 09:37:56 GMT micheledenardi 2017-11-03T09:37:56Z My optimization of data model. https://community.qlik.com/t5/QlikView/My-optimization-of-data-model/m-p/1407776#M426104 <HTML><HEAD></HEAD><BODY><P>Hello dear community!</P><P></P><P>I ask for a question about my data model optimization. </P><P></P><P><SPAN lang="en"><SPAN title="Основная цель оптимизации была - сократить время загрузки данных, а так же добавить новые периоды в таблицу фактов. ">The main goal of optimization was to reduce the time of loading data, as well as add new periods to the fact table.<BR /><BR /></SPAN><SPAN title="В предыдущей модели было использовано множество команд &quot;Join&quot;, для объединения таблиц фактов и планов.">In the previous model, a lot of "Join" commands were used to combine the fact tables and plans. </SPAN><SPAN title="Таким образом при обновлении память сервера была загружена на 90-95% при 160 гигабайт памяти. ">Thus, when upgrading, the server memory was loaded to 90-95% with 160 gigabytes of memory.<BR /><BR /></SPAN><SPAN title="В новой модели я использовал &quot;Concatenate&quot;, что бы факты, планы и другие движения были в одной таблице. ">In the new model, I used "Concatenate", which would have facts, plans and other movements in one table.<BR /><BR /></SPAN><SPAN title="В результате я сократил время обновления с 2 часов до 30 минут и вместо 1 года получил 3. ">As a result, I reduced the update time from 2 hours to 30 minutes and instead of 1 year I received 3.<BR /><BR /></SPAN><SPAN title="Но моя таблица фактов выросла до 150 000 000 строк. ">But my facts table has grown to 150,000,000 lines.<BR /><BR /></SPAN><SPAN title="Вопрос звучит так - я сделал хорошо или плохо?">The question is - did I do right or wrong? </SPAN><SPAN title=":)"><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></SPAN></SPAN></P><P></P><P><SPAN lang="en"><SPAN>The result of working with the model is shown below.</SPAN></SPAN></P><P><IMG alt="Database.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/181980_Database.png" style="height: 378px; width: 620px;" /></P></BODY></HTML> Fri, 03 Nov 2017 09:26:54 GMT https://community.qlik.com/t5/QlikView/My-optimization-of-data-model/m-p/1407776#M426104 antonaks 2017-11-03T09:26:54Z Re: My optimization of data model. https://community.qlik.com/t5/QlikView/My-optimization-of-data-model/m-p/1407777#M426105 <HTML><HEAD></HEAD><BODY><P>it seems pretty good</P><P>another way is ApplyMap check it</P></BODY></HTML> Fri, 03 Nov 2017 09:30:47 GMT https://community.qlik.com/t5/QlikView/My-optimization-of-data-model/m-p/1407777#M426105 Anonymous 2017-11-03T09:30:47Z Re: My optimization of data model. https://community.qlik.com/t5/QlikView/My-optimization-of-data-model/m-p/1407778#M426106 <HTML><HEAD></HEAD><BODY><P>If you increase the number of year of your data model (from 1 to 3) the link table could be bigger, it depends on which are the keys inside your link table.</P></BODY></HTML> Fri, 03 Nov 2017 09:37:56 GMT https://community.qlik.com/t5/QlikView/My-optimization-of-data-model/m-p/1407778#M426106 micheledenardi 2017-11-03T09:37:56Z Re: My optimization of data model. https://community.qlik.com/t5/QlikView/My-optimization-of-data-model/m-p/1407779#M426107 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">The fact is that I refused in this case from the link table. <SPAN>It was used in the previous model.</SPAN> <SPAN>Now I just generate the keys in the fact table.</SPAN></SPAN></P><P><SPAN lang="en"><SPAN><SPAN lang="en"><SPAN><BR /></SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en"><SPAN><SPAN lang="en"><SPAN>The previous model came to me as a legacy from another developer.</SPAN></SPAN></SPAN></SPAN></P></BODY></HTML> Fri, 03 Nov 2017 09:44:14 GMT https://community.qlik.com/t5/QlikView/My-optimization-of-data-model/m-p/1407779#M426107 antonaks 2017-11-03T09:44:14Z