New database performance enhancements optimize various parameters and capacities as well as provide new functionality for database administrators. These features include:

  • Extend and mark variable-length extents as fixed—Database administrators can now extend and mark variable-length extents as fixed as well as create and extend new variable-length extents.

    This feature allows you to:

    • Extend the size of an existing variable-length extent before converting it to fixed-length when adding a new variable-length extent to a storage area
    • Extend the size of an existing variable-length extent to a specific pre-grown size whether it is empty or already contains data
    • Extend the size of an existing variable-length extent to a specific pre-grown size and impose a maximum size cap
    • Create a new variable-length extent pre-extended to a specific size in a new or existing area
    • Create a new pre-extended variable-length extent with an imposed maximum size in a new or existing area

    For more information, see Extend variable-length database extents.

  • Limit on the number of unique shared sequences increased—The maximum number of unique shared sequences in an OpenEdge database is increased to 32,000 regardless of block size.

    This feature improves the performance of the database in a production environment.

    For more information, see Number and size of sequences.

  • Server-side join processing for dynamic queries—Certain queries that join multiple tables are now resolved on the database server rather than the client. Because fewer records are returned to the client, database performance is improved. In this release, support for server-side joins is expanded to include dynamic queries that are FORWARD-ONLY, with NO-LOCK.

    For more information on server-side joins for the latest OpenEdge version, see Server-side join processing.

  • Database startup defaults changed—Various startup parameter defaults are updated to improve the overall performance of the OpenEdge database. The impacted parameters are:
    • -aibufs
    • -bibufs
    • -lruskips
    • -lru2skips
    • -pica
    • -prefetchDelay
    • -prefetchFactor
    • -prefetchNumRecs
    • -prefetchPriority
    • -Mm
    • -Mxs

For more information, see Database startup parameter default updates