At 08:13 AM 19/01/2003 +0000, you wrote:

>Dear Jason,
>
>I have measured the network traffic generated by a prepare of a
>simple query. It takes about 40Kbytes server to client, and 1Kbytes
>client to server. Since the query is so simple, there shouldn't be
>such amount of information coming from the server. Is it possible to
>make IBO to lower the server to client traffic?
>
>Below is the prepare process I captured in the monitor:
>
>19/1/2003 15:58:10 - /*---
>PREPARE STATEMENT
>TR_HANDLE = 4149900
>STMT_HANDLE = 4143644
>
>SELECT ID
> , NAME
> , UNITEST
> , TESTDM
>FROM DUMY
>
>PLAN (DUMY NATURAL)
>
>FIELDS = [ Version 1 SQLd 4 SQLn 30
> DUMY.ID = <NIL>
> DUMY.NAME = <NIL>
> DUMY.UNITEST = <NIL>
> DUMY.TESTDM = <NIL> ]
>
>SECONDS = 1.047
>----*/

Hello Michael,
Could you begin by providing details of the conditions under which you
observed this? Since slow performance is a mix of network conditions,
metadata structure and application conditions, without information it is
impossible to determine what might be causing your problems.

Helen