Poor performance searching inventory in invoice

Hey Everyone,

I have a customer that is having issues with Sage, and it seems like a common issue.  Forgive my ignorance in some areas, they are my only Sage customer, most of my customers use other programs for accoutning.

First their hardware setup:

They originally had just one really old desktop that Sage was installed on.  I can't remember specs off hand, but it was about 12 years old, so probably about 4GB RAM, and an original Intel Core CPU, with a 1TB HDD.  It has been slow with this computer for some time.  

They added a second computer about 6-9 months ago I think, to use Mutli User Mode.  They hosted the file on the original Desktop PC, they had issues getting it all setup, so thats when I came in.

I got multi-user mode working on the new computer, connecting to the old computer, and everything was great.  In fact it was so great, inventory searches in invoices worked at normal speed!  It was baffling to me, that this networked computer, accessing a shared company file from a mechanic HDD, was able to search inventory at normal speeds while the hosting computer was constantly freezing and slow.

I followed this guide:

https://support.na.sage.com/selfservice/viewContent.do?externalId=10793&sliceId=1

On the old computer, doing everything except step 9 (as I figured that should impact both computers equally, not just one). With no luck.

I chalked it up to the old computer struggling.

So I just built them a new desktop, Ryzen 3 3200G, 16GB RAM, 500GB SSD, should be more than capable to run Sage, and is higher specced than their other computer that is working fine (Core i3 10-100, 8GB RAM, 1TB HDD).

Get Sage setup, host the file on the new computer, and it is doing the exact same thing!  The remote accessing computer still works fine, but the new computer is still slow when entering inventory items in an invoice.

The only thing that speeds it up is either pressing the search icon beside the empty item description field, which opens up another dialog to search inventory, in this dialog things work normally.  Also I can disable the search function completely under user preferences but they do want that search to work.

It does it with either Windows Defender or Norton 360 running.

Anyone have any thoughts on what could be going on?  Why would one computer work fine while the other, brand new computer, is having issues?  Any suggestions greatly appreciated!

  • Some things come to mind but I can't guarantee any of these are the issue.

    Let's call the computers Server where the files are residing (I know it's a workstation too but it is serving the files for both computers and workstation is the new computer that replaced the old original computer.

    1) Will the workstation speed up if you copy the company data file to it and run it without the network?  (make sure you copy the *.sai and *.saj).  I always put them in a folder like c:\Sage50Data.

    2) Will the workstation and server run at similar speeds if they both open the local copy of the sample file.

    3) Can the current server connect to the files on the work station and still run as fast (slightly slower because it is now across the network)?

    4) If the workstation speeds up running their company file locally and the current server is significantly slower accessing the files from the workstation, then likely it's the switch or network cables.  If the switch is managed (unlikely but maybe), it may be blocking something.

    5) But it could also be that Norton and/or possibly Windows has a firewall setting that is blocking one of programs or ports.  You can test by opening ports 13531 and either 13540 or 13541 depending on which one is used for the file.  For programs, there is a mile long list in the Knowledgebase but I have only ever needed to allow mysqld.exe and SimplyConnectionManager.exe through my firewall on my network.

    6) Maybe play with Norton settings and stop scanning of the file location, then try stopping scanning of the program temporarily to see if that helps.  Or just temporarily disable it before you do anything else to see if that is the issue.

    As you have done now, the typical best setup is to run the data files on the computer that is the fastest in a Peer-to-Peer setup like your's.

  • Yes, I should have done that from the start as it does get confusing. Here is the history using server/workstation terminology:

    Original setup was the old computer this became the server and was always slow.

    New workstation added, it works fine and searches inventory at normal speed.

    Replace old server with new server. It also has slow performance in exact same scenario, even though it is more capable than the workstation.

    If anything I'd expect the server to work fine and the workstation to have issues but that is not the case at all.

    Yes could be a Norton thing, but workstation is running Norton as well. I also tried it with defender and no difference. I haven't tried disabling the firewall but I'm working locally as its the server that's slow, so it shouldn't come into play. 

    I could add an exception to the antivirus but honestly I hate adding antivirus exceptions. Thanks for your help! 

  • Anyone else with any suggestions?  I'll take long shots at this point, as it is a horribly frustrating issue!  Thanks,