7 Replies Latest reply: Nov 12, 2013 7:46 AM by Michael Ionkin RSS

    Ram consumtion on script calculation

    Michael Ionkin

      Hello

       

      unfortunately I have not enough RAM to make a calculation. All optimizations have been done.

       

      The script looks like this

       

      Load

      Key1*100000+Key2 as Masterkey,

      Key1,

      Key2,

      SomeotherData

      From some.qvd (qvd);

       

      Does it make sence to load in slices and then to merge the qvds?

       

      Something like:

      L1:

      Load

      Key1*100000+Key2 as Masterkey,

      Key1,

      Key2,

      SomeotherData

      From some.qvd (qvd) where Key1 < 40000000;

      Save L1 to L1.qvd;

      Drop Table L1;

       

      L2:

      Load

      Key1*100000+Key2 as Masterkey,

      Key1,

      Key2,

      SomeotherData

      From some.qvd (qvd) where Key1 >= 40000000;

      Save L2 to L2.qvd;

      Drop Table L2;

       

      Final:

       

      Load * From L1.qvd;

      Load * From L2.qvd;

       

       

      ------------

      cheers chesterluck