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

[<leg...@at...>]

The following comment has been added to this issue:

     Author: Bradley Leupen
    Created: Wed, 18 Aug 2004 8:18 AM
       Body:
here is the difference between the feature request and hibernate's current batching implementation (dont know about 3.0):

the current hibernate implementation allows batching only when the same sql statement is generated in succession. this is fine for trivial entites but is useless for inserting a large number of related entities with cascade update = true (given relationship pairs A --- B, hibernate issues separate sql insert statements for A and B for every insert, thus breaking the batch). this restriction essentially forces the user to choose between the convenience of the auto-update feature and (roughly) an order of magnitude increase in performance.

the intelligence of the batcher could be greatly increased if its api were extended to support the insert or update of a collection of persistent entities. not only would this solve the auto-update problem but would also allow the efficient insert/update of many disparate entities in one transaction.
---------------------------------------------------------------------
View this comment:
  http://opensource.atlassian.com/projects/hibernate/browse/HBI-29?page=comments#action_14168

---------------------------------------------------------------------
View the issue:
  http://opensource.atlassian.com/projects/hibernate/browse/HBI-29

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

     Status: Closed
   Priority: Minor
 Resolution: CANNOT REPRODUCE

 Original Estimate: Unknown
 Time Spent: Unknown
  Remaining: Unknown

    Project: Hibernate 1.2

   Assignee: 
   Reporter: Bradley Leupen

    Created: Fri, 16 Apr 2004 10:57 AM
    Updated: Wed, 18 Aug 2004 8: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