Re: [h2] H2 database on multiple threads/cores
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 the provider that supplies SSD storage. The longer answer is that H2 is composed of multiple layers. The lowest layer is single-threaded, but the layers and caches above that are multi-threaded, and since a lot of queries spend a lot of time processing data, rather than reading/writing to the disk, we actually get a fair amount of parallelism out of our architecture. -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
[h2] Re: patch for h2 issue 368 ON DUPLICATE KEY UPDATE
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: patch for h2 issue 368 ON DUPLICATE KEY UPDATE To: thomas.to...@gmail.com javascript: Hi, I just wanted to let you know of the patch I added to the issue. https://code.google.com/p/h2database/issues/detail?id=368 I followed the recommendation on the project home page and the V3 is working as expected, maybe it is not up to your standards for inclusion. Then you didn't want to include it and it is fine, but I thought I would drop you a line before it gets too hard to merge in case you haven't reviewed it. Best Regards, -- *Jean-François Noël* 1-818-919-9812 -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
[h2] Move database files after shutdown
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 shutting it down? Has anyone succeeded in doing so? - mike -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
Re: [h2] Move database files after shutdown
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 open connection somewhere I close and open my databases all the time from the same JVM and copy them around, so it does work. On 11/11/2013 8:13 AM, Mike Goodwin wrote: 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 shutting it down? Has anyone succeeded in doing so? - mike -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.