Performance Optimization Summary (vi): pre-loading, aggregated SQL application instance

The principle has been said before, this article is mainly to give an example of application. This example is taken from GIX4 and is more complicated.

Domain Model:

The relationship between domain models is as follows:

The specific relationship of the right model chain has been described in the second article, no longer to repeat.

The focus is on the Red Line box-Live section:

Project: Represents a construction project;

PROJECTPBS: A project contains a lot of PBS;

Pbspropertyvalue: A PBS We can set multiple values for it, each value corresponds to a defined attribute in a pbstype (template), and the range of values can only be selected in an optional value defined in the attribute.

The corresponding UI is as follows: