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
