Subject | Least network traffic generated? |
---|---|
Author | Gerhardus Geldenhuis |
Post date | 2001-11-26T08:29:44Z |
Hi
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.
Groete
Gerhardus
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.
Groete
Gerhardus