EF Core read optimizations

[unrealbg]

Summary

Read paths in EF Core are not fully optimized for performance and scalability.

Scope

• Area(s): Backend, Application
• Non-goals: Write path optimizations

Plan

• Use AsNoTracking on read queries
• Apply Mapster projections for list/detail DTOs
• Add indexes on Post.Slug and Post.PublishedAt with migration
• Measure before/after query time
• Avoid N+1 via Include or explicit projections

Acceptance criteria

• AsNoTracking used on read queries
• Mapster projections for list/detail DTOs
• Indexes on Post.Slug and Post.PublishedAt with migration
• Build, tests, and formatting pass in CI

Additional context

Labels: performance, backend