I am trying to get the most out of EF Core, which I can with queries that require very high bandwidth. When I launch my main asp.net web application in debug mode, I can reach ~ 300 requests / s, if I do not attach the debugger, I get ~ 800 requests / s.
Edit: 1200-1400 requests / sec over a single connection network.
My database can support ~ 3500 queries / s of the same type and almost does not load into my entity infrastructure. On the EF Core device, ~ 10% of the processor load will be used, and only the first 2 threads will be used up to ~ 30%. The remaining available threads do not seem to be used.
Edit: if I have several connections to my asp.net application, the throughput of the request increases significantly, but the closure of the first two cores ends and the remaining 6 are left.
My request:
PlayerRank existingRank = _context.PlayerRankings.Where(p => p.Date == rank.Date && p.Player == rank.Player && p.World == rank.World).FirstOrDefault();
CPU usage:

How can I get EF Core to use more of my system resources? It barely touches the processor, but it looks like it is maximizing on query throughput, but my DB doesn't even get close to maximum.
I am using the Pomelo MySQL connector.
source
share