Data Archiving

Difficulty: Intermediate

Question

How do you handle extremely large tables that are years old?

Answer

Implement data archiving: move old, rarely accessed data to a separate 'history' table or a cold storage layer (like S3) to keep the main table fast.

Concepts covered

Maintenance, Storage Cost