D&C - Painful?

Ladies, can you please tell me your D&C experiences? How long did it take? Was it painful?