polygene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Niclas Hedhman <nic...@hedhman.org>
Subject Re: JOOQ EntityStore
Date Sun, 11 Jun 2017 05:24:42 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message