Since we decided to go with vanilla installations of alle the frameworks we have not added the connection pool feature to OpenJPA, until now.
The results are sadly not that great. Yes, it's faster and it doesn't run out of connections like before, BUT it's still 3, yes, -three- times slower than Hibernate, EclipseLink, iBatis and regular JDBC when persisting entities with many relations. Clearly this is not the kind of results I was hoping for and I'm quite perplexed as to what to do. Shubbis Nitish Kumar wrote: > > Hi subbis, > If I let the iteration loop over 5000, I get that exception, It > seems (I am not sure) openjpa is creating a new connection and after a > while mysql runs out of connection. I tried the same code and iteration > loop with a connection pool and it works fine. That should get you > moving as of now, till someone from Open JPA team looks into the issue. > > Thanks and Regards, > Nitish Kumar > -- View this message in context: http://n2.nabble.com/Slow-performance-with-OpenJPA-when-selecting-from-a-ManyToMany-relation.-tp2466994p2503084.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
