"Painful hysteroscopy"

My hysteroscopy was extremely painful and I vomited several times afterwards, the nurse doing the procedure was learning but was very nice, my womb is tilted and they had trouble finding my cervix, I haven't had children so assumed that was why it hurt so much. I thought this is how childbirth must feel but ten times worse! ! But I have read some women say its a worse pain then labour, I did have a local anaesthetic, but I don't think it helped one bit, I pity women who haven't had any pain relief ....Needless to say I don't want another! I think the procedure should be done under general anaesthetic.