I have to add something. as i said MV_STORE true or false makes no difference i was wrong. setting mv_store to false will solve the speed issue.
so this problem has sth to do changing the db storage engine to mv. (but doesn't matter how often i run this update the speed will not improve in the second run or third run as long autocommit is false). the problem with the test script (see above) and timeout lock issue (which has sth to do with the index) will not occur if you run this script in 1.4. you get this error only if you run this script with 1.3 and change to 1.4 afterwards. -- 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.
