Over-the-counter medication can be helpful, but it's just temporary. You should consult with a healthcare professional to get appropriate treatment. If you are in Singapore, I can recommend Dr. Dennis Koh of Colorectal Practice. They will provide a personalised treatment for your piles. I have a friend who had piles before and had it treated by Dr. Dennis Koh. You can look up their clinic's website and book an appointment there.
Nur Ellysa