Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Nothing has changed, but performance has changed ...
Mon, Feb 1 2010 5:39 AMPermanent Link

adam
Sorry for this appallingly vague post, I am at a loss to explain it myself.

I have a small office network (only 3 PCs) running a Delphi 2007 app with DBISAM C/S.
Running on port 10.0.0.xxx on the server machine. 2 PCs are Vista, 1 (the server) is XP SP2.

It has worked fantastically for ages, but just recently the remote machines occasionally
experience dramatic slow-downs in performance.

I have just had the machine hang for 2 minutes while trying to return a single record, a
process which normally takes hundreths of a second. In general performance is good, but
occasionally there are long waits on posting or retrieving datasets which would normally
run very quickly.

--

I don't think the problem has anything to do with the application or DBISAM. I believe it
is a network issue, something slowing or stopping network traffic. The only change is that
1 wirelessly connected Windows 7 machine has been added to the network (though it is not
even using the database application!)

The problems are on the Vista machines.

- Are there any reported problems with Win 7 and C/S networked DBISAM applications?
- Any other ideas what could be going wrong?

Thanks in advance!
Mon, Feb 1 2010 7:43 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

adam


Absolutely no help to you but I've experienced similar problems on my home network mixed XP/Vista but filesharing rather than c/s. Everything running fine then click to move to another record and you might as well go an make a cuppa.

I've never been able to come up with a rational explanation, I just wait the interruption out.

Roy Lambert
Mon, Feb 1 2010 8:33 AMPermanent Link

"Robert"

"adam" <adam@fullwellmill.co.uk> wrote in message
news:392F01BC-42AC-4161-9296-E630CE949BF8@news.elevatesoft.com...
> Sorry for this appallingly vague post, I am at a loss to explain it
> myself.
>

One of the things that keep constantly changing, unfortunately, is the virus
protection. They might make changes that dramatically affect performance
while they are updating (as an example) and you would not even know it,
until you see the effect.

Robert


Mon, Feb 1 2010 12:05 PMPermanent Link

adam
It is great to hear that others have no idea what is actually happening either & see
similar problems (Wink

What do other developers use to monitor the network traffic on their system to try to
actually figure out what is going on under the hood?

Is it worth setting up something like a Linux box with the database on it as a server,
could that solve the problem or would it remain an issue if the clients were still
XP/Vista/Win7?
Mon, Feb 1 2010 6:16 PMPermanent Link

"Raul"

Is the problem specific to the DBISAM app or the whole PC (does the PC hang
otherwise when accessing network/internet/etc)?

if you completely shut down the wireless Vista system does the other still
hang with dbisam ?

Any chance it's the networking hardware (router/switch) ?

Like Robert mentioned AV can cause issues - do you have an AV that
intercepts and scans data at network stack level ? (I've seen Kaspersky for
example causing basic TCP connection issues).
Make sure the client app exe is excluded from and if possible temporarily
shut down the real-time scanning (if enabled).

IPv6 on Vista can also cause problems - especially with newer routers - so I
would suggest 2 things : 1) make sure local lan is designated as "work
network" (and not "home network) and if that does not help then 2) disable
ipv6 on Vista.

If you're still not getting anywhere then tweaking Vista parameters might
help. For example this link lists some of the options :
http://www.speedguide.net/read_articles.php?id=2574

We're running dbisam in a mixed setup as well (no Vista but XP, Win7 and
various server flavours) and have not had any problems.

Good luck,
Raul



"adam" <adam@fullwellmill.co.uk> wrote in message
news:392F01BC-42AC-4161-9296-E630CE949BF8@news.elevatesoft.com...
> Sorry for this appallingly vague post, I am at a loss to explain it
> myself.
>
> I have a small office network (only 3 PCs) running a Delphi 2007 app with
> DBISAM C/S.
> Running on port 10.0.0.xxx on the server machine. 2 PCs are Vista, 1 (the
> server) is XP SP2.
>
> It has worked fantastically for ages, but just recently the remote
> machines occasionally
> experience dramatic slow-downs in performance.
>
> I have just had the machine hang for 2 minutes while trying to return a
> single record, a
> process which normally takes hundreths of a second. In general performance
> is good, but
> occasionally there are long waits on posting or retrieving datasets which
> would normally
> run very quickly.
>
> --
>
> I don't think the problem has anything to do with the application or
> DBISAM. I believe it
> is a network issue, something slowing or stopping network traffic. The
> only change is that
> 1 wirelessly connected Windows 7 machine has been added to the network
> (though it is not
> even using the database application!)
>
> The problems are on the Vista machines.
>
> - Are there any reported problems with Win 7 and C/S networked DBISAM
> applications?
> - Any other ideas what could be going wrong?
>
> Thanks in advance!
>
>


__________ Information from ESET NOD32 Antivirus, version of virus signature database 4825 (20100201) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


Image