i tried anything to find a reason for the speed difference between 1.3 and
1.4.
i made two seperate functions for select and update (select will save the 2
values into a map). but no difference the udpate will take still multiple
days with 1.4 instead of a few minutes.
after that i tried to modify the function that the update will
commit immediately after each execute (not a solution here but just for
testing).
while(result.next()){
byte[] alarmDate = result.getBytes("ALARMDATETEMP");
Timestamp alarmDateStamp =
this.convertByteToTimeStamp(alarmDate);
updatePstmt.setTimestamp(1, alarmDateStamp);
updatePstmt.setInt(2, result.getInt("ID"));
updatePstmt.executeUpdate();
}
h2 1.3.176: 5minutes
h2 1.4.190: ~4days
while(result.next()){
byte[] alarmDate = result.getBytes("ALARMDATETEMP");
Timestamp alarmDateStamp =
this.convertByteToTimeStamp(alarmDate);
updatePstmt.setTimestamp(1, alarmDateStamp);
updatePstmt.setInt(2, result.getInt("ID"));
updatePstmt.executeUpdate();
*cnctn.commit();*
}
h2 1.3.176: 9minutes
h2 1.4.190: 10minutes
so no big difference here. so if i set the connection to autocommit=true
the problem is solved.
--
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.
