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
  • 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