Hi, some more input.
We are using MySQl's INNODB engine. In testing itself, for long running query we face lot of issues with lock wait time out. Again I am not sure of MySQl's future (as it has gone to Oracle now). I am hard core Java developer. so I can understand H2 better than MySQl which is black box for me. But again concurrency with H2(with or with out MVCC and embedded or server mode)?? -Nagin On Dec 11, 8:26 am, Nagin <[email protected]> wrote: > Thanks Andreas and Thomas for valuable feedback. > > We use hibernate for interacting with Database . Jboss use hibernate > as default JPA provider with connection pooling in their EJB > containter. > Qurery we have written in our application are not DB specfic. So that > way our application can work on any DB. > Most of our queries are not long running. > > My only question - can H2 sustain high concurrency (upto 15 > connection)? I can rewrite query so they are not long running. > H2 has around 1.5 times better peformance than MySql or Postgres. > MySql has known to have problem with complex queries with high > concurrency. From blog I read that while Postgres is more scalbale > and robust than MySql , it's performance is less than MySql. > So i was thinking of H2 as it has better performance than both.Only my > worry with H2 is concurrency .How many concurrent connection H2 can > handle? This answer can help me to decide when I can use which DB. For > example, for low user base(upto 300) customer who can not afford > commercial DB , they can go with H2 , and Customer with very high user > base (more than 1000) can go for commercial DB like Oracle or MS Sql > with clustering. I suppose H2 also support clustering. > So , finally what do you suggest? > > thanks again for your reply and feedback. > > Nagin > > On Dec 10, 3:48 pm, Andreas Henningsson > > > > <[email protected]> wrote: > > I think a good DBA can solve most of your problems with the current > > database. > > MySQL is know for quite good performance. > > > First thing I can think of ... > > > In SQL Server you can join like this > > > inner join myTable t with (nolock) on ..... > > > Improves performance a lot when you don't look tables. Investigate if > > MySQL have something > > simular. > > > /Andreas > > > On Fri, Dec 10, 2010 at 11:29 AM, Thomas Mueller > > > <[email protected]> wrote: > > > Hi, > > > > If you have highly concurrent read and write load, then PostgreSQL > > > might be better (than both MySQL and H2). H2 does support MVCC, but > > > not combined with multi-threaded kernel currently (so long running > > > statements are a problem if you use MVCC). If you need very higher > > > performance, and if an embedded Java database works for you, H2 is > > > probably better, but it's hard to say in your case. > > > > I guess the best solution would be to code your application more or > > > less independent of the database, and then try a few. But that might > > > not be easy in the short term, unless you use tools such as Hibernate > > > or EclipseLink. The advantage in the long term is that you are not > > > stuck with one database. Supporting multiple databases might be good > > > for development (for example using H2 for most of the testing, but > > > PostgreSQL for production). > > > > Regards, > > > Thomas > > > > -- > > > 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 > > > athttp://groups.google.com/group/h2-database?hl=en. > > > -- > > Andreas Henningsson > > > "Vanligt sunt förnuft är inte särkilt vanligt." -- Voltaire- Hide quoted > > text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - -- 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.
