You can configure partitions to improve performance. The configuration parameters for partitions are:
number of open partitions – specifies the number of partitions that Adaptive Server can access at one time. The default value is 500.
partition spinlock ratio – specifies the number of spinlocks used to protect against concurrent access of open partitions. The default value is 10.
See the System Administration Guide for detailed information about these parameters.
