Problem concerning Prefetching

From: Jean-Paul Le Fèvre (jean-paul.lefevr..ea.fr)
Date: Thu Jan 24 2008 - 11:10:05 EST

Next message: Aristedes Maniatis: "Re: Problem concerning Prefetching"

Previous message: hmai..otmail.ru: "Problems running Cayenne ORM Tier and CWS Client Tier on the same JVM."
Next in thread: Aristedes Maniatis: "Re: Problem concerning Prefetching"
Reply: Aristedes Maniatis: "Re: Problem concerning Prefetching"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi,

I'm currently trying to improve the performances of my queries.
I've added a call to addPrefetch() in my code but the result was not as
expected : the time to fetch the 42597 rows increased from 35 s without
addPrefetch() to 56 s with addPrefetch()

What I am doing wrong ?

-- ___________________________________________________________________

Jean-Paul Le Fèvre * Mail : LeFevr..onteny.org

Next message: Aristedes Maniatis: "Re: Problem concerning Prefetching"
Previous message: hmai..otmail.ru: "Problems running Cayenne ORM Tier and CWS Client Tier on the same JVM."
Next in thread: Aristedes Maniatis: "Re: Problem concerning Prefetching"
Reply: Aristedes Maniatis: "Re: Problem concerning Prefetching"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Thu Jan 24 2008 - 11:10:50 EST