How I Cut an EF Core Endpoint's Response Time by 50% With Dapper and Raw SQL

A job portal's busiest endpoint was slow enough to notice, and EF Core's generated query was the first suspect — but the real fix started with the execution plan, not the ORM.

Replacing EF Core with Dapper and a hand-written query cut response time on that endpoint by 50%. The full article walks through the execution plan, the missing index that was actually the bigger issue, and the raw SQL that made the difference.

Read the full article on Medium.