Sean,

> 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.

Oy, I'm sorry to hear this. When you say "single-statement" operations,
what exactly do you mean? A single SELECT statement? Each row fetched by a
SELECT statement? Something else?

> [My] 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).

Ahh, I see now. I misinterpreted your initial post to suggest that I
replace all my queries with SPs. I see your point. My problem with this
suggestion is that I'll have to provide a script to update each database
with the new SP. Recall that this is a commercial app, so I don't control
the fielded databases; that backwards compatibility is required; and that,
in general, my users are morons.


Art Metz
AMetz@...

> -----Original Message-----
> From: Leyne, Sean [mailto:InterbaseSupport@...]
> Sent: Monday, January 29, 2001 9:55 AM
> To: 'ib-support@yahoogroups.com'
> Subject: RE: [ib-support] Re: excessive network traffic [LONG]
>
>
> 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.
>
>
> As you point out, the true benefit of IBO and IBX is in extending the
> basic functionality provided by the BDE.
>
>
>
> 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
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-~>
> eGroups is now Yahoo! Groups
> Click here for more details
> http://click.egroups.com/1/11231/0/_/_/_/980791426/
> --------------------------------------------------------------
> -------_->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>