Describe how connection pooling works and how you would configure it for a service experiencing high traffic spikes.