Skip to main content
Skip table of contents

Speed issues in MYOB AE or AO running SQL 2014 and above

This support note applies to:

  • AO Practice Manager (NZ)
  • AO Practice Manager (AU)
  • AE Practice Manager (NZ)
  • AE Practice Manager (AU)

These instructions require technical expertise

Make sure you know what you're doing and are using one of the products listed. If you're not sure, ask your IT professional or MYOB.

Article ID: 37024

You may experience slow performance with MYOB Accountants Enterprise (MYOB AE) or MYOB Accountants Office (MYOB AO).

The attached batch file utility - speedup.txt, performs a number of functions including re-indexing the AE/AO database.

To run the utility
  1. Download speedup.txtand save the file into a folder on C:\ drive of the SQL server.
  2. Right-click on the speedup.txt file and from the drop-down menu, select Rename.
  3. Change the name of the speedup.txt file to speedup.bat.
  4. On the desktop of the SQL server, right-click on the Windows Start menu

    and choose Run.

  5. In the Open field, type C:\speedup.bat_SERVERNAME\INSTANCENAME_DATABASE NAME. Where:

    • SERVERNAME is your SQL Server name

    • INSTANCENAME is the name of the SQL server instance (for example, MSSQLServer, MYOBACCT)
    • DATABASE NAME is the name of your database (for example, VPMSER, AEDB1 or AODB1)

    • _ is a space.


  6. Once the utility has been run twice, re-start all MYOB Services from within Control Panel > Administrative Tools > Services and (if applicable) re-start the Vizpost background processes or Admin centre post-processes.

    This utility should be run twice. Run the utility again, immediately after the first one completes.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.