Is the enema painful and how long does it take effect?

Nah not painful - a little odd, uncomfortable feeling, but little pain. labour pain was much worse ;p