How to Add to a Large Collection? (without loading it all!)

hay7777 · **Joined:** Wed Jul 21, 2004 6:50 pm **Posts:** 27

Hibernate version: 3.0.5

Name and version of the database you are using: Firebird 1.5

Hi,

We have an object that has a lazy-loaded collection which can get up to 6000+ other objects.

I am encountering serious performance problems when I try and add an object to this collection.

We are limited to version 3.0.5 for this release, so can't make use of lazy="extra".

Can anyone share any tips/workarounds on how to do this?

cheers,

David

kgignatyev · **Posted:** Wed Mar 01, 2006 4:55 pm

you could
- try using idbag for the collection;
- use JDBC to insert data in the DB ( make sure there is no parent object in the session cache with session.evict() );

david · **Posted:** Wed Mar 01, 2006 8:35 pm

If you have a bi-directional one-to-many which by-definition is inverse=true then only add the parent to the child and not the collection, eg, many-to-one side only. You could also use a bag for the collection if you have to add it to the collection.