When does it get good?!

I'm a 22 year old woman new to sex. I've only had sex twice, the first time it didn't go in all the way but my hymen broke and it was painful. The second time was with a new partner and someone I really like, and it was a mix between pain and feeling good, but the pain wasn't unbearable. When will it start to feel better?