I'm on a team working on developing new Windows applications. We use EF6.
At this point I'm still working from home. I've noticed that under certain circumstances, the query I run using EF6 can take 1 to 2 minutes to finish. It's querying four tables together using Include statements and Select to get a grandchild table. However, it doesn't run that slow for other colleagues. For some of them it runs acceptably fast.
Nevertheless, I'm concerned that performance for the users might be unacceptable. In thinking about this I can see various places where the performance might be affected.
My ISP (although I do have fast connection for my state)
The work laptop I'm using (it's older)
I am pulling down 38K records
This got me to wondering, when using EF6 where is the processing of a query performed? Does it happen at the server? Or is EF6 doing the heavy lifting on the client's machine?