tags:

views:

111

answers:

3

Someone please help me in choosing whether to use hibernate or cayenne in the comparison between the two in terms of how they handle large databases. That is which is more suitable to handle large databases.

Thanks

A: 

Bill Dudney -


Overall in my limited expierence Cayenne is a robust and fun framework to develop with. There are lots of cool features and if you know Hibernate its a small leap to grok Cayenne. Cayenne seems to have a vibrant community of users and the list was very friendly and answered my simpleton questions quickly and without trying to make me feel stupid. Cayenne seems to be a bit less mature than Hibernate in a few areas, for example, the distributed caching is new in version 1.1. In general though Cayenne is a great framework and I would definitely recommend that you take a look at it when you start your next project that requires an ORM framework.

Kirtan
Thanks bill. I will check out cayenne to see how it behaves with the large DB.
+1  A: 

I used both, but if I was in charge (and not my boss :) ) I would prefer Cayenne.

Cayenne has a very nice CayenneModeler, so you don't have to write any mapping code - just click your way an entire project in a few minutes.

If you have performance sensitive areas in you project, Cayenne has something called SQLTemplate - a very very efficient solution.

And last but not least, as a newbie or as a simple user, you get very fast very good solutions to your questions - as opposed to the Hibernate forums - just look how many questions are unanswered there.

A. Ionescu
Definitely Cayenne, because of the good Modeler, and also because of the fantastic support: nn the Hibernate forums, many of the newbie questions are not answered, or users are restricted to very few allowed questions.
Adrian A.
A: 

This discussion on relative strengths or Hibernate vs. Toplink offers few important point an which features to look when evaluating:

http://programming.itags.org/development-tools/120839/

Miro A.