Nov 22, 2008, 11:35 by BarryCarlyon
It was really good, as an amateur to Regex it was good to see it explained better than any resource I have found online so far.
MySQL EXPLAIN: Explained
Adrian Hardy (Nov 22, 2008 at 06:00)
Talk at PHP North West 2008 (English - US)
Once you have your query returning the correct results, speed becomes an important factor. Speed can either be an issue from the outset, or can creep in as your dataset grows. Understanding the EXPLAIN command is essential to helping you solve and even anticipate slow queries.
Quicklink: http://joind.in/82
Comments
Nov 22, 2008, 11:36 by BarryCarlyon
Whoops wrong talk.
But this one was good too, I never knew about EXPLAIN, so was happy to see a talk on something I knew nothing about.
I'm sitting and starting to debug my queries on my website now :-)
Nov 22, 2008, 11:49 by budda
Wish talk was longer ith more info about mysql optimisation in general :-)
info in 30 minutes was helpful though
Nov 22, 2008, 13:16 by Anonymous
Very informative, and pointed out things that i didn't realise where there!.
I'll definatly be reading the slides again, when they get posted ;)
Nov 22, 2008, 15:44 by matason
Thanks Adrian,
A most excellent talk, very well presented with good slides.
I'll look forward to using EXPLAIN :)
Thanks,
Chris
Nov 24, 2008, 09:21 by GingerDog
Useful talk - if only it had been longer! :-)
Well presented and good content.
Nov 24, 2008, 11:57 by Anonymous
Excellent.
Good content presented well - I enjoyed it, thanks Adrian.
Nov 25, 2008, 09:00 by zedzdead
Excellent talk. With such a lot to get through in the 30 min time slot I felt that this talk could have replaced some of the hour ones, giving the speaker time to 'explain' in a little more detail.
Nov 25, 2008, 09:10 by am_doherty
A very coherent, well presented talk with lots of practical examples. Seeing the performance boost you get from these simple steps was pretty stunning too. I look forward to putting the practices described to use.
Nov 26, 2008, 09:04 by Anonymous
Very nicely put together. Shame he only had a 30 minute slot!
Nov 22, 2008, 11:33 by Anonymous
It was really good, as an amateur to Regex it was good to see it explained better than any resource I have found online so far.