network-programmingado.netentity-framework-coressmsdatabase-performance
C# .NET Core EF or ADO.NET query takes minutes and SSMS just 30 seconds, why?
So yeah, I'm currently stuck on a simple code that my app should do pretty quickly, considering the same query runs in SSMS in about 34 seconds and uses around 90mbps:
But then, look at what EF does while running the same query:
Not even using ADO.NET makes it go as fast as SSMS. What gives? I've yet to try this with .NET Framework. Currently using .NET Core 3.1. Is this a bug?
Any pointers are greatly welcome, thanks in advance!
Solution
For those who encounter the same issue as me: The issue was because I was (rightfully) using MultipleActiveResultSets=true. Turns out I'd have to disable it for this specific bit of code, then I can resume using it. Thanks to @Reza on https://stackoverflow.com/a/51824444/1598811 for that suggestion :)
- Fiddler: Where to add IF statement for m_SimulateModem?
- Can someone explain what a wire-level protocol is?
- OS appending IP header even with raw sockets and IPPROTO_RAW
- Board Game in Unity using Photon Fusion
- Connection Refused with TCP socket Error # 10061
- Capturing mobile phone traffic on Wireshark
- How to expose a Docker network to the host machine?
- Deleting an Azure Loadbalancer Frontend IP configuration from python?
- Nat Gateway Profile for AKS using terraform
- EC2 can't get a public ip address after stop-start
- How to detect top legit search engine bots?
- Network Link Conditioner seems to have no effect on network behavior on Lion, Mountain Lion
- Set time interval between loops in tcpreplay
- What are the chances of losing a UDP packet?
- What is the correct way to use RPCs in C# LiteEntitySystem
- Docker host network container service access under Windows
- tcp stream replay tool
- Should you deploy django with wsgi?
- TCP: How are the seq / ack numbers generated?
- iOS Marvel API: How to get all Characters
- RabbitMQ - How to connect RabbitMQ which is installed on other server (PC)
- whatsapp sniffing ssl traffic with wireshark
- How do I convert a network address with mask to CIDR-notation using PowerShell?
- Handling multiple WebSocket write requests in a continuous loop with Boost.Beast
- next/image not consistently loading when used within a docker container?
- Socket duplication when forking a process in C
- nginx redirecting all subdomains (when it shouldn't)
- How to pass a variable list to another play with different hosts
- Tell whether a text string is an IPv6 address or IPv4 address using standard C sockets API
- Azure Container Registry not accessible via private endpoint [403 Forbidden]