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 <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 : Tue Nov 25 2008 - 11:59:04 EST