[hibernate-dev] Configuration to support batching (or sorting) of DELETE statements efficiently

[Vlad Mihalcea]

I created this JIRA issue for this:

https://hibernate.atlassian.net/browse/HHH-10483

Vlad

On Wed, Jan 27, 2016 at 7:02 PM, Vlad Mihalcea <mihalcea.vlad at gmail.com>
wrote:

> Then we can add this task as a feature request and see when we have some
> time to add support for it.
>
> Vlad
>
> On Wed, Jan 27, 2016 at 6:54 PM, Steve Ebersole <steve at hibernate.org>
> wrote:
>
>> Just pesky things like resources ;)
>>
>> On Wed, Jan 27, 2016 at 12:43 AM Vlad Mihalcea <mihalcea.vlad at gmail.com>
>> wrote:
>>
>>> This must be done like insert but in reverse order. With inserts, we need
>>> to add parents first and children after, because of the foreign key
>>> constraints.
>>> For delete, we need to group children first and delete them prior to
>>> deleting parents.
>>>
>>> Is there something that prevents us from implementing this feature?
>>>
>>> Vlad
>>>
>>> On Wed, Jan 27, 2016 at 7:01 AM, Madhusudana Reddy Sunnapu <
>>> smreddy2004 at gmail.com> wrote:
>>>
>>> > Hi,
>>> >
>>> > Hibernate provides simple configuration properties to enable batch
>>> inserts
>>> > and updates using "hibernate.order_inserts" and
>>> "hibernate.order_updates"
>>> > respectively. These setting allow hibernate to sort the insert and
>>> update
>>> > statements and process them in batches efficiently.
>>> >
>>> > But we don't have such a configuration to sort or batch delete
>>> statements
>>> > efficiently. Especially with CascadeType.DELETE we can see that delete
>>> > statements are not batched effectively and could result in extra
>>> network
>>> > calls to the database for deletion.(Refer:
>>> >
>>> >
>>> http://vladmihalcea.com/2015/03/26/how-to-batch-delete-statements-with-hibernate/
>>> > )
>>> >
>>> > So I am thinking wouldn't it be a good feature to have hibernate
>>> support
>>> > similar configuration, say "hibernate.order_deletes", to enable batch
>>> > deletes similar to updates and inserts.
>>> >
>>> > Cheers,
>>> > Madhu.
>>> > _______________________________________________
>>> > hibernate-dev mailing list
>>> > hibernate-dev at lists.jboss.org
>>> > https://lists.jboss.org/mailman/listinfo/hibernate-dev
>>> >
>>> _______________________________________________
>>> hibernate-dev mailing list
>>> hibernate-dev at lists.jboss.org
>>> https://lists.jboss.org/mailman/listinfo/hibernate-dev
>>>
>>
>