core error

5 tips for MySQL performance

Posted on: 18/07/2011

SELECT id, tip_text FROM tips ORDER BY importance:

  1. Denormalize! always design your tables thinking of performance, not in space
  2. Use the slow query log
  3. Avoid wildcards (%) in the beggining of a LIKE statement
  4. Learn how to use EXPLAIN the best way
  5. Use MyISAM if you know that the data in the tables is not very dynamic (i.e. a reporting system)
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


    • Justin Cooney: Great comic, this made me laugh!
    • Justin Cooney: Interesting, I didn't know about the Google App Engine, I'm glad I found your article on it!

    Categories

    %d bloggers like this: