I did not have any pain or problem at all with the lumbar puncture itself. BUT, I did get the headache that some get after it. The place that did it, did have me rest and lay flat for 1 hour after the procedure.
I had to go back and get a blood patch due to the extreme headache. I was told at Mayo (where I had it done) that it was usually women of menstruating age, that were most likely to get the headache. (that was me--yay).
and yes.....it was caffeine tablets that FINALLY got rid of it, that and laying flat.
good luck with the procedure.....as long as you don't end up with the dreaded headache, it isn't bad.