.22 Plinkster has a video showing .22 LR out of a handgun going through 12 sheets of drywall. Drywall isn't going to stop much of anything, so one may as well use something with more power then a rimfire handgun.
