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

[Adrian Lisenberg (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1?page=comments#action_25615 ] 

Adrian Lisenberg commented on HHH-1:
------------------------------------

Hi, I'm trying to solve this issue by implementing my own Batcher class. This Batcher, rader than just one PreparedStatement, has a collection of Statements, one for each sql string. Then I have a Comparator that knows the order of the sql strings (this should be based on cascade mappings). So when the flush is made, all the statements are commited in the right order.

Do you think I´m missing something?? It seems to be working on my project...

Thanks
Adrian

> Optimize Hibernate for the bulk insertion of related entities
> -------------------------------------------------------------
>
>          Key: HHH-1
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1
>      Project: Hibernate3
>         Type: New Feature

>   Components: core
>  Environment: Hibernate 1.2, MySql 3.1
>     Reporter: Bradley Leupen
>     Priority: Minor

>
>
> 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. 

-- 
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
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira