Hi Thomas, In last few days I have gone through some blogs and discussion on H2 database. From blogs I gather that H2 is quite fast and reliable database to work on.
Currently we are using MySql in our project. but we have some issue with mysql regarding concurrency and lock wait time out issue. so we are thinking of changing to other database. But before we start using H2 in our project I have questions I would like you , if possible, to provide answer for . Our project requirements are as follows- 1. It is web application, where we use jboss application server, so we have multiple concurrent connection to DB (15-25 connection ) 2.Our queries are quite complex and contains inner joins 3.Have around 150 tables. 4.Few table have Lobs and Clobs data type with length upto 65KB. My few questions regarding H2 is. 1.can H2 support high concurrency aupto 25 connection? 2. does embedded mode support high concurrency? 3.What is best setting in H2 for such concurrency?(is mvcc will be better?) My biggest worry is concurrency without compramising on performance and lock wait time out issues. -- 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.
