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.
Example:
ALTER TABLE table_name ADD INDEX index_name (column);
Enforce Data Integrity at the DB Level
Eg.: unique constraints, cascade deletes
Pros: Application agnostic Data Integrity
Cons: -