On Sun, Jun 11, 2017 at 11:41 AM, Niclas Hedhman <[email protected]> wrote: > > Composite get() results in 2 queries, one for properties/assocs and one for the _ASSOCS tables. > > select * > from "POLYGENE"."ENTITIES" > left outer join "POLYGENE"."TestEntity" on "_value_id" = "TestEntity"."_identity" > where "ENTITIES"."_identity" = 'ca22d692-5461-4756-8316-5a214d055aa5' > > select * > from "POLYGENE"."ENTITIES" > join "POLYGENE"."TestEntity_ASSOCS" on "_value_id" = "TestEntity_ASSOCS"."_identity" > where "ENTITIES"."_identity" = 'ca22d692-5461-4756-8316-5a214d055aa5' > > In each of those queries, there is a "join" line per Mixin type, so highly composed
CORRECTION; There is an additional query for the ENTITIES table itself, to obtain the "_value_id". This might also be more cached than currently is, as it is fetched quite often. Cheers -- Niclas Hedhman, Software Developer http://polygene.apache.org - New Energy for Java
