I find earring so sore after wearing them for only ten minutes and for days after the site feels tender.
I have found that soaking the metal bit that goes through the ear in TCP for a minute then thoroughly drying before inserting can give a little relief. But it's not great.
I've just had my hair cut short and would really suit earrings now. I also have a small bit great collection as I love them but do I have to endure this pain to wear them?
I really admire and worship people who fall asleep with earrings in because they have forgotten they were there!