Implementation Design Best Practices

• Avoid using traditionally static entities such as location and contact as transient. This can cause database contention with tables that aren't designed to have frequent deletes.
• Review the "Thread Tuning" section for advice on how to properly tune workflow and data queue threads.
• Tune threads in small increments and observe effects on throughput as described in the Thread Tuning section.
• Set glog.sql.query.timeout.* and glog.sql.update.timeout.* limits lower than default. This reduces the time a bad custom SQL will block a thread.
• Make tuning changes for caches and thread counts in the CUSTOM Property Set so they aren't lost on restart.