[odb-users] Querying on Containers

Boris Kolpackov boris at codesynthesis.com
Fri Oct 7 10:34:48 EDT 2016


Hi Lukas,

Lukas Obermann <obermann.lukas at gmail.com> writes:

> is it still true that querying on containers directly (without a view on
> top) is not possible?

Yes, that's true.


> Asking cause I have a object with ~10 containers and I imagine it not
> very efficient creating a view that basically "unwinds"/"projects" all
> those containers so that a object can be loaded in one query.

If you create such as view, you don't have to load the container columns
as part of it (i.e., you would use the container columns in the JOIN/WHERE
clauses only).

Boris



More information about the odb-users mailing list