Improve query performance for large batch jobs

About this task

If you run a large batch job on more than ten percent of the addresses in the ContactManager database, query performance can be impacted. To improve query performance, after running the batch job you can run a series of database statistics statements from the command line.

Procedure

  1. At a command prompt, navigate to ContactManager/admin/bin.
  2. Run the following command: 
    maintenance_tools -password password -getdbstatisticsstatements | grep -i ab_abaddress > filename

    In this command, password is your administration password and filename is the file where you want the output of the command to be saved. The grep command is available on UNIX or Linux systems. On Windows systems, you can run grep in a UNIX or Linux emulator like Cygwin.

  3. Open the output file and run the database statistics statements in it.

What to do next

See also