VERIFIED SOLUTION i

Resolve Portrait Dialogue slow performance issues.

Issue

Any or all of the components of Portrait Dialogue (PD), such as Visual Dialogue, Dialogue Admin, or the web based applications, seem to run slow, or take a long time to complete an action.

Cause

If there are many subgroups in the domain or complicated queries in the domain sub-groups, then the execution will take longer than if the domain was simpler.

Resolution

UPDATED: March 22, 2017
Examine the SQL in the domain, and the SQL queries in the subgroups and make modifications to increase performance.  
Possible changes might be adding or changing indexes, changing the structure of the SQL, use of Views, look at the performance of the DB server, etc.