Processing large Data inserts


  • Hi,

    I have a system that contains a very large amount of data around 200 Million rows and regally we need to add more data to this an extra 10 Million rows at a time is typical, now this works find but the overhead of this process takes it's toll on the server as a whole so I was wondering if any one know if batch processing the insert would help.

    I would be interested to know if this would reduce the demand on the server at any one time and therefor allowing other processes to run quicker

    and what effect if any this would have on the overall time that the process takes.

    any one get any ideas ?

    Regards Dagz

    Thursday, September 12, 2013 11:01 AM