Issue Type: Bug Bug
Affects Versions: 3.6.1
Assignee: Unassigned
Components: core
Created: 20/Aug/12 11:51 AM
Description:

The batch processing in hibernate has little effect on the delete sql request

The problem is that the delete sql request are not sorted and therefore the batch processing cannot work at its best performance

It should be possible to specify that we want the delete commands to be sorted.
It would be like what can be done for the insert and update commands (option order_insert and order_update)
A new option should be added order_delete and if this option is activated, the delete order would be sorted.

For your information, we tested the sorting of delete orders by modifying the sortAction() methods of the org.hibernate.engine.ActionQueue as follo :
The overall performance of the deletions was greatly improve

@SuppressWarnings({ "unchecked" })
public void sortActions() {
if ( session.getFactory().getSettings().isOrderUpdatesEnabled() ) { //sort the updates by pk java.util.Collections.sort( updates ); }
if ( session.getFactory().getSettings().isOrderInsertsEnabled() ) { sortInsertActions(); }
java.util.Collections.sort( deletions );
}

Environment: 3.6.1, DB2/ZOS
Project: Hibernate ORM
Priority: Major Major
Reporter: Gueheneuc
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators.
For more information on JIRA, see: http://www.atlassian.com/software/jira