I am trying to get the most out of EF Core that I can with queries that need very high throughput. When I run my asp.net core web app in debug mode, I can achieve ~300 queries/s, if I don't attach a debugger I'm getting ~800 queries/s.
Edit: 1200-1400 queries/s over the network with a single connection.
My database can sustain ~3500 queries/s of the same type, and is barely put under load my entity framework. The device EF Core is running on will have ~10% CPU utilization overall, and only the first 2 threads get used up to ~30% each. The remainder of the available threads seem to go unused.
Edit: If I have multiple connections to my asp.net application, the query throughput goes up significantly, but does end up capping out the first 2 cores, and leaving the remaining 6 alone.
My query:
PlayerRank existingRank = _context.PlayerRankings.Where(p => p.Date == rank.Date && p.Player == rank.Player && p.World == rank.World).FirstOrDefault();
CPU Utilization:
How can I get EF Core to utilize more of my systems resources? It's barely touching the CPU, but it seems like it's maxing out on query throughput, yet my DB isn't even close to being maxed.
I am using the Pomelo MySQL connector.