title: SQL Insert with large dataset
body: <p>When running a query like "insert into table " how do we handle the commit size? I.e. are all records from anotherTable inserted in a single transaction OR is there a way to set a commit size?</p>
  
  <p><s> Thanks very much ~Sri</s>
  <s> PS: I am a first timer here, and this site looks very good! </s></p>