Explain the trade-offs between different transaction isolation levels in a high-concurrency environment.
