What is connection pooling and why does it matter?
Model answer
Opening a database connection is expensive, and databases limit concurrent connections. A pool keeps a set of open connections that the app reuses. Size it to what the database can handle, not to the number of app requests, and release connections promptly.
Learn this topic
Indexes and Faster Queries: EXPLAIN for Beginners in the course SQL for Beginners: Learn Databases Step by Step.
Sign in to add your own answer.