Database Performance: Pay Me Now or Pay Me Later

"Many database performance decisions come down to "pay me now or pay me later." Some decisions will produce faster inserts and updates at the cost of slower and more complex reads, while other decisions will slow down inserts and updates but provide faster and easier reads. "

http://database-programmer.blogspot.com/2008/07/database-performance-pay-me-now-or-pay.html