Read other TriBlogs
TriBlogs & Me

MySQL Indexes

Oziemby OziemApr 20th 2009
Have been developing our coaching system for the past week or so. Other web developers might be interested in something I found out today.

Had look at optimising some of the SQL we use on the site because some of the coaching pages take to long to generate. Selecting the latest session recorded for all the athletes of a coach took about 8sec (the training table currently has 102189 rows)

Found an excellent blog post on optimising MySQL using indexes recommend to other developers when you have massive tables! Basically, by indexing the column which is used in a ORDER BY I reduced the query time to less than a second. "Huzzah!" ;)
TriBlogs & Me
TriBlogs has been my pet project since 2005. It all started as a way for me to track my own training and I ended up sharing with my friends... the rest is history.

I write the code, test the code, debug the code, sing the theme tune... Sarah has joined the team now and she bosses me around on your behalf. If you use the site regularly and love it please help us continue by subscribing or by getting all your friends to visit the site!

On my blog you'll find my experiences attempting to be an athlete of some sort and my photo blogs of races that we visit for inspiration.
Blogging Service, © TriBlogs Join TriBlogs to post comments and/or create your own blog, all for free! Read other Triathlon Blogs