Rob's tech blog...

 

MySQL Indices - what, how and when

 One simple area of MySQL optimisation that is often overlooked is indexes* on tables. Basically an index is a sub set of the data that allows the MySQL engine to match against values much faster than normal. In short, it speeds up the sorting of data and therefore reduces the time it takes to return results and the load on the server as a result.

Read the rest of this post »

Filed under: Development Sys admin admin dba index indices mysql optimisation performance
11
To Posterous, Love Metalab