CPU, disk, channels, memory, etc. In many instances, and database access applications in particular, these programs or applications require additional resources to create, manage, and implement the updating of databases. Links, or threads must be created, buffers established, etc., and all must be managed. At some point as the rate of transaction increases, the resources required to create, implement, and manage the database connections is greater than the resources required to complete the database update and manage the connections. Simply put, the greater the number of connects - the greater use of resources with its impact on performance .
Additional client threads queue, waiting for a free thread.
For web-based applications with many client threads, the thread controller can improve performance. Application Optimizer allows only a user-determined number of concurrent active calls in the output adapter. This restriction of the active calls reduces contention in the server program. With Application Optimizer for Windows NT , additional users can be added with significantly less performance impact. Application Optimizer for Windows NT reduces contention in database applications, increasing performance, and reducing memory requirements on the database server.