Progress
Version 9
Product Update Bulletin
Number of Buffers for Temporary Tables (-Bt)
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:
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 |