Cinema Seat Reservation System — Part 3: Problems, Decisions and Some Areas Of Improvement

Short summary

The author shares two performance problems encountered in a cinema seat reservation system built with ASP.NET Core microservices. Load testing revealed 850ms latency on a showtimes endpoint and P95 latency of 16 seconds under stress. The article explains why database indexing and caching were not viable solutions, detailing trade-offs around range-based query caching and cache invalidation complexity.

• •Cinema seat reservation system in ASP.NET Core microservices with API Gateway, Identity, Movie, and Reservation services
• •Load testing revealed 850ms latency on showtimes endpoint and 16s P95 under stress
• •Indexing and caching were ruled out due to range-based query variability and invalidation complexity

Generated with AI, which can make mistakes.