Discussion:
[h2] autocommit=false slower than autocommit=true??
Adam McMahon
2018-12-02 04:27:41 UTC
Permalink
Hi,

I have a need to batch together a number of inserts/updates into a single
transaction. I am using autocomit=false to make them a single transaction
and then call commit() at the end. When I do this, the performance drops
significantly (about 10-15 times slower) as opposed to doing each
insert/update individually with autocomit=true. Is this expected behavior?

-Adam
--
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 h2-database+***@googlegroups.com.
To post to this group, send email to h2-***@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
Andrei Tokar
2018-12-03 01:11:31 UTC
Permalink
No, performance suppose to be the same, if not faster, if you batch is not
big. How do you measure it? what is the version you are using, and how url
is look like? Can you produce standalone use case demonstrating slowness.
--
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 h2-database+***@googlegroups.com.
To post to this group, send email to h2-***@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
Loading...