2 Replies Latest reply: Jun 21, 2013 4:02 PM by Tim Benoit RSS

    Succeeding Load Technique -- using extra memory?

    Tim Benoit

      Does anyone know if the succeeding load technique in loadscript can sometimes use up more memory?  I've got a loadscript where part of it looks like this:

          Left join load field1, field2, ...field20;

          SQL Select field1, field2, ...field20

          from bigtable where clause;

       

      It's working with a lot of data - several million rows and it's using up a lot of memory during loading. I don't know whether the memory consumption is driven primarily by the left-join-load operation or the succeeding load technique (which may be storing all of the data from the sql query before doing the load operation).