MySQL Query Optimization Best Practices and Indexing [eng] / Alkin Tezuysal 

honestly feels more like an AD for his company than helpful

I was hoping to see some practical troubleshooting on an actual sql query but it's just a check list of thing to watch for. Also the part of doing sorting paging in the application side does not make sense to me, if you do paging it's because you have large dataset and there is no way to do that on the application side without sending all the rows, I don't see how that could work better than doing it directly in the db.

спасибо

dude says he has 23 years exp.but cant explain anything properly..looks unprepared

Well this was a waste of time..

Выключил нихера не понятно