This is an old revision of the document!
MySQL Tips & Tricks
Part of MySQL
Use Indexes
Pros: Massive increase in searching performance.
Cons: Slightly Increase in Storage Requirements. Slightly Increase on Write speeds.
Usage:
ALTER TABLE table_name ADD INDEX index_name (column);
Enforce Data Integrity at the DB Level
Pros: Application agnostic Data Integrity
Cons: -
Instead of:
posts table - post_id - title - author_name
Do:
posts table - post_id - title - author_id authors table - author_id - name