HTML5 Canvas
Written by: Simon Sarris
Featured Refcardz: Top Refcardz:
  1. Apache Hadoop
  2. Web Driver
  3. MVVM
  4. REST
  5. ADO.NET
  1. HTML5
  2. Ajax
  3. jQuery Selectors
  4. CSS Part 1
  5. Git
150+ Refcardz Available · Get them all

Link Details

Previous | Next

Surprise Me!
Link 16972 thumbnail
User 200638 avatar

By vladocar
via developer.com
Published: Mar 27 2007 / 13:59

Four Ways to Optimize Your MySQL Database
"This process consists of five steps, including Normalize, Index, Cache, and Monitor...."
Vote up
Vote down
  • 10
  • 0
  • 1240
  • 0
SaveShareSend Tags:

Comments

Add your comment
User 60609 avatar

sigzero replied ago:

0 votes Vote down Vote up Reply

You forgot the best way...move to Postrgesql. : )

User 202082 avatar

ancestor replied ago:

0 votes Vote down Vote up Reply

Well, if someone doing some serious work with MySQL doesn't already know everything stated in the article, that someone shouldn't be doing it on the first place.
The article also forgets to mention that, while Indexes are cool, MySQL only uses indexes if they fully match the 'where' clause, so they should be carefuly planned.

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Voters For This Link (10)



Voters Against This Link (0)