Salesforce

Would the new SQL parameters (SQLStmtCache, SQLTempBuff, SQLTempDisk, SQLTempPgSize) improve performance?

« Go Back

Information

 
TitleWould the new SQL parameters (SQLStmtCache, SQLTempBuff, SQLTempDisk, SQLTempPgSize) improve performance?
URL NameP112630
Article Number000151900
EnvironmentProduct: Progress / OpenEdge
Version: 9.1D, 9.1E / 10.x
OS: All Supported Operating Systems
Other: SQL Parameters
Question/Problem Description
Would the new SQL parameters (SQLStmtCache, SQLTempBuff, SQLTempDisk, SQLTempPgSize) improve performance?
How to tune the SQL parameters (SQLStmtCache, SQLTempBuff, SQLTempDisk, SQLTempPgSize) in order to improve performance
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
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.
Workaround
Notes
Keyword Phrase
Last Modified Date4/10/2018 12:28 PM

Powered by