While I pack a Glock most of the time (.40 S&W and 8-9 shots) I also pack a J .38 at times due to dress codes (5 shots and very slow reload.)
If you wish to pack a revolver, that is fine. Practice till you are very good with it.
Spend less time on things like speed loading and more in good hits (in fact no matter what you carry it's good hits that count.)
A good revolver, like one of these:
Will do quite fine. Perfect in my opinion (but then these four above are all mine!)
Like I said, practice till no matter how fast or slow, far or near, you get good hits with your chosen weapon.