In most cases, a single database server is able to handle all aspects of the PerfectForms™ application. However, once load reaches a certain level, or, if excessive load is occurring due to unusually heavy reporting, then you may need to improve database performance.

The following list is sorted in order of complexity from easiest to most difficult fixes for database performance. It reflects the order in which you would normally optimize the system over time.

The obvious thing to do first is to add more memory and processors. As PerfectForms™ was designed for optimal scalability, this should yield good results. The last two options will only be needed for large installations with large numbers of users and heavy load activity.

Updated: 06/12/2011  Page url: http://www.perfectforms.com/Documentation/manual/html/?database_configurations.htm
PerfectForms™ -- forms software, workflow software, and business process management