Arnaud de Montard: Since 4D v2.0.10 I have not used it (probably not in 4D way back then). When we used to permit actual deletions but we handled all record deletions in our code especially for related records that also needed to go. Now we do not permit actual deletions - we just flag records as deleted.
Therefore I cannot comment on the feature other than what is in the manual. Jody > On Jul 7, 2018, at 5:20 AM, Arnaud de Montard via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > >> Le 5 juil. 2018 à 13:12, Arnaud de Montard via 4D_Tech >> <4d_tech@lists.4d.com> a écrit : >> >> I have a database in which Deletion Control is set as in the object for a >> lot of relations. Today, deleting 10 records in a table having ~2 billion >> records took an incredible time, cache as shark teeth, unable to connect and >> so on. Finally we had to kill the server. After setting Deletion Control to >> "none", DELETE SELECTION becomes instantaneous. The deleted records had no >> "sons". Searching if there are sons with QUERY(sons;foreign key=primary key) >> takes a few milliseconds. MSC says everything's OK. 4D v14r5. >> >> Does someone have noticed issues with Deletion Control as "Cannot delete if >> related many"? > > No answer… > No one uses deletion control? > > -- > Arnaud de Montard ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
