Yes, a discogram is a terrible thing to go through. If you truly have torn discs then it will most definitely be the most painful experience of your life. And after the test, the pain will be awful. I was in bed for 3 or 4 days bc I could not walk.
Don't do it unless you have to.

Good Luck!