On Sep 1, 9:59 pm, "Thomas Mueller" <[EMAIL PROTECTED]> wrote: > Hi, > > > From what I've experienced using batching in h2 isn't useful. > > It doesn't speed up embedded mode, > > Yes. I think the batch mode doesn't help in embedded Java databases. > > > and it is slower than running the > > statements one at a time in server mode. > > True, at the moment there is no optimization for server mode batch > updates in H2. However in the future that could change (even though > there is no plan to implement this at the moment). > > > If I were you I wouldn't do batch updates with h2 because there > > doesn't appear to be any benefit to do so. > > Yes. You could still use it if you use multiple databases. I don't > think batch updates will slow things down a lot. I don't have any > data, but in H2 batch updates are probably 1 or 2 percent slower than > using regular prepared statements.
I tried it a while ago. Batch updates against an h2 server were significantly slower than running the statements one at a time. I was trying to speed up server access and I was surprised that h2 was slower with batching than without batching. I don't know if it's still true. Brish --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. 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 -~----------~----~----~----~------~----~------~--~---
