[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1) Optimize Hibernate for the bulk insertion of related entities

[<no...@at...>]

The following comment has been added to this issue:

     Author: Aseel Abbas
    Created: Wed, 22 Jun 2005 9:18 AM
       Body:
We need to insert 10000 objects every 6 seconds.  Hibernate takes over 8.5 seconds to do this.  Using JDBC with batch insert ( java.sql.PreparedStatement.addBatch(),  java.sql.PreparedStatement.excuteBatch()) with 1000 objects per batch, the 10 required transactions happen in under 180ms.  So Hibernate is about 40 times slower than JDBC in this case.  

It would be great if Hibernate had a bulk insert feature.
---------------------------------------------------------------------
View this comment:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-1?page=comments#action_18457

---------------------------------------------------------------------
View the issue:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-1

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HHH-1
    Summary: Optimize Hibernate for the bulk insertion of related entities
       Type: New Feature

     Status: Reopened
   Priority: Minor

 Original Estimate: Unknown
 Time Spent: Unknown
  Remaining: Unknown

    Project: Hibernate3
 Components: 
             core

   Assignee: 
   Reporter: Bradley Leupen

    Created: Fri, 16 Apr 2004 10:57 AM
    Updated: Wed, 22 Jun 2005 9:18 AM
Environment: Hibernate 1.2, MySql 3.1

Description:
It is currently difficult to batch the creation of persistent entities that maintain associations with other entities.

Add necessary api to hibernate to support the save or update of a collection of entities. An optimization can be applied in this scenario to group inserts / updates by entity class, or table. This will enable the hibernate engine to utilize batching if available, drastically improving performance over a network. 


---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira