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

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(a)hibernate.org&gt; wrote: > Just pesky things like resources ;) > > On Wed, Jan 27, 2016 at 12:43 AM Vlad Mihalcea <mihalcea.vlad(a)gmail.com&gt; > 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(a)gmail.com&gt; 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-hi... >> > ) >> > >> > 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(a)lists.jboss.org >> > https://lists.jboss.org/mailman/listinfo/hibernate-dev >> > >> _______________________________________________ >> hibernate-dev mailing list >> hibernate-dev(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/hibernate-dev >> >