In most cases, a single database server is able to handle all aspects of the PerfectApps 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.
1.Add more memory.
2.Add more processors.
3.Put your transaction logs on separate drives.
4.Put the reporting database on a separate server.
The obvious thing to do first is to add more memory and processors. As PerfectApps 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.
Return to: Server Side Hardware Requirements, PerfectApps On-Premise
