Re: Prefetching has no effect

• Previous message: Evgeny Ryabitskiy: "Re: SQLTemplate with SQL MAX function"
• In reply to: Andreas Hartmann: "Re: Prefetching has no effect"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Next message: Borut Bolčina: "Re: SQLTemplate with SQL MAX function"
• Previous message: Evgeny Ryabitskiy: "Re: SQLTemplate with SQL MAX function"
• In reply to: Andreas Hartmann: "Re: Prefetching has no effect"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Mon Sep 28 2009 - 18:46:52 EDT