Progress
Version 9
Product Update Bulletin


Number of Buffers for Temporary Tables (-Bt)

Operating 
System
and
Syntax 
UNIX
Windows 
-Bt n 
Use
With 
Maximum
Value 
Minimum
Value 
Single-user
Default 
Multi-user
Default 
CS
50,000
10

n

An integer that specifies the number of buffers in the temporary table database buffer pool.

Use Number of Buffers for Temporary Tables (-Bt) to specify the number of buffers in the temporary table database buffer pool. Progress 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 10.

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

For more information on temporary tables, see the Progress Programming Handbook .


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