Try OpenEdge Now
skip to main content
Startup Command and Parameter Reference
Startup Parameter Descriptions : SQL Sorting Memory (-SQLTempBuff)
 

SQL Sorting Memory (-SQLTempBuff)

Use SQL Sorting Memory (-SQLTempBuff) to define the amount of memory to use as a data buffer for each SORT operation.
Operating system and syntax
UNIX / Windows
-SQLTempBuff value
Use with
Maximum value
Minimum value
Single-user default
Multi-user default
SQL
—
8
1000
1000
value
Size in K-bytes of memory to use for each SORT operation.
This is a performance-tuning parameter and is not ordinarily required.
Note: Each connection allocates one temporary table buffer.