Discussion:
CopyManager(In/out) vs. delete/insert directly
Emi Lu
2014-10-16 20:04:37 UTC
Permalink
<html>
<head>

<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<small>Hello,
<br>
<br>
Two options for data (&gt;1M), may I know which one better please?
<br>
<br>
(1) copyOut (JDBC copyManager)
<br>
&nbsp;&nbsp;&nbsp;&nbsp; t1 into a.csv
<br>
&nbsp;&nbsp;&nbsp;&nbsp; delete t2 where pk.cols in t1
<br>
&nbsp;&nbsp;&nbsp;&nbsp; copyIn t2 from a.csv
<br>
<br>
(2) setautoCommit(false);
<br>
&nbsp;&nbsp;&nbsp;&nbsp; delete t2 where pk.cols in t1;
<br>
&nbsp;&nbsp;&nbsp;&nbsp; insert t2 select * from t1;
<br>
<br>
Thank you
<br>
Emi
</small><br>
</body>
</html>

Loading...