Hi Andrey,
I tried that but it didn't seem to make any difference. Will try again
when I get a free mo. From the documentation it certainly seems to cover
my requirements.
Cheers,
Dave
Andrey Razumovsky wrote:
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 <[EMAIL PROTECTED]>:
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
