topic pointer or key or memory in QlikView https://community.qlik.com/t5/QlikView/pointer-or-key-or-memory/m-p/1374317#M613175 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i work with&nbsp; logic for delta consolidation, </P><P>2 years of history in a daily load qvd. </P><P>Daily reload for new data, this data can exists new information and changed information.</P><P>consolidate on where no exists the unique key.</P><P></P><P>The logic i use works for more then 30 extractions, so there is nothing wrong.</P><P>My issue is on the reload time / memory.</P><P></P><P>The new source i want to work with&nbsp; is big. </P><P>the unique key contains multiple field and is 69 figures long -&nbsp; 7bit value </P><P>The source shows me 250 M unique distinct records&nbsp; - 28 bit </P><P>The application stops after consolidation from around 150 Mrecords</P><P></P><P>Can any one tel me what server is needed or to i reach n other&nbsp; limit.</P><P>the server has : CPU 8 core 250Ghz&nbsp; / memory 65536MB.</P><P></P><P>Lidia</P></BODY></HTML> Tue, 19 Sep 2017 12:15:27 GMT lidiavonkrond 2017-09-19T12:15:27Z pointer or key or memory https://community.qlik.com/t5/QlikView/pointer-or-key-or-memory/m-p/1374317#M613175 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i work with&nbsp; logic for delta consolidation, </P><P>2 years of history in a daily load qvd. </P><P>Daily reload for new data, this data can exists new information and changed information.</P><P>consolidate on where no exists the unique key.</P><P></P><P>The logic i use works for more then 30 extractions, so there is nothing wrong.</P><P>My issue is on the reload time / memory.</P><P></P><P>The new source i want to work with&nbsp; is big. </P><P>the unique key contains multiple field and is 69 figures long -&nbsp; 7bit value </P><P>The source shows me 250 M unique distinct records&nbsp; - 28 bit </P><P>The application stops after consolidation from around 150 Mrecords</P><P></P><P>Can any one tel me what server is needed or to i reach n other&nbsp; limit.</P><P>the server has : CPU 8 core 250Ghz&nbsp; / memory 65536MB.</P><P></P><P>Lidia</P></BODY></HTML> Tue, 19 Sep 2017 12:15:27 GMT https://community.qlik.com/t5/QlikView/pointer-or-key-or-memory/m-p/1374317#M613175 lidiavonkrond 2017-09-19T12:15:27Z