Hi Thomas, I am waiting for your feedback.
Please revert back. Thanks Nagin On Dec 7, 6:12 pm, Nagin <[email protected]> wrote: > 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.
