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
----*/

Thanks,
Michael