On Sun, Jun 11, 2017 at 11:41 AM, Niclas Hedhman <niclas@hedhman.org> 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
|