Olli --
I have a similar requirement that I'm satisfying via QueryCustomizers. The problem is
that my customizer isn't being applied when the P collection is loaded. I submitted
some updates to the developer mailing list back on July 9 (Patch for prefetched
relationships) but have heard nothing in response.
Ron Gallagher
Atlanta, GA
[EMAIL PROTECTED]
>
> From: [EMAIL PROTECTED]
> Date: 2003/07/23 Wed AM 09:20:05 EDT
> To: [EMAIL PROTECTED]
> Subject: prefetchedCollections for collection field in referenced classes?
>
> 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]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
