325 reputation
314
bio website dotancohen.com
location
age 36
visits member for 2 years, 11 months
seen yesterday

Jul
28
awarded  Notable Question
Jul
28
comment Why would SELECT * be magnitudes faster than SELECT foo?
Thank you for the insight.
Jul
28
awarded  Popular Question
Jul
28
awarded  Nice Question
Jul
27
comment Why would SELECT * be magnitudes faster than SELECT foo?
Thanks, horse. That was in fact the issue.
Jul
27
comment Why would SELECT * be magnitudes faster than SELECT foo?
Sometimes the trickiest questions are those which are just staring us in the face. Thanks, Michael!
Jul
27
accepted Why would SELECT * be magnitudes faster than SELECT foo?
Jul
27
asked Why would SELECT * be magnitudes faster than SELECT foo?
Jul
10
awarded  Popular Question
Jul
3
accepted SELECT query with referenced subqueries
Jul
3
comment SELECT query with referenced subqueries
I would need to script it to run for each status individually (more than the two shown above, OP mentions that) and at the table sizes that we are talking about (100,000 rows, OP mentions that) a temp table is not feasible.
Jul
3
comment SELECT query with referenced subqueries
Thank you. Though this solution is completely infeasible, +1 for demonstrating that at least I'm not missing something simple!
Jul
3
asked SELECT query with referenced subqueries
Jul
2
awarded  Curious
Jun
19
asked ON DUPLICATE KEY UPDATE faster than UPDATE
Jun
16
awarded  Popular Question
May
5
comment MySQL Enums have non-intuitive behaviour, why?
Thank you. Now it all makes sense: the author of that post, like most PHP devs (yes, I am among other things a PHP developer as well), does not understand datatypes. I'll be sure to pay special attention to this in the future. Thank you!
May
5
accepted MySQL Enums have non-intuitive behaviour, why?
May
5
revised MySQL Enums have non-intuitive behaviour, why?
Link to fine manual
May
5
asked MySQL Enums have non-intuitive behaviour, why?