Looking at the technicalities, the shot is to the heart, if done correctly unconsciousness should be within seconds, but I guess the worry is if the heart is just missed, that could leave the recipient in major agony for quite some time. I've read that the electric chair produces unconsciousness in a fraction of a second, and lethal injection puts you to sleep before the fatal dose is administered but both have gone badly wrong before.