ibconfig Parameter: MAX_THREADS

Go Up to SMP Support

ibconfig Parameter: MAX_THREADS

Setting the MAX_THREADS parameter in ibconfig controls the maximum number of threads that can be active at one time within the InterBase engine. The default setting is 100:

MAX_THREADS 100

This configuration parameter controls the number of active threads in the engine. The ideal setting for this number depends partly on the nature of the work being performed by your clients. If you have many clients performing very similar tasks, you may want to lower the MAX_THREADS setting to reduce contention. On the other hand, if simultaneous activity is highly diverse, setting this to a higher value may increase throughput.

Note that this setting does not affect the maximum possible threads that can be created by the InterBase server but only the number that can be active in the engine at one time.