When does sex STOP hurting?

i lost my virginity ant it hurt SO BAD. then we tried again a couple days later and when it went in like half way it still hurt then i started bleeding. so i wanted to stop. i figured that my hymen broke. so since it's broken when; will the pain stop and it starts to feel good?