Re: SELECT very slow

On 16.06.2005 17:29 PFC wrote:

>> If autocommit is on (or fetch size is zero) then the driver will
>> build  the whole
>> result set before returning to the caller.
> 
> 
>     Sure, but that is not your problem : even building the whole result
> set  should not take longer than a few seconds (I gave you test timings
> in a  previous message).
>     So... what ?
>     What does the taskman say ? CPU at 100% ? how much kernel time ?
> 

Taskmanager (I'm on windows) does not show any high CPU usage. And (as I wrote
in the initial post) I cannot see any memory increase in the PG process as well
(which I would expect with a result set of that size built up in memory).

Thomas