SLOW: Changing an order to an Invoice taking 2-3 Minutes

[MrScaff_IT_Dept]

Changing an Order to an Invoice is taking 2.5 Minutes on average.

Watch: https://youtu.be/3X3dgsGHT6I

To my thinking there has to be an issue with the MYOB File.

This was not always the case, it would seem it has gotten slower over time.

Background Details:

MYOB File Size 700+MB

File is OFFLINE on our windows Domain file server:

Windows Server 2019 running MYOB AccountRight SE

Tested with Copies of the file:

On Workstation, opening the file from the server: Processing  order to an invoice: 2.5 Mins

On the Server, directly opening the file: Processing  order to an invoice: 2.5 Mins

Old arcvhive Copy from 2020 file Size 170MB: Processing  order to an invoice: 2 seconds

While testing Server's Performance is Fine system is virtually idel: Disk I/O, Ram, CPU, Network all very low.

Tested processing the invoice on Running from Laptop SSD:

File Directly on a computer (not using the server) Takes 30 seconds (Better but still slow)

Related Past Comunity Posts: These apear to be the Same issue.

NONE of these seem to have resulted in a solution, only offered these advice:

"Speed and Performance tips", "Clearing Cache" not applicable here:

1. https://community.myob.com/t5/AccountRight-Sales-and-purchases/Invoices-slow-to-accept-and-print-37-...
2. https://community.myob.com/t5/AccountRight-Sales-and-purchases/Slow-speed-when-converting-an-order-t...
3. https://community.myob.com/t5/Other-MYOB-software/Changing-Orders-to-Invoices-Slow-process/td-p/5462...
4. https://community.myob.com/t5/AccountRight-Sales-and-purchases/Printing-invoices-in-Account-Right-Li...
5. https://community.myob.com/t5/AccountRight-Sales-and-purchases/INVOICE-SO-SLOW/m-p/572969
6. https://community.myob.com/t5/AccountRight-Sales-and-purchases/Printing-New-Invoices-super-slow/m-p/...
7. https://community.myob.com/t5/AccountRight-Sales-and-purchases/Printing-of-invoices-slow-Accountrigh...
8. https://community.myob.com/t5/AccountRight-Sales-and-purchases/Printing-and-recording-invoices-VERY-...
9. https://community.myob.com/t5/AccountRight-Sales-and-purchases/ALR-very-slow-to-add-customers-invoic...
10. https://community.myob.com/t5/AccountRight-Sales-and-purchases/SALES-ORDERS-TO-INVOICES-SO-SLOW-2-3-...
11. https://community.myob.com/t5/AccountRight-Sales-and-purchases/Slow-when-converting-order-to-invoice...
12. https://community.myob.com/t5/AccountRight-Sales-and-purchases/Convert-orders-to-invoices/m-p/601290

[gavin12345]

Hi @MrScaff_IT_Dept 

AR2022 slows considerably as the file gets bigger. Note the difference between the 170 MB file and the 700 MB.

MYOB can't seem to get on top of this issue.

Consider starting a new file or getting the file purged - this can reduce the file size considerably and speed up processing. Search 'purge for myox' or similar.

Regards

Gavin