Should I be trying to have more sex?

My life is in a circle of frustration. For the past two years, I've been having little dry spells with my husband. The thing is, every time we have sex I am left feeling sore for about a week, and then from that point on I don't want to have sex because I remember how much it sucked afterwards. I thought I read somewhere that women who wait too long to have sex make it harder for their vaginas to idk enjoy sex or something. Can anyone back this up?