We have an application with three classes C, P, Q.
C has a collection ps of P, and P has a collection qs of Q.
This way, each C instance is the root of a three level tree.
In some cases, we would like to read several such trees with
the least possible number of SQL statements.
We use non-proxied collections throughout, and besides
queryByCrit.addPrefetchedCollections("ps")
This reduces the number of queries needed to fill
the ps collection fields by using a clever SQL statement
to fetch the data for several ps instances.
But still the qs collection fields are each
filled with a single query.
It would be nice to have something like
queryByCrit.addPrefetchedCollections("ps.qs")
to advice the SQLGenerator to do that trick for
the innner collections, too.
Can something like that be implemented?
Olli
--
Dr. Oliver Matz
ppi Media GmbH
Deliusstra�e 10
D-24114 Kiel
phone +49 (0) 43 1-53 53-422
fax +49 (0) 43 1-53 53-2 22
email mailto:[EMAIL PROTECTED]
web www.ppi.de
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
