Optimize Electronic Records
Use the Optimize Electronic Records scheduled process to improve the performance of the search used to retrieve electronic record transactions that are based on electronic record content.
When to Use
You can run the Optimize Electronic Records scheduled process daily to defragment the e-record indexes. This process can be executed to optimize the index after the index is synchronized. Optimizing an index removes old data and minimizes index fragmentation, which can improve query response time.
Privileges Required
- View Electronic Records and Signatures (EDR_VIEW_RECORDS_ESIGNATURES_PRIV)
Specifications
Review the following before setting up this scheduled process:
| Specification | Description |
|---|---|
| Job Type |
Ad hoc job. |
| Frequency | Daily to defragment the indexes for achieving optimal performance. |
| Time of Day |
Midnight |
| Duration | 3 minutes |
| Compatibility |
There should be only one instance of the job running at any time, and there’s no current functional need to run multiple instances of this process simultaneously. |
Parameters
| Parameter | Optional or Required | Description | Parameter Value | Special Combinations Required |
| Optimization Mode | Optional | Fast mode compacts data but does not remove rows. Full mode compacts data and removes rows. |
Fast Full |
None |
| Maximum Time | Optional | Specify the maximum parameter value, in minutes, to optimize the index in batches of rows and check if the total elapsed time for a batch exceeds specified maximum time and skip further indexing. The next execution of the process will pick up where it left off. If this parameter is null, then the entire index is optimized. | 300 | None |
Troubleshooting Information
- You can view the status of the Optimize Electronic Records on the scheduled processes UI.
- The validation errors and warning messages that prevented the Optimize Electronic Records are displayed in the error log.
- Any interactive warning validations are NOT performed.
- When the program is submitted, you can Resubmit, Put on Hold, Cancel Process, Release Process as provided by the Scheduled Processes UI.