We just cut the next release of out product; H2 is one of the supported RDBMSs. I chose to ship with 1.1.117, mainly because of various bugs in the 1.2 series. Actually, as of 132 the bugs appear to be fixed, but we have hundreds of hours of testing with 117, and we are shipping this week, so timing is everything.
Anecdotally, from observing our highly threaded server's usage, the page store is *much* less multi-threaded than the old store; we seem to see a lot more thread contention. Not sure why or wherel we obviously haven't hide time to look into it. We have successfully used a single Connection for multiple queries, with MULTI_THREADED turned on. With 132, I got lousy performance that way, but better performance with MULTI_THREADED off, each thread using its own connection, and MVCC=TRUE (btw, Can we get a 'set MVCC=TRUE' or some such command in SQL?). We pool connections aggressively, so the opening/closing of the connections is not an issue for us. $0.02 worth. Chris On Mon, Mar 22, 2010 at 4:26 PM, Thomas Mueller < [email protected]> wrote: > Hi, > > > Yes, we're opening/closing the database connection a lot. > > H2 closes the database by default if you close the last connection. If > you do that a lot, that's slow in any case (no matter if fsync is > enabled or not). Opening and closing a database is relatively slow. > See > http://www.h2database.com/html/performance.html#database_performance_tuning > - specially "Keep Connections Open or Use a Connection Pool" > > To ensure this is really the problem I suggest to "profile" the test > case if possible: > http://www.h2database.com/html/performance.html#application_profiling > > 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]<h2-database%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- C. Schanck -- 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.
