the double action trigger pull of a rimfire revolver isn’t fun. i would look to a ruger sr22, or similarly decent, compact, reliable 22lr semiauto pistol, and put many 100s of cci 1200+ fps practice rounds through it. comfort, confidence and accuracy will win a caliber war.
