Describe a situation where you encountered a significant performance bottleneck and how you resolved it.
