Subject Least network traffic generated?
Author Gerhardus Geldenhuis
What will create the least network traffic?
A stored procedure with primary key as
input that does a select and returns all of the
table values or a plain
select * from testtable where primarykey=value

All my databases are dialect 3 and the clients connect
with tcp/ip. Im using IBO4 native components and not
the emualated bde stuph. I would probably use ib_cursor
and ib_storedproc.

What tools can be recommended to measure and evaulate packet size.
I am using FB1SS on Linux. The clients run on Win98 and W2k.
If I can learn to use such tools I can answer these
questions myself and probably learn other usefull things.