Navigation:  5    S:  Latitude Install, Upgrade and Troubleshooting >

5.12 Other Performance Tips

Previous pageReturn to chapter overviewNext page

5.12.1 Overview

 

There are several reasons affecting database performance and it could be software or hardware related. Try the following suggested steps.

 

5.12.2 Restart the Application

From the Home screen, click Logoff and then click on Quit button to close Latitude. Open Latitude again and check if you still get the problem.

 

5.12.3 Close other Programs

Open Windows Task Manager -> click Processes -> click CPU to sort/display which application is heavily using system resources. Try to close applications you do not use one at a time and see if performance improves.

 

5.12.4 Restart Computer

Restart computer and open Latitude and see if the problem has resolved itself.

 

5.12.5 Restart Server(s)

Restart both Main and RDS servers to free up resources. Run Latitude and check if there are speed improvements.

 

5.12.6 Run Latitude on the other Workstation

Go to a different workstation, run Latitude and check if the same problem appears. If there is no problem on the other workstation then the problem is only specific to your machine. Check your workstation if you got the same version of Operating system, Microsoft Access or Office/Windows Service Packs, Permissions (Read/Write on C:\Lati99 and server map drive).

 

5.12.7 Antivirus

Temporarily disable your Antivirus software. Your antivirus software could be configured to be too restrictive, and as a result slowing things down by unnecessarily scanning database or program files.

Exclude the Latitude application (C:\Lati99\Latitude.accde or LatitudeSQ.accde), database (L:\Latidata.mdb - Professional Edition Only) and SQL Server process (sqlsvr.exe - Business Edition / Corporate Edition Only) from being scanned always.

 

5.12.8 Replace/Overwrite Application

Get a copy of the Latitude client application (Latitude.accde/LatitudeSQ.accde) from a working workstation or (from the server map drive) and overwrite the copy on the workstation that has the problem.

 

5.12.9 Perform Repair and Compact

For information on this topic, refer to the "Repair and Compact" Category Topic.

 

5.12.10 Clean-up Latitude database (Audit Trail and Error Logs)

Make sure everyone is log out of Latitude before proceeding to the next step to avoid errors.

Backup your Latitude database

Click Management -> Audit Trail, where it says 'Delete Audit Trail Records older than" enter your preferred cut-off data or enter todays date then click the button. Click 'Yes' to confirm

Click Management again -> Error Log -> click Clear Error Log button

Do a Repair and Compact again (Professional Edition Only)

Restart Latitude and see if performance improves

 

5.12.11 Perform a Windows Update

Various Microsoft Windows updates & service packs have been released recently. Make sure your workstation is up-to-date

 

5.12.12 Check your workstations Network Interface Card (NIC)

Some links that your IT can use to determine the appropriate settings for your workstation's nic.

www.computing.cc/windows-vista/how-to-fix-slow-shared-network-file-transfer-on-windows-vista/

www.sevenforums.com/network-sharing/25843-slow-file-transfer-over-network-2.html

If the workstations, switch & server are all on gigabit connection, check the following site:

superuser.com/questions/94715/windows-7-file-transfer-speed-over-gigabit-is-slow

 

5.12.13 Check User Permission Scripts

On some Remote Desktop Services, user permission is controlled by a script. There are instances where the server does not load the script so users may get an Attach/Upgrade dialog when logging into Latitude. The immediate fix is to restart the main server.

 

5.12.14 Increase RAM

Add more RAM, run Latitude and check if there are speed improvements.