i tried an upgrade to 1.4 yesterday and had several problems.
one of them is the speed. i have an update function which convert a column
of ~3.000.000 rows. it took about 6 minutes to convert them with 1.3.176.
with 1.4 after 14 hours 750.000 rows are converted (mv_store true or false
makes no difference).
the function is really easy (id is primary key, alarmdate has an index):
try(PreparedStatement selectPstmt = cnctn.prepareStatement("SELECT ID,
ALARMDATETEMP FROM ALARM_HISTORY;");){
ResultSet result = selectPstmt.executeQuery();
while(result.next()){
byte[] alarmDate = result.getBytes("ALARMDATETEMP");
Timestamp alarmDateStamp =
this.convertByteToTimeStamp(alarmDate);
try(PreparedStatement updatePstmt =
cnctn.prepareStatement("UPDATE ALARM_HISTORY SET ALARMDATE=? WHERE ID=?;")){
updatePstmt.setTimestamp(1, alarmDateStamp);
updatePstmt.setInt(2, result.getInt("ID"));
updatePstmt.executeUpdate();
}
}
}.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
