0
 Followers
1
 Like

Delete Rule Ignore and True Change / Architectural Dashboard warnings

Database
New

Hi,

Here is an abstract from: 

https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Data_Modeling/Entity_Relationships/Delete_Rules

Ignore
Setting the Delete Rule to Ignore allows deleting records of the main Entity keeping the associated records in the related Entity.
The Ignore value does not guarantee referential integrity and, therefore, no database constraint is created. Accordingly, when you change the Delete Rule property from a previous value to Ignore, the corresponding automatic index is deleted (unless you have manually changed any of its properties).


I can see two problems with this behavior:

  1.  Deleting an index can have a serious performance impact, that this is silently done by OutSystems without warning the developer can cause issues only to appear when change is pushed to production.

  2.  Manually changing the automatically created index, will not remove the index, why? If you OutSystems thinks it should be deleted, then why not always?

Maybe it is an idea to show a true change warning that the automatic index is deleted. Also in the Architectural dashboard, a warning could be shown for foreign key attributes that are not indexed.

Regards,

Daniel

Created on 19 Jun
Comments (0)
views
56
Followers
0