Go read Inside LiveJournal's Backend for an excellent real world study of how to handle very high levels of traffic.