CopyManager(In/out) vs. delete/insert directly
<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 (>1M), may I know which one better please?
<br>
<br>
(1) copyOut (JDBC copyManager)
<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>
</body>
</html>