Try OpenEdge Now
skip to main content
Database Administration
Reference : Database Startup Parameters : Alphabetical listing of database startup parameters : Group Delay (-groupdelay)
Group Delay (-groupdelay)
Operating system and syntax
UNIX / Windows
-groupdelay n
Use with
Maximum value
Minimum value
Single-user default
Multi-user default
The number of milliseconds a transaction waits before committing.
Use Group Delay (-groupdelay) to increase performance when Delayed BI File Write (-Mf) is set to zero. When the Group Delay is set greater than zero (0), the database engine uses a technique known as Group Commit. When using Group Commit, a transaction spools its end note to the BI buffer and waits a short time until the buffer becomes full and is written to disk, or waits for other transactions to end and store their end notes in the BI buffer so that several transactions are committed by the same synchronous write. In this manner, Group Commit benefits overall performance, although each individual transaction might take slightly longer.