Release 10.1A: OpenEdge Deployment:
Startup Command and Parameter Reference

> ## Number of Buffers for Temporary Tables (-Bt)

> Use Number of Buffers for Temporary Tables (`-Bt`) to specify the number of buffers in the temporary table database pool.

> Operating system and syntax | UNIX Windows | `-Bt` `n`
> Use with | Maximum value | Minimum value | Single-user default | Multi-user default
> Client Session | 50,000 | 10 | 255 | 255

> ``n``

> An integer that specifies the number of blocks in the buffer for temporary tables.

> OpenEdge uses the value you specify for temporary databases used during the session the same way it uses Blocks in Database Buffers (-B) for permanent databases. The default value is 255.

> Use Temporary Table Database Block Size (-tmpbsize) to specify the temporary table database block size, which dictates the size of each buffer in the temporary table database buffer pool for the current OpenEdge session.

> If you do not have enough free memory (virtual or physical) for the buffer pool, reduce the value of -Bt. To approximate the amount of memory required (in kilobytes) for the buffer pool, use the following formula:

>     1.1 * (the value of -Bt) * (the value of -tmpbsize)

> See OpenEdge Development: Progress 4GL Handbook for more information on temporary tables.

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