There are many factors that can influence the performance of an OnBase system. While the database environment and supporting hardware play a critical role, OnBase settings and configuration also contribute to overall solution performance.
The OnBase Configuration module allows for an extremely flexible solution design. As a result, the SQL queries that are generated by the software are dynamic and can be unpredictable because they depend on this configuration. It is important to pay close attention to the design of your OnBase solution and consider how it might affect overall performance. There are numerous OnBase best practices that are appropriate for any OnBase implementation, including (but not limited to) the following:
-
Document Type Query Restrictions
-
Keyword Type Groups
-
Enabling the Global Client Setting User-specified range for committed batch query display
-
Process Tuning settings
-
Minimum number of Display Keywords for Workflow Filters
These best practice recommendations are located in the OnBase Configuration Best Practices section of the System Administration module reference guide and the Workflow Best Practices section of the Workflow module reference guide. Both guides can be found in their respective Products section on the Hyland Community site at https://community.hyland.com/. These recommendations, and many others, are a first step toward creating an optimized OnBase solution.