I have a new customer that is experiencing speed issues with one of my applications.  It is an EDB-based program running in Client/Server mode.  Thousands of other customers are running the same application without any speed issues.

I remoted in to their network to check things out.  The application runs fine if run from the server, but runs abysmally slow on workstations.  Suspecting anti-virus/anti-malware software was the cause, I found they were running AVG.  Disabling AVG seemed to speed things up a bit but it was still running slower than it should.

These are brand new computers running Windows 10.  

Besides anti-virus/anti-malware software, network traffic, server load issues, wireless interference (on wireless networks), faulty cables and/or switches, has anyone encountered other things that have caused speed issues?

Thanks,

Steve

Steve


About all I can think of that you've missed out is network cards/chips and client PC load.

I use AVG on a mixed W10/W7 network and it doesn't seem to have any impact.

Whilst you've probably already thought of these:

1. do they have an old (or new) W7 PC they can attach just to see
2. have they/you checked out what network speed they're actually getting
3. has all the W10 crapware (especially live tiles) been disabled


Roy Lambert

Steve,

<< Besides anti-virus/anti-malware software, network traffic, server load issues, wireless interference (on wireless networks), faulty cables and/or switches, has anyone encountered other things that have caused speed issues? >>

The easiest way to get to the bottom of the issue is to hook into the OnRemoteTrace event and log its events to a text file on the client:

http://www.elevatesoft.com/manual?action=viewevent&id=edb2&product=rsdelphi&version=XE&comp=TEDBSession&event=OnRemoteTrace

You will then get complete elapsed times, etc. for the various calls.

However, there is one major issue with this: I accidentally introduced a bug into the elapsed time calculations when I changed the way that the server requests work a while ago.  The elapsed times do *not* include the time spent waiting on a response from the EDB Server, so are not particularly useful.

I'm working right now to get a new EDB minor release out ASAP, so it shouldn't be much longer than the end of the week.  It's going to be a minor release due to the inclusion of a new Advantage Database Server migrator and some performance improvements to FindKey/Locate operations (shaved off 45%).

Tim Young
Elevate Software
www.elevatesoft.com

Hi Roy,

<< About all I can think of that you've missed out is network cards/chips and client PC load.

I use AVG on a mixed W10/W7 network and it doesn't seem to have any impact.

Whilst you've probably already thought of these:

1. do they have an old (or new) W7 PC they can attach just to see
2. have they/you checked out what network speed they're actually getting
3. has all the W10 crapware (especially live tiles) been disabled >>

Actually I didn't think of those so thanks for suggesting them.  

= Steve

Hi Tim,

<< I'm working right now to get a new EDB minor release out ASAP, so it shouldn't be much longer than the end of the week.  It's going to be a minor release due to the inclusion of a new Advantage Database Server migrator and some performance improvements to FindKey/Locate operations (shaved off 45%). >>

Thanks, I'll try putting them off until next week.

What's really bizarre is they are also having speed issues with things like typing in a TRichEdit control. As they type they get lag on each key stroke. If there was code being run each type a key event was fired then that would be understandable, but there is no code on any of the events for the TRichEdit control.

It sounds like an overworked CPU and/or full memory to me.  Maybe the pagefile is running full tilt.

Anyway, the trace will be very useful in helping me resolve this.  Thanks.

= Steve

Steve


I just had another thought following on from your response to Tim. These are new machines - what AV did they come with? I've seen a lot that come with McAfee but with it being W10 its somewhat hidden. The worst case I've seen had three separate AVs (not counting Defender) all running away.

Have a look at this

http://www.belarc.com/free_download.html

it will allow them to create an inventory of the h/s & s/w on their machines. If you can then get one of the sites that's running ok to do the same a compare can give you some good clues.


Roy Lambert

<< I just had another thought following on from your response to Tim. These are new machines - what AV did they come with? I've seen a lot that come with McAfee but with it being W10 its somewhat hidden. The worst case I've seen had three separate AVs (not counting Defender) all running away.

Have a look at this

http://www.belarc.com/free_download.html

it will allow them to create an inventory of the h/s & s/w on their machines. If you can then get one of the sites that's running ok to do the same a compare can give you some good clues.>>

Thanks Roy, I'll check it out.

= Steve

Steve,

<< What's really bizarre is they are also having speed issues with things like typing in a TRichEdit control. As they type they get lag on each key stroke. If there was code being run each type a key event was fired then that would be understandable, but there is no code on any of the events for the TRichEdit control. >>

Yeah, that definitely sounds like they're maxing out the memory, and Windows is swapping like crazy.

Tim Young
Elevate Software
www.elevatesoft.com