Question
Transaction pooling versus statement pooling: what differs, and when should each be used?
Answer
Transaction pooling assigns a server through a transaction. Statement pooling returns it after each query and disallows multi-statement transactions. Use transaction pooling for pool-safe transactional applications; use statement pooling for autocommit-style workloads designed for it.