users@glassfish.java.net

Persisting a large number of entities - Is Batch Insert Possible?

From: <glassfish_at_javadesktop.org>
Date: Thu, 12 Apr 2007 12:23:30 PDT

Hi,

I'm trying to persist a number of entities (>30k objects~~ 30k inserts into the database) and it takes a long time for insert into the database (More than 3-4 hrs.).

Currently I'm looping through a list of my objects and inserting one by one.

Could somebody tell me how to do it as a set of inserts or bulk insert of some form.


Thanks in advance
Mahesh
[Message sent by forum member 'mahesh31' (mahesh31)]

http://forums.java.net/jive/thread.jspa?messageID=212180