Hi group,

I have a performance issue and really need a solution. I have a database and one of the tables contains about 100000 records which are child records of a parent table. Within my code the parent and child records are connected as following:


The problem is that when I add the child record to the parent object, all already existing child records are loaded from the database by Hibernate (lazy loading). This is the problem of my performance issue. I'm looking for a solution that I can only add the newly created child to the parent without Hibernate is loading the already existing from the database.

Could somebody please help me to solve this problem?

Thanks in advanc,
ErBruijn.

Set lazy=true and use List or IdBag as the collection type. Use lazy initialization so that chilren won't be loaded into memory.
Using IdBag or List is efficient to add new items without hitting database since the Collection.add(...) always return true.

Jason, thanks for the quick anwser. The next question that comes into my mind is why should I ever use <set>? When <bag> is much efficienter?!

erbruijn.

If I recall, set ensures uniqueness of entities, while bag will let you put multiple copies of the same entity in the bag.

Sounds assumable... THANKS FOR YOUR QUICK RESPONSES AND TIME!

No problem! Don't forget to rate :)

You could also try lazy="extra" in HB 3.1beta2.