Server network traffic

Jim Morgan

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Minimizing Interbase Client/Server network traffic

I am a novice database programmer. I've developed an InterBase
Client/Server app, using D5 and IBExpress components. No problems with
the app, but some members of my workgroup would like to use their
clients from home, connecting to the server by TCP/IP over the phone.
Here's the problem: it seems that the IB server returns inordinately
large amounts of data, so that the app is painfully slow at 56K. For
example, in response to a query that fetches a single integer value, the
IB server transmits 2098 bytes! Any suggestions on what I could do to
minimize the amount of network traffic that the server generates would
be appreciated.

TIA,

Jim Morgan

Aage Johanse

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Minimizing Interbase Client/Server network traffic

Do you use prepared queries? Prepare just once - if possible.
You're not using TTables, are you ?

Aage J.

Quote

Jim Morgan wrote:
> I am a novice database programmer. I've developed an InterBase
> Client/Server app, using D5 and IBExpress components. No problems with
> the app, but some members of my workgroup would like to use their
> clients from home, connecting to the server by TCP/IP over the phone.
> Here's the problem: it seems that the IB server returns inordinately
> large amounts of data, so that the app is painfully slow at 56K. For
> example, in response to a query that fetches a single integer value, the
> IB server transmits 2098 bytes! Any suggestions on what I could do to
> minimize the amount of network traffic that the server generates would
> be appreciated.

> TIA,

> Jim Morgan

Jim Morga

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Minimizing Interbase Client/Server network traffic

Yes, the queries were prepared. But reading over at
borland.public.delphi.database.interbaseexpress, I saw several recommendations
for using TIBSQL rather than TIBQuery. What a difference! The network load
with TIBSQL apears to be about 6-8% of that with TIBQuery: an improvement of
more than an order of magnitude. I guess I didn't see that in the IBExpress
documentation ;-)

Quote

Aage Johansen wrote:
> Do you use prepared queries? Prepare just once - if possible.
> You're not using TTables, are you ?

> Aage J.

> Jim Morgan wrote:

> > I am a novice database programmer. I've developed an InterBase
> > Client/Server app, using D5 and IBExpress components. No problems with
> > the app, but some members of my workgroup would like to use their
> > clients from home, connecting to the server by TCP/IP over the phone.
> > Here's the problem: it seems that the IB server returns inordinately
> > large amounts of data, so that the app is painfully slow at 56K. For
> > example, in response to a query that fetches a single integer value, the
> > IB server transmits 2098 bytes! Any suggestions on what I could do to
> > minimize the amount of network traffic that the server generates would
> > be appreciated.

> > TIA,

> > Jim Morgan

Other Threads

1. ICS TWSocket - strange problem with traffic speed depending on client or server initialises the connection

2. toggling between local interbase and client server interbase

3. Interbase 5.6 server and interbase 6 opensource clients

4. BDE 5.2 + Interbase Server 4.0 + Interbase 6 Client

5. Interbase 6.5 Client is slow in network connection

6. help network, Tables , queries,traffic, d2

7. Network Traffic Monitor

8. network traffic and snmp

9. Using Client/Server over a network

10. Delphi Client/Server on network