Buy Percona ServicesBuy Now!

Explaining Indexes with a Library Metaphor

 | August 30, 2011 |  Posted In: Insight for Developers, MySQL

My favorite metaphor for explaining indexes is comparing them to index cards in an old library. In an old library, you used to (or still do) have index cards at the front desk which have some brief description of the books in the library. They also used to be categorized alphabetically. (image taken from […]

Read More

Preprocessing Data

 | August 8, 2011 |  Posted In: Insight for Developers, MySQL

There are many ways of improving response times for users. There are some people that spend a lot of time, energy and money on trying to have the application respond as fast as possible at the time when the users made the request. Those people may miss out on an opportunity to do some or […]

Read More