Does sex, like other things, get boring if you do it too often? How does it affect the relationship?

Does sex, like other things, get boring if you do it too often? How does it affect the relationship?