Troubleshooting Slowness 

See Troubleshooting for issues not related to slowness.

If EZ2000 Plus Dental is not as fast and responsive as you would like it to be, below are some steps that can be taken to speed things along.

Update Version
Update to the most recent build (the third number).  The major/minor version should not be too many versions behind either.

Settings and Tools
Run the Database Maintenance tool.
If switching days in Appt module is slow, run the Clear Duplicate Blockouts tool from Main Menu, Tools, Misc Tools.
Uncheck the box in Appointment Module Setup for "Show ! at upper right of appts for ins not sent".
Check the box in Appointment Module Setup for "Appointment bubble popup disabled".

Topaz Signature Pads
A computer that currently or previously had a Topaz signature pad installed may experience significant slowness (10 or more seconds) in certain parts of the program such as procedure edit and commlog edit.  Follow these steps to fix: 1) Unplug the Topaz pad from the computer if present.  2) Uninstall the SigPlusBasic application if present.  3) Follow the steps here to reinstall the Topaz pad.  For each computer you do not want to use the Topaz pad, repeat steps 1 and 2 to uninstall the Topaz pad.

Data Path
The connection to the A to Z folders  might be slower than the connection to the database.  This is especially true if using a VPN. This slowness will be noticeable when working with images in the Images module.  If you use patient pictures, then the slowness will be most noticeable in the Family module and the Appt module when hover bubbles come up.  Open the Data Path window.  If the path at the top is a location that is over a VPN rather than in the LAN, enter an override for the current workstation. The override should point to an A to Z folders in the LAN that stays synchronized with the other A to Z folders.  Go around to each workstation and enter the override.

Slow Printing
Upgrade to a more current version of EZ 2000 Plus Dental software. As of August 8, 2015 the latest verison is 15.2.9.  If you have already upgraded and it's still slow, call to show us.  We will need to know exactly what you are trying to print.

Slow printing sometimes happens with network printers.  One way to simplify your printing issues is to connect your printer directly to a computer with a USB cable.

Vista and Windows 7 Issues
See Vista

Interference from Other Programs
The following specific programs have been verified to cause slowness in EZ2000 Plus Dental:
McAffee (turning off is not sufficient; must be uninstalled) 
ZoneAlarm (turning off is not sufficient; must be uninstalled)
Dell ControlPoint (also consumes CPU)
AVG (sometimes causes issues)
The slowness issue associated with the above programs may have been solved by newer versions of those programs.  But based on this known interference, a firewall should always be suspected.  The firewall could be software or hardware.

Database optimization
There is a button at the bottom of the Database Maintenance window called Optimize. The process can take a few minutes.  If you notice a significant speed improvement and you have a very large database, you might consider running this tool once per month.

If you are using an older version of EZ2000 Plus Dental, you can use the mysql-administrator-1.1.9-win.msi tool to run optimization.

Edit the my.ini File
See myini.

Log Slow Queries
Add the following 2 lines to your my.ini file and then restart the MySQL service.

slow_query_log=1
long_query_time=2

(note: on older versions of MySQL, the syntax was:)
log_slow_queries
long_query_time = 2
log_long_format

The log file will be found in the mysql data folder. Examine the log for a recurring pattern of slow queries. Remove those lines when done to avoid impacting performance.

Replication
Problem:  EZ2000 Plus Dental is running slowly or locking up for long periods of time.
Solution: Try increasing the size of your key ranges (Setup, Replication).  When new records are created, EZ2000 Plus Dental searches for an available key value from the table it is inserting into.  If no more keys are available, Open Dental will be stuck in an infinite loop.

Problem: In one of my offices, from any client machine, EZ2000 Plus Dental freezes just after the Log On Screen.
Solution: Restart the MySQL service, then restart the MySQL replication thread by running these SQL commands: SLAVE STOP; SLAVE START;

Electronic Prescriptions
If using Electronic Prescriptions, sluggishness when loading the Chart module may be caused by NewCrop servers being unavailable. Please check the Open Dental home page, http://www.ez2000dental.com, where we will notify customers of known issues. If you do not see a notification, please Contact us.

Other
If certain days in the Appointments module are slow, try running the Clear Duplicate Blockouts tool.  It is available from the main menu, Tools, Misc Tools.

eClinicalWorks
Problem:  EZ2000 Plus Dental takes a long time opening certain patients, or gradually gets slower over time.
Solution:  If patients were entered without setting a guarantor, this can cause slowness when opening a patient account. To see if this is the cause, run this query: SELECT COUNT(*) FROM patient WHERE Guarantor=0;
If less than 10 results are returned, this is not the cause of slowness.  If more than 10 results are returned, Contact us and we will fix it for you.