Kbase P142265: What has changed in the Temporary Tables between Progress Version 9 and OpenEdge 10?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/06/2010 |
|
Status: Verified
GOAL:
What has changed in the Temporary Tables between Version 9 and OpenEdge 10?
GOAL:
Where any changes made to the Temporary Tables in OpenEdge 10?
GOAL:
What is different with the Temporary Tables in OpenEdge to verses Progress version 9?
GOAL:
Have there been any changes to Temp-Tables in OpenEdge 10 as compared to Progress version 9?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B 64-bit
Progress 9.x
OpenEdge 10.1x
FIX:
Writing to temporary files creates i/O activity that might slow down client performance. The amount of temporary file I/O activity varies dependant upon the application being used. In 10.1X there have been a couple of changes associated with the client temporary files (specifically Temp tables which are stored in the clients .dbi file. These changes have resulted in the files being larger than they were in version 9.
In 10.1X the following changes have occurred:
In 10.1B, the default tmpbsize (Temporary Table Block size) has been changed from 1KB block to a 4KB block. The temp-table database block size dictates the size of each buffer in the temp-table database buffer pool for the current OpenEdge Session.
In 10.1A the default for the -Bt (Number of Buffers for Temporary Tables) parameter has been changed from 10 to 255. This parameter is used to identify the number of buffers in the temporary table database pool.
Temporary files now also make use of a Type II storage areas instead of a Type I storage area (block by block allocation). Type II storage areas are comprised of clusters. A clusters is a contiguous allocation of space for one type of database object. Depending upon the amount of temporary files being used by the application, the DBI file could be much larger.