Retrieval of Generalisation Entity shouldnt retrieve properties from Specializations to optimize performance - Mendix Forum

Retrieval of Generalisation Entity shouldnt retrieve properties from Specializations to optimize performance

10

As layed out in this question as well, Mendix unnecessarily retrieves all attributes and associations of specializations from the database when only a retrieve of the Generalization is modeled. See below example, the single retrieve causes SQL queries to every specialization table, while this is not needed.

 

Screenshot 2025-03-05 162430.png

 

 

The only benefit is that the activity 'Cast to specialization' can be done without any database interaction, but now a lot of extra (unrequested) effort is done for 'just' the retrieval of the generalization, which is in my opinion an overkill.

For performance reasons, I would rather see that Mendix:

I know this is also done for association tables, but these belong logically to the owning object which you retrieve up until that level of specialization.

BTW: The example above would explode in number of queries if every specialization also has multiple associations.

asked
0 answers