Progress
Database Administration
Guide and Reference


Group Delay (-groupdelay)

Operating 
System 
and Syntax 
UNIX 
Windows 
-groupdelay   n 
Use 
With 
Maximum 
Value 
Minimum 
Value 
Single-user 
Default 
Multi-user 
Default 
DBS
1,000
0
0
1

n

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), Progress 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.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095