Hibernate version: version 3.0.3

Code between sessionFactory.openSession() and session.close():

All the program is doing is to trans.beginTransaction(), session.save(), session.flush() then trans.commit(), this is the whole cycle when inserting 1 record at a time.

Name and version of the database you are using:

PostgreSQL 7.4.1

IBM DB2 6.0

Server Not clustered.

The problem is it's taking time to insert all the 20,000 records , it took us 55 hours (more than 2 days) to load it in PostgreSQL.

For DB2, it took 15 hours just to insert the 10,000 records ..

Do you think it has to do with the ID Generator "increment" that we used for all the 5 tables that we have?

It took your software 2 days to insert 20k records? Did you try to write them with magnets on the platters by hand? :) Seriously, your problem is not the primary key generator.

Thanks for the reply.

Another question to anyone who has tried this setup..

What is the normal benchmark time of inserting records using Hibernate 3.0.3 and PostgreSQL and DB2? Let's say 1000 records / ?? minutes

Thanks again..

Did you try and copy the mass insert example from the reference documentation?

Have you tried clearing your session from time to time? Take a look around for batch processing discussion. (I can't remember if it's in the reference doc or not).

Normal time must be less than 1 sec for 1000 records on loptop.