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.
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.
- Download speedup.txtand save the file into a folder on C:\ drive of the SQL server.
- Right-click on the speedup.txt file and from the drop-down menu, select Rename.
- Change the name of the speedup.txt file to speedup.bat.
On the desktop of the SQL server, right-click on the Windows Start menu and choose Run.
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.
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.