NOTE:On LINUX/UNIX Operating Systems you need to specify the -H parameter in order for these -SQL* parameters to take effect. This has been fixed in Progress 9.1E.The parameter SQLTempBuff can be made larger to lessen the amount of IO for temp tables, or made smaller to free memory for other uses. One temp table buffer is allocated per connection.
The parameter SQLTempDisk can be made larger to sort very large amounts of data. Disk space is actually allocated on demand, so this parameter is an upper bound.
The parameter SQLTempPgSize can be made larger to sort data with a large number of values per row. For example, this might be useful if sorting a query with 20 output columns, each 600 chars long.
The parameters are documented in the Progress Startup Command and Parameter Reference manual as well as the Progress 9.1D Product Update Bulletin.
There is a documentation error where these parameters appear in the book as -SQLStackSize and -SQLStmtCacheSize. The correct spelling is the one that appears here.
The naming changes were made at the last minute and the changes will appear in the next documentation release.
These values can be added to the command line of the startup of the dbase (when using Proserve) or in the Other Arguments area in the Progress Explorer.
References to Written Documenation
Progress Solution:
"Changes in SQL startup parameters used in OpenEdge 10.1A or later"