All, I've recently taken to exploring Hibernate <http://www.hibernate.org/> for use in Object Relational Mapping, and it seems overall to be quite the excellent package. I understand that the Apache Foundation also offers their OJB packages that will help to accomplish a similar end result, and I'm sure there's others that people might suggest (comments welcome!).
This stuff is all good, and I've found that ORM tools do in fact help to decrease development time requirements; however, I've noticed that in using these tools, there seems to be quite a bit more overhead involved in accessing databased information. Hibernate itself doesn't support raw INNER JOINS for example, and this requires that all object relations are defined in the Hibernate object mapping configurations. Additionally, I'm finding that if I have an Object containing child objects within a Set (think one-to-many mappings), and if I want to retrieve just a subset of those children based on query criteria, the parent Object must still be populated with all its children if it is to be loaded, accessed, modified, and later saved again as a persistent Object (this might be needed if more children are added to the Set, for example). This of course creates quite the burden on resources when working with somewhat larger databases. One could of course throw more hardware at the problem to improve application performance, but I don't find this to be an acceptable solution for robust applications. And so, I'd like to ask if others have encountered this same plight and found a method to improve performance? Do people just not use ORM for database-intensive Java applications? Any and all suggestions are welcome; I'm eager to learn what I can. Thanks, in advance, for any thoughts on this. -- _ __ __ ___ _| | William R. Lorenz <[EMAIL PROTECTED]> \ V V / '_| | http://www.clevelandlug.net/ ; "Every revolution was \./\./|_| |_| first a thought in one man's mind." - Ralph Waldo Emerson ------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: http://sourceforge.net/donate/ _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
