Cloudscape Properties
Page 39 of 47

cloudscape.storage.sortBufferMax

Function

Use this property to specify the number of rows to sort in memory. Typically, this property does not need to be specified, and it's value should not be modified.

By default, sortBufferMax is set to 1024. When performing a sort operation, Cloudscape first attempts to sort in memory. If the number of rows to be sorted is larger than available memory, Cloudscape writes rows to disk and performs an external sort. The sortBufferMax value determines at which row Cloudscape begins writing rows to disk for external sorting.

You can force an entire sort to be performed in memory by specifying the maximum number of rows for sortBufferMax. Note that increasing this number from the default value of 1024 can cause an undesirable amount of memory to be used.

Default

1024

Example

cloudscape.storage.sortBufferMax=5000

Scope

system-wide

Dynamic or Static

This property is static; if you change it while Cloudscape is running, the change does not take effect until you reboot.