Understanding Connection Pooling

Problem

During a traffic spike, your application crashes due to opening too many direct connections to the database. The DevOps team tells you to implement a mechanism that maintains a cache of database connections to be reused. Write a query that outputs concept with the value: "Connection pooling reduces the overhead of establishing new connections for every database request."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution