Membrane Sweeping

Can I get some experiences on membrane sweeping? My doc offered to do it at my next appointment. I'll be 38+3 at that appointment. She told me it'd make me go into labor within 24 hours but from research I've done since, it says it could be hours, days, or weeks still, and sometimes isn't effective at all.

Wondering about pain, infection risks, when you had it done, how long it took for you to go into labor, and how you went into labor (water breaking vs contractions).

Thanks ladies!