|
5.11 Performance Tips |
  
|
|
5.11 Performance Tips |
|
5.11.1 Overview
There are several possible reasons for poor database performance. Below are the more likely of them and fixes you can perform.
5.11.2 Corrupted database (Professional Edition Only)
CAUSES
Network problems (eg. network card, cable, routing)
Improper shutdown while Latitude is still running
RESOLUTION
Immediate fix
Run Repair and Compact of the Latitude Database (go to Administration -> Attach Only -> Repair & Compact)
Tell your staff to quit Latitude and shut down Windows rather than 'pulling the plug' when they finish work for the day
Longer term fix or if the problem keeps recurring
Investigate network problems
5.11.3 Workstation or server resource usage
CAUSES
Too many applications running simultaneously demanding more memory or processor resources than are available
Bugs in a particular software application that cause it to hog system resources due to eg. memory leaks
RESOLUTION
Restart workstation(s) and server to free up resources before running checks below
Use "Windows Task Manager" and "Resource Monitor" on your server and workstation to:
See what applications, processes and services (eg. remote registry, windows media center, etc) are using too much resource (memory, cpu etc)
Measure the usage profile for each user
Disable applications, processes and services if they are not needed
Add more RAM to your workstation(s) and server if the usage profile is high
5.11.4 AntiVirus software settings
CAUSES
Antivirus software configured to always scan the Latitude folder (eg. C:\Lati99) and the scan slowing your system
Antivirus software configured to be too restrictive, and as a result blocking the Latitude.accde program file or the Latidata.mdb database file
RESOLUTION
Temporarily disable your Antivirus software and test to see whether speed has improved
If it has, edit your AntiVirus exclusion list to add the Latitude database on the server (eg. L:\Latidata.mdb) and the Latitude program file (eg. C:\Lati99\Latitude.accde)
5.11.5 Corrupted or bloated Latitude program file
CAUSES
Corrupted ACCDE file (Latitude.accde) due to improper shutdown while Latitude is still running
Long-running (over 1 year) Latitude program files grow in size
RESOLUTION
Replace your Latitude.accde file on workstation(s) by copying the master copy on your server (eg. L:\Latitude\Latitude.accde) to the workstation(s) (eg. into C:\Lati99\)
Tell your staff to quit Latitude and shut down Windows rather than 'pulling the plug' when they finish work for the day
5.11.6 Misbehaving new or updated software
CAUSES
Bad software update (eg. in Microsoft Update)
Bad plugin installation or update (eg. Adobe Flash)
RESOLUTION
Check whether there is a newer update that fixes the problem
Uninstall misbehaving software if you don't absolutely need it running
Perform a system restore and block the update temporarily until the software vendor addresses the issue