MySQL Tips & Tricks

Part of MySQL

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);

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