All, I haven't seen any response to this; has nobody else run into optimization issues such as described below? Do others use Hibernate to work with large amounts of data and find it to run relatively quickly? Are there some design principals I should take into consideration for this stuff so I can improve performance when accessing a subset of large relations?
Any and all inisight would be very much appreciated! Thanks, in advance. On Mon, 3 Nov 2003, William R. Lorenz wrote: > 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
