Why row level locks don't fly? MVCC requires full undo log to be kept in memory - it could be beneficial for short transactions. 150K rows updated it single statement - doesn't look like very short transaction.
On Thursday, September 6, 2012 1:07:23 PM UTC+2, mdenty wrote: > I agree, but MVCC is absolutely needed by my application. > > Le jeudi 6 septembre 2012 12:15:41 UTC+2, Noel Grandin a écrit : >> >> this looks like a performance with the MVCC option. >> >> Just run without MVCC. >> >> On 2012-09-06 09:34, mdenty wrote: >> > UPDATE DOCUMENT SET STATE=4; >> >> -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/HmmrR1HWl1wJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
