Nando,

I was simply trying to tell Art to use the SQLMonitor so that he could
see the traffic and appreciate what its doing. What looks to be a
simple statement/query can generate quite a bit of network activity.

I had suspected that BDE/IBO/IBX each would have the same general amount
of overhead when performing single statement operations. We did some
benchmarks quite some ago which bore out this point.

As you point out, the true benefit of IBO and IBX is in extending the
basic functionality provided by the BDE.

Equally, I initial suggestion to replace the 4 separate
queries/statements which he is currently performing, with a single SP
call did not meet with a warm reception (even though he would eliminate
most of the network activity and increase overall performance).


Sean

-----Original Message-----
From: Nando Dessena [mailto:nandod@...]
Sent: Monday, January 29, 2001 12:07 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Re: excessive network traffic [LONG]

Sean,

> Try using SQLMonitor to see the traffic generate by the BDE - you'll

be

> impressed (that's one word <g>) by the traffic generated.

a well-behaved (that is, no TTables, no live TQueries, no Locates) BDE
application does not generate *much* more traffic than a IBO/IBX one.
The bad side of the BDE is the terrible lack of functionality if you
follow those guidelines, whereas other tools like IBO give you
efficiency AND functionality.
--
____
_/\/ando


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com