My first thought is that MySql is probebably better suited the load you describe.
/Andreas On Fri, Dec 10, 2010 at 9:15 AM, Nagin <[email protected]> wrote: > 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. > > -- Andreas Henningsson "Vanligt sunt förnuft är inte särkilt vanligt." -- Voltaire -- 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.
