cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrey Razumovsky" <razumovsky.and...@gmail.com>
Subject Re: Object Caching in 1.2
Date Thu, 20 Nov 2008 07:45:31 GMT
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 <dmerrin@ipasystems.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
>

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