Re: [h2] MVStore with MVCC performance degradation

2015-07-16 Thread Thomas Mueller
Hi, Thanks for the new trace file. The same query is run. It also takes around 3 seconds. 3 seconds is very slow for such a query, so I think this needs to be fixed. In the previous (version 1.3.x / 1.4.x) traces, the same query is run, but run 3 times, and not just once. That's why it takes 10 se

Re: [h2] 1.4 Release Update

2015-07-16 Thread acourtis
Thanks for the update Is there anything we can do to assist? Plenty of java devs here ;) Alex On Thursday, 16 July 2015 16:00:29 UTC+10, Thomas Mueller wrote: > > Hi, > > I'm still working on the MVStore power failure problem, I would like to > fix that first before releasing a new version (

Re: [h2] MVStore with MVCC performance degradation

2015-07-16 Thread Wes Clark
I sent you a trace of the same processes, but this time on H2 1.2, where the metadata queries run so much faster. On Thu, Jul 16, 2015 at 10:17 AM, Wes Clark wrote: > I agree the problem is not related to MVCC or MVStore. We are still > running on version 1.2.147 of H2, and that version does no

Re: [h2] MVStore with MVCC performance degradation

2015-07-16 Thread Wes Clark
I agree the problem is not related to MVCC or MVStore. We are still running on version 1.2.147 of H2, and that version does not exhibit the problem. What is different in that version? Can I send you a trace from that version? This is blocking our move to the latest version of H2. Perhaps

[h2] Mixed Mode with Autoserver Enabled

2015-07-16 Thread Ashish Srivastava
Hi, I am trying to use H2 DB in High availability deployment of our application. I am using mixed mode with auto server=true and all application instances have access to shared file system. So whichever instance gets up and running first and opens database connection, it starts server and othe