Thread: CopyManager(In/out) vs. delete/insert directly

CopyManager(In/out) vs. delete/insert directly

From
Emi Lu
Date:
<small>Hello, <br /><br /> Two options for data (>1M), may I know which one better please? <br /><br /> (1) copyOut
(JDBCcopyManager) <br />      t1 into a.csv <br />      delete t2 where pk.cols in t1 <br />      copyIn t2 from a.csv
<br/><br /> (2) setautoCommit(false); <br />      delete t2 where pk.cols in t1; <br />      insert t2 select * from
t1;<br /><br /> Thank you <br /> Emi </small><br />