On 26/01/2012 11:49, Francesco Chicchiriccò wrote:
[...]
At this point I don't know how to proceed further with investigations:
after all it's all test performance :-(
Thanks anyway: I'll let you know if I eventually find something.
This problem seems to be solved now: [1] (my last
On 25/01/2012 18:48, Kevin Sutter wrote:
That is interesting data, Francesco. Since the actual query processing
seems to take less time with H2 (vs MySQL), but the overall time of the
test takes more time with H2 (vs MySQL), my next guess is with Connection
management. Maybe the cost of
Hi,
Did you try the DB_CLOSE_DELAY connection parameter
jdbc:h2:mem:test;DB_CLOSE_DELAY=-1 as mentioned in [1].
I've not tested this myself but this seems to be the preferred option in
such cases.
[1] http://www.h2database.com/html/features.html#in_memory_databases
Regards,
Prashant
On Thu,
On 26/01/2012 13:22, Prashant Bhat wrote:
Hi,
Did you try the DB_CLOSE_DELAY connection parameter
jdbc:h2:mem:test;DB_CLOSE_DELAY=-1 as mentioned in [1].
I've not tested this myself but this seems to be the preferred option in
such cases.
Hi Prashant,
I was already using
On 24/01/2012 15:54, Kevin Sutter wrote:
First of all, Congratulations on your migration from Hibernate to OpenJPA.
I'm glad to hear that things worked out well for you during this effort.
Hi Kevin,
thanks for your answer.
As far as H2 performance... My guess is that the H2 Dictionary may
That is interesting data, Francesco. Since the actual query processing
seems to take less time with H2 (vs MySQL), but the overall time of the
test takes more time with H2 (vs MySQL), my next guess is with Connection
management. Maybe the cost of creating Connections is much more expensive
with
Hi all,
I am currently facing some strange behavior with in-memory H2.
In my project - Syncope Open Source IdM [1] - we recently moved from
Hibernate to OpenJPA: everything is now working and I can safely say
that the porting is functionally complete.
Our source code does some integration tests
First of all, Congratulations on your migration from Hibernate to OpenJPA.
I'm glad to hear that things worked out well for you during this effort.
As far as H2 performance... My guess is that the H2 Dictionary may not
have been kept up to date with improvements to H2 features and SQL