GBASE的插入和更新操作为什么很慢? 从实验的情况来看,每次的更新操作差不多需要1s左右
startTime: 1492066834371
耗时: 918
endTime: 1492066837620
[code class="lang-java" lang="java"]String updateDataSQLStr = \"update test_product set predict=\" + predictRlt + \" where barcode='\" + barcode + \"' and channel=\" + channel + \" and CreateTime='\" + createTime + \"'\n\";
try {
long startTime = System.currentTimeMillis();
mStatement.executeUpdate(updateDataSQLStr);
long endTime = System.currentTimeMillis();
System.out.println(\"耗时: \" + (endTime - startTime));
} catch (SQLException e) {
e.printStackTrace();
}
[/code]
收起