Kbase P112630: Would the new SQL parameters (SQLStmtCache, SQLTempBuff, SQLTempDisk, SQLTempPgSize) improve perform
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/27/2009 |
|
Status: Verified
GOAL:
Would the new SQL parameters (SQLStmtCache, SQLTempBuff, SQLTempDisk, SQLTempPgSize) improve performance?
GOAL:
How to tune the SQL parameters (SQLStmtCache, SQLTempBuff, SQLTempDisk, SQLTempPgSize) in order to improve performance
FACT(s) (Environment):
Progress 9.1D
Progress 9.1E
OpenEdge 10.x
All Supported Operating Systems
FIX:
The SQL parameters (SQLStmtCache, SQLTempBuff, SQLTempDisk, SQLTempPgSize) are for problem solving, and not for improving performance.
These parameters exist basically to reconfigure SQL temp tables so that various limits can be lifted.
The only guideline is to change these parameters only when a SQL failure occurs during temp tables use (sorting), and the failure was due to a limit being reached.
For example,when the size of the data being sorted (the sort record size) is larger than the temp table page size. Then, making -SQLTempPgSize larger is effective.