Sage 50 2024 Performance affected by Role permissions

I've been doing some testing recently and have found that users with less permissions in Sage are experiencing slower performance.

To recreate this User A is assigned Administrator role within Sage.

and

User B is assigned a custom Parts Dept role.This role provides Full Access to My Dashboard, Customer_Sales, Inventory_Services. No access to Employees_Payroll & Banking_General Ledger. Custom access to Vendors_Purchases & Company.

The custom access on Vendors_Purchases is Full Access except no Access on Tasks/Payments/Write Checks & Tasks/Void AP Checks.

The custom access on Company is No Access except Full Access on Maintenance/Jobs, Tasks/Action Items, Tasks/Transactions in Prior Periods, Tasks/Find Transactions, Tasks/Post, Tasks/Un-Post, Tasks/Purge, Tasks/Time and Expense Tickets, Tasks/SDK Data Access, Reports/Audit Trail, Reports/Find Transactions, Reports/Jobs, Reports/Time and Expense, Reports/ReportGroups. Maintenance/User Login Manager is set to View Only. 

With the above role settings User B experiences slower loading times for inventory list, item costing report, inventory valuation reports, etc. I am looking for a solution to this issue. 

Parents
  • 0

    How are you comparing or testing this?  Are you logging in as the Admin user on the same Sage and testing or comparing the Admin users experience on their own machine vs the restricted user?  I would try from the same machine to really test if there is a difference.  I have not noticed those types of speed differences but haven't tested that either.  [email protected] 

Reply
  • 0

    How are you comparing or testing this?  Are you logging in as the Admin user on the same Sage and testing or comparing the Admin users experience on their own machine vs the restricted user?  I would try from the same machine to really test if there is a difference.  I have not noticed those types of speed differences but haven't tested that either.  [email protected] 

Children
  • 0 in reply to bottomline

    Initially yes that's exactly what I did. Then I started trying multiple test beds of physical and virtual machines. The restricted user is slower across the board on all test beds. With that said, some test beds processed the task much faster than others which I think comes down to core count & cache size. I am still testing but here are some results. 

    • E3-1275V2 4-PHYSICAL CORES 32GB RAM 1 MIN 2 SECS.
    • E5-2640V3 8-PHYSICAL CORES 256GB RAM 34 SECS.
    • E3-2176G 6-PHYSICAL CORES 64GB RAM 23 SECS.
    • E5-2640V3 4-VIRTUAL CORES 8GB RAM 3+ MINS. 
    • E3-1245V6 4-VIRTUAL CORES 16GB RAM 38 SECS. 

    It'd be great if Sage would test my role settings and see if they can recreate it and fix whatever it is so I don't have to find some overly priced alternative with enough speed negate performance bugs like these.