OpenEdge Database is designed for performance, responsiveness, and scalability.

Built-in functionality optimizes parameters and capacities and provides improvements for database administrators. Performance features include:

  • Ability to Extend Variable-length Database Extents--Database administrators can extend and mark variable-length ai, bi, and db extents as fixed as well as create and pre-extend new variable-length extents. Learn more: Extend variable-length database extents.
  • Database Startup Parameter Defaults--The default values of various startup parameters improve the overall performance of OpenEdge databases. Learn more: Database startup parameter default updates.
  • Database Maintenance Mode--OpenEdge includes a restricted online mode, so that you can run maintenance tasks with all the buffer pool and helper processes still available, improving the performance for these tasks. Learn more: PROUTIL DBRESTRICT qualifier.
  • Maximum Limit on the Number of Sequences--The maximum number of unique sequences in an OpenEdge Database is 32,000 regardless of block size. Learn more: Number and size of sequences.
  • Server-side Join Processing--Certain queries that join multiple tables are resolved in the database server rather than the client. As a result fewer records may be returned to the client leading to faster performance. Learn more: Server-side join processing.

  • Manage Before-image File Growth You can use the-biscantime parameter to tune the behavior for before-image space management. In some rare cases, BI files may keep growing even when the BI space management is running. This could happen under heavy database activities with very fast checkpoints. Reducing the value of -biscantime lets the before-image manager (BIM) process detect and reuse BI clusters more frequently at a cost of minor performance impact when compared to a bigger -biscantime value. Note that, in most cases, the default value of -biscantime (10) works well without any tuning. Setting the value of -biscantime to zero (0) turns off BI space management. (If you set -biscantime to 0 online, the before-image writer stays idle.) Whenever you set -biscantime to a non-zero value, you must start the before-image manager.

    For more information, see Before-image scan time (-biscantime) and Start and stop a BIM in Manage the OpenEdge Database.

  • Backups with Compression--Data compression during online or offline backup can save time and disk space. Learn more: Backups with compression.

In addition, OpenEdge provides different tools to monitor your database servers and tune them for optimal performance.

For more information, see Tune OpenEdge database servers.