Hello,

I've got a BIG problem :-)

I need to export 10,000-100'000 objects into my database.
I use Hibernate everywhere in my application and I would like to keep using it.
DB is SQL Server 2000 with nvarchar...

I do something like that :

for (Iterator iter ...... ) {
MyObject obj = new MyObject();
obj.setXXX(.....)
...
hibernate.save(obj);
if (count++ % 20 = 0) {
hibernate.flush();
hibernate.clear();
}
}

I've also tried to clear and flush.. only at the end..

Well... to insert 15'000 articles, it takes 2 minutes !

When I try this :

PreparedStatement ps = hibernate.connection().createPreparedStatement("INSERT INTO ..... VALUES (?,?,?)");
for (Iterator iter ...... ) {
MyObject obj = new MyObject();
obj.setXXX(.....)
...

ps.set(1, obj.getXXX....);
....
ps.execute();
}


it takes 15-20 seconds....


Is there a way that Hibernate uses its preparedstatement ??

I've tested with transactions....

First see FAQ (last question).
http://hibernate.org/117.html