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. Regards, Thomas --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
