Hi Dave,
you can use prefetching:
http://cayenne.apache.org/doc12/prefetching.html
In short words, you need to specify selectQuery.addPrefetch("toEdition") for
the query you fetch newsparers with.
2008/11/18, Dave Merrin <dmerri..pasystems.co.uk>:
>
> Hi,
>
> I'm trying to speed up some code I've got. I've got two connected tables,
> Newspaper and Edition. Newspapers contain several editions. Initially I get
> back a list of newspapers with a single query. Then I want to get the
> editions for each newspaper. I use newspaper.getToEdition() to do this.
> Unfortunately this results in one query per newspaper.
>
> To try and speed things up I thought I could get a list of all editions
> back with a single query. I assumed cayenne would store them in the object
> cache and save the query per newspaper problem above. Unfortunately it
> doesn't.
>
> I'm using Cayenne 1.2. Am I doing something wrong or am I just expecting
> too much from Cayenne.
>
> Cheers,
>
> Dave
>
This archive was generated by hypermail 2.0.0 : Thu Nov 20 2008 - 02:47:03 EST