Re: Cannot delete if related many issue

sounds like 4D is not using the index/relation, is possibly doing a sequential search. load cache limit of records, unload, load next cache limit repeat. I would still look at circular relations that could be the part of the issue; as I recall 4D changed the way it handles following relations s

Re: Cannot delete if related many issue

> Le 7 juil. 2018 à 17:52, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Arnaud, > a couple of other thoughts > - are any/all of the related tables very large in record count size? this > might be a cache thing... > maybe 4D is 'thrashing' loading indexes etc, then having

Re: Cannot delete if related many issue

Arnaud, a couple of other thoughts - are any/all of the related tables very large in record count size? this might be a cache thing... maybe 4D is 'thrashing' loading indexes etc, then having to throw them away for the next table(s) and then loading them again. -- you might be able to see/te

Re: Cannot delete if related many issue

Arnaud, I don't use deletion control either... however, maybe there is a circular relation* and 4D iterates through this relational circle either a fixed (large) number of times, or after some (large) number of iterations through the circle 4D finally finds that there are no related children rec

Re: Cannot delete if related many issue

Arnaud, I use Delete Related records a fair amount usually without any issues. However, as John suggests, the sorts of records that may be deleted this way are usually limited to linking records, prefs and things like that. It can be frustrating when a record fails to delete for no known reason on

Re: Cannot delete if related many issue

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

Re: Cannot delete if related many issue

> 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 shar

Cannot delete if related many issue

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 Contro