Assessing the Impact of CQRS Pattern Implementation on Query Latency in .NET Blazor CRUD Systems

Abstract

Modern web applications are increasingly reliant on Object-Relational Mapper (ORM) frameworks to bridge the gap between high-level application logic and relational databases. However, in standard Create, Read, Update, and Delete (CRUD) architectures, the use of a unified data model often leads to significant performance bottlenecks, particularly as query complexity and data volume scale. This research investigates the efficacy of the Command Query Responsibility Segregation (CQRS) pattern as a devised solution to sub-optimal execution times in .NET-based web environments. Utilizing Microsoft .NET through Radzen Blazor Studio in order to develop a comparative prototype to measure database responsiveness and UI latency, this research specifically addresses common ORM inefficiencies such as N+1 query problem and the overhead of change-tracking in read-heavy workloads. By decoupling data modification logic from data retrieval logic and implementing read-optimized projections, this study evaluates the trade-offs between architectural complexity and increases query execution efficiency by around 80% for significantly large amount of data.