cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aristedes Maniatis <...@maniatis.org>
Subject Re: Prefetching has no effect
Date Mon, 28 Sep 2009 22:46:30 GMT
On 28/09/09 4:08 AM, Andreas Hartmann wrote:
> If the table contains 22.000 records, the additional queries are executed.
>
> If it contains only 100 records, the additional queries are not
> executed, i.e. prefetching works as expected.
>
> Is there some mechanism to limit the size of the object structure built
> using a single query, maybe due to memory issues?

Do you have paging switched on? What action in your code causes the second query to be executed?
 Are the objects it is fetching at that time hollow?

Ari Maniatis

-- 

-------------------------->
Aristedes Maniatis
GPG fingerprint CBFB 84B4 738D 4E87 5E5C  5EFA EF6A 7D2E 3E49 102A

Mime
View raw message