Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 5
Impact
~4k people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Aug
20
awarded  Notable Question
Jan
24
awarded  Popular Question
Dec
15
awarded  Announcer
Dec
15
awarded  Scholar
Dec
15
accepted Why does this Entity Framework query perform so bad in MySQL?
Jan
22
comment Why does this Entity Framework query perform so bad in MySQL?
Well I don't have another database with this much data in it. So I can't really test under same circumstances. :(
Jan
21
comment Why does this Entity Framework query perform so bad in MySQL?
I would get the plan, explain won't execute because the query always times out. Is there anyway to get a plan with out having it execute the query?
Jan
21
comment Why does this Entity Framework query perform so bad in MySQL?
As I said /* farther down and later on in the code */ they are broken apart, so yes combining it like that would fix the problem, but because of how the request is structured I don't have this luxury. Because the OData provider adds the OrderBy and Take parts on. I was trying not to get too technical about the program process, because it really didn't matter. But that comment I put between the two statements is actually happening through an OData REST request. So everything after the where statement I have no control over.
Jan
21
awarded  Student
Jan
21
asked Why does this Entity Framework query perform so bad in MySQL?
Jan
21
awarded  Autobiographer