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

[Michael K. (JIRA) <no...@at...>]

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

Michael Kopp commented on HHH-1:
--------------------------------

Should I create a patch on the current 3.2 cvs branch, right?

I do not have messures for it in hibernate, but I do for our code which does this on its own. Meaning our project, has turned of save-update cascades on the critical places and calls save in the correct order.

We had a performance increased by a facter of 10-15  (1000-1500%) depending on the size of the object tree. Its really simple, instead of nearly as much 'BatchInserts' as we had entities (500-600) we came down to about 5 BatchInserts at all times, as this is the number of entity types involved.

I'm not in my office this next week, so i'll do it the week after. I will create the patch and will of course check the effect it has on our application (of course after I removed our custom code).
If it has indeed the desired results I will submit it here.

> 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