Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
4
Newest
 Editor
Impact
~1k people reached

  • 0 posts edited
  • 0 helpful flags
  • 2 votes cast
Aug
16
comment query optimization of a left join
Yeah those are set according to the mysql turner script. . Also please note that all i want to do is count the number of users who has a photo. May be there is a another way to fo the same
Aug
16
comment query optimization of a left join
Also in addition please note cant be a problem with the resources it has 32GB memory and 8 cpu hosted only this website with max only 100 users per time.
Aug
16
comment query optimization of a left join
i have added the "Explain Query output" as well to the question
Aug
16
awarded  Editor
Aug
16
revised query optimization of a left join
added 84 characters in body
Aug
15
asked query optimization of a left join
Jul
13
awarded  Popular Question
Jul
10
awarded  Supporter
Sep
26
awarded  Student
Sep
26
asked Does TRANSACTION/COMMIT/ROLLBACK only work on certain MySQL engines such as InnoDB?