mysql5+linux(centos)
PreparedStatement prepared = null;
Connection conn = null;
ResultSet result = null;
try {
conn = DBUtil.getConnection();
conn.setAutoCommit(false);
prepared = conn.prepareStatement(INSERT_TOKEN_SQL);
int size = tokenLst.size();
for(Token t: tokenLst){
Long disciplinedId = t.getDisciplineId() == null? 0L: t.getDisciplineId();
Integer typeId = t.getTypeId() == null? 0:t.getTypeId();
Long participantId = t.getParticipantId() == null? 0:t.getParticipantId();
if(t.getText().length() >= 100){
System.out.println(t.getText());
continue;
}
prepared.setInt(1, storyId);
prepared.setLong(2, disciplinedId);
prepared.setInt(3, typeId);
prepared.setString(4, t.getText());
prepared.setBoolean(5, t.getIsReservedKeyWord());
prepared.setDouble(6, t.getFrequency());
prepared.setString(7, t.getHashCode()+"");
prepared.setBoolean(8, t.isInHeadLine());
prepared.setBoolean(9, t.getIsReservedKeyWord());
prepared.setLong(10, participantId);
prepared.setString(11, t.getStandardName());
prepared.setBoolean(12, t.isTearmParticipant());
prepared.setBoolean(13, t.isHomeOrAway());
prepared.addBatch();
}
prepared.executeBatch();
conn.commit();
} catch (Exception e) {
e.printStackTrace();
} finally {
DBUtil.JDBCUtil(conn, prepared, result);
}
本表有130万记录 ，现在发现批处理插入1万条记录发现需要 3-5秒。
经过观察该表有主键（id,storyId）其中id是系统自动增长。
问如何调节性能， 可以动索引
|
