Object pooling and connection pooling

Question

Hi Friends What are object pooling and connection pooling and difference?

Jignesh Trivedi · Answer

hi The COM+ Object Pooling service enables you to reduce the overhead of creating each object from scratch. When an object is activated it is pulled from the pool. When the object is deactivated it is placed back into the pool to await the next request. connection pool is a cache of database connections maintained so that the connections can be reused when future requests to the database are required. Connection pools are used to enhance the performance of executing commands on a database. Creation . When using connection pooling creation is on the same thread so if there is nothing in the pool a connection is created on your behalf. With object pooling the pool might decide to create a new object. However if you have already reached your maximum it instead gives you the next available object. This is crucial behavior when it takes a long time to create an object but you do not use it for very long. Enforcement of minimums and maximums . This is not done in connection pooling. The maximum value in object pooling is very important when trying to scale your application. You might need to multiplex thousands of requests to just a few objects. hope this help.