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 - -- 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.
