Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 10 total
Thread Excessive Use of Network Resources.
Thu, Jan 10 2008 12:12 AMPermanent Link

Steve Gill
A customer is complaining that my application is generating an excessive
amount of network traffic in comparison to other applications.
Apparently users have noticed slower response times on the network.  As
it's not a database-intensive application I'm a little surprised.  No
one else has reported this problem.

Any suggestions on what might be causing this?

Client/Server
Local Area Network
DBISAM 4.25 Build 1
Delphi 7

Regards,

SteveG
Thu, Jan 10 2008 5:46 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Steve,

<< A customer is complaining that my application is generating an excessive
amount of network traffic in comparison to other applications. Apparently
users have noticed slower response times on the network.  As it's not a
database-intensive application I'm a little surprised.  No one else has
reported this problem. >>

How are they measuring "excessive" and by what benchmark is it "excessive" ?
I have a hard time believing that DBISAM is responsible for slowing down a
modern 100Mbit or faster network all by itself.  Are you performing any
batch processes over a remote session connection such as a while not eof..do
type of looping on a large table ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Sun, Jan 13 2008 12:34 PMPermanent Link

Jason Lee
That's funny! You mean a multiuser database oriented program is actually
utilizing the network!?! Smiley
I love it when customers who have crappy networks say "Well, Word &
Excel don't have the problems that your program does." Then I explain
that Word & Excel don't have 30 simultaneous connected users sharing the
same data files over the network.

> A customer is complaining that my application is generating an excessive
> amount of network traffic in comparison to other applications.
> Apparently users have noticed slower response times on the network.  As
> it's not a database-intensive application I'm a little surprised.  No
> one else has reported this problem.


Yeah, people are actually *using* your program! Smiley

> Any suggestions on what might be causing this?

Mon, Jan 14 2008 7:51 PMPermanent Link

Steve Gill
Hi Tim,

> How are they measuring "excessive" and by what benchmark is it "excessive" ?
> I have a hard time believing that DBISAM is responsible for slowing down a
> modern 100Mbit or faster network all by itself.

Me too. It looks like they're using a product called Network Probe.  The
screenshot they sent shows 383,276 packets being sent, equaling 380.3MB.
 I'm not sure but it looks like it could be over almost a 5 hour period.

> Are you performing any batch processes over a remote session
> connection such as a while not eof..do type of looping on a large
> table ?

I don't believe so but I'll recheck my code.  As I mentioned, no one
else has reported this problem so I find it hard to believe it's the
application or DBISAM.

Regards,

Steve

Mon, Jan 14 2008 7:54 PMPermanent Link

Steve Gill
Hi Jason,

> That's funny! You mean a multiuser database oriented program is actually
> utilizing the network!?! Smiley
> I love it when customers who have crappy networks say "Well, Word &
> Excel don't have the problems that your program does." Then I explain
> that Word & Excel don't have 30 simultaneous connected users sharing the
> same data files over the network.

Ha ha, yeah sometimes they just don't get it.

> Yeah, people are actually *using* your program! Smiley

That's a plus. Smiley

Regards,

Steve
Tue, Jan 15 2008 2:57 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Steve,

<< Me too. It looks like they're using a product called Network Probe.  The
screenshot they sent shows 383,276 packets being sent, equaling 380.3MB.
I'm not sure but it looks like it could be over almost a 5 hour period. >>

And they're sure that the entire 380 MB is from DBISAM ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Jan 15 2008 5:23 PMPermanent Link

Steve Gill
Hi Tim,

> And they're sure that the entire 380 MB is from DBISAM ?

Well, they think it is.  It sounds a bit high to me.  I can email you
the screenshot I have if you like.

Regards,

Steve
Wed, Jan 16 2008 12:43 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Steve,

<< Well, they think it is.  It sounds a bit high to me.  I can email you the
screenshot I have if you like. >>

Does the screen shot show that it is DBISAM by some indication ? Smiley

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Jan 16 2008 5:19 PMPermanent Link

Steve Gill
Hi Tim,

> Does the screen shot show that it is DBISAM by some indication ? Smiley

No, not directly.  It shows my application and the IP addresses.  But as
 my application doesn't do any network communication except for a
DBISAM Client/Server connection, I guess it infers it.  Or perhaps my
application is just complete crap. Smiley

Steve
Thu, Jan 17 2008 8:49 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Steve,

<< No, not directly.  It shows my application and the IP addresses.  But as
my application doesn't do any network communication except for a DBISAM
Client/Server connection, I guess it infers it.  Or perhaps my application
is just complete crap. Smiley>>

Well, if you want to send me your app source code I can at least take a look
and see where there might be some issues.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image