I had mine done when I was 6. So if it was painful, I should remember the experience. I don’t. It stings for a couple of seconds and then goes away. I agree with BaalHabooze. My girls look beautiful without earrings, and I have the added easiness to my life of not having to look for lost earrings or fret about holes closing up.
As a nursery teacher, I have seen many girls who have lost an earring but their mother leaves the other one in so the hole doesn’t close up. Why make life harder for yourself.