Re: [h2] H2 database on multiple threads/cores

2013-11-10 Thread Noel Grandin
The short answer is that it's complicated. You're probably better off creating some performance tests for your application and testing them out on the various options. Since the answers will vary depending on how your application uses the DB. For database applications I would recommend you pick

[h2] Re: patch for h2 issue 368 ON DUPLICATE KEY UPDATE

2013-11-10 Thread Cemo Koc
Is it possible to cut a release after this issue fixed? Thanks 9 Kasım 2013 Cumartesi 13:02:52 UTC+2 tarihinde Thomas Mueller yazdı: Forwarding... -- Forwarded message -- From: Jean-Francois Noel jfn...@gmail.com javascript: Date: Sat, Nov 9, 2013 at 2:11 AM Subject:

[h2] Move database files after shutdown

2013-11-10 Thread Mike Goodwin
Hi, I have found I am unable to move the database directory after a shutdown. I have tried waiting, gc(), calling for a shutdown (using the SHUTDOWN sql command). I have made sure there are no more connections open. Is there any expectation that it should be possible to close a database after

Re: [h2] Move database files after shutdown

2013-11-10 Thread Ryan How
The database will close when all connections to it are closed. So you must still have some connections open (Are you using a connection pool??) Also see http://h2database.com/html/grammar.html#set_db_close_delay Is there still the lock file present?. If that is still present then there is an