Hi there, I'm having a test environment with the following situation. I'm using the embedded version of H2 database so the engine is embedded and the database is stored on disk as .mv.db file. When doing a insert and a update in one cycle with auto commit on I'm having a performance of about 8000/second. When setting auto commit of and perform the commit my self (so the insert and update are in one transaction) the performance drops to 2000/second. Can anybody explain why this is happening and how to improve this?
Thanks in advance, Arco -- 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.
