1.

What is database connection pooling? What are the advantages of connection pool?

Answer»
  • Connection POOLING means database connections will be STORED in the cache and can be REUSED when future requests to the database are required. So in this mechanism, the client need not make new connections every time for interacting with the database. Instead of that, connection objects are stored in the connection POOL and the client will get the connection object from there.
  • Advantages of using a connection pool are:
    • It is faster.
    • Easier to diagnose and ANALYZE database connections.
    • Increases the performance of executing commands on a database.


Discussion

No Comment Found