On Apr 25, 2012, at 9:39 AM, Elmar Haneke <elmar@...> wrote:

>
>> Moreover, I can see that during the delays, the *outbound* link from the client is clicking over about 1 kbps for the entire period. It *appears* that the client is dribbling out information that the server is waiting on, although I can't imagine what it is.
>
> The client does fetch the resultset row by row. The Time sould be
> determined more by the size of result than by the complexity of query.

Actually that's not true for selects, though the client interface looks that way. The remote protocol packs a buffer with data until it reaches a size or the client calls for the next packet.

Anything involving data change is more synchronous.

Good luck,


Ann

>