Sarv Atam said:

sometimes taking close to a minute to create a new customer!

Hi Sarv,

Part of the key to solving this may be the word 'sometimes'.    Depending on how many workstations are connected, and the settings on each workstation, the server RAM and speed, I can see it taking 10-20 seconds to insert a customer.

Sarv Atam said:

i was wondering if there's anything we can do to increase performance or upgrade our 2017 premium to another version that manages databases more efficiently

Well, MySQL itself should handle a billion items, even though it's 32 bit.  On a 64 bit workstation, the 32 bit performance on a single processor isn't always impressive, but it should be better than 2006-era XP on a file database.  And WAY more stable.

Try using it in 'Classic view' vs 'Enhanced View', and with ALL users logged in vs. just 1.   If there is a helpful difference, check the workstation settings under Setup | User Preferences | Options.

I have:

OFF  Automatically save changes

ON Show list buttons

OFF Automatically refresh lists

ON Calculate Record Balances...   I know this slows it down, it's a trade-off.

     OFF Automatically refresh records

OFF Show a list of inventory items...

OFF Always Apply Allocation to entire...

Sage 50 appears to load all 'list items' into local workstation RAM, and depending on settings will load / sort / update all those items into the interface. 

We have over 20,000 inventory items and 15 seconds to insert an item isn't unusual when more than 10 users are logged in, especially if some of them have the user settings to refresh automatically.

Sarv Atam said:

what was running fast on 2006 is now ultra slow in 2017

The 2006 software was a direct access file database, the 2008 onward software has used MySQL in client-server.  It is hard to believe that (excepting bugs) it could be slower on large lists.

Since it's also slow running locally, I would think that marking older customer records as 'inactive' may help.  And turning off the refresh settings on all workstations may help, as well.

Hi Randy,

First off thank you for your prompt reply and help!

SAGE is running locally at all times with no other users connected to it, O/S on new HP computers is 64Bit (SSD & 16GB RAM)..

I just called SAGE in order to speak to a sales rep, perhaps the quantum edition will be more suitable for our usage..they bounced me around and got nowhere...

Hello Sarv Atam,

Thanks for reaching out! Note that The database capacity in Sage 50 Pro vs Premium vs Quantum is the same. If your database is large, you've tried all suggestions and you're still experiencing lots of lag, then it may be time to migrate to a more powerful software solution. I've brought your post to the attention of the Sage 300 team who should be in touch regarding options and details. They can also be reached directly at 1-800-945-8007 opt 1.

Warm Regards,
Erzsi

Hello Sarv Atam,

Thanks for reaching out! Note that The database capacity in Sage 50 Pro vs Premium vs Quantum is the same. If your database is large, you've tried all suggestions and you're still experiencing lots of lag, then it may be time to migrate to a more powerful software solution. I've brought your post to the attention of the Sage 300 team who should be in touch regarding options and details. They can also be reached directly at 1-800-945-8007 opt 1.

Warm Regards,
Erzsi