The Taurus 24/7 Pro Compact is a fairly small thing:
I personally like Small-Of-Back holsters. I know many will say they're a terrible idea, but they work for me -- and I don't do any wrestling around on the ground, so the whole "you're gonna break your back" thing reminds me of "A Christmas Story."
Another option is to try your IWB holster in the SOB position, or just to the right or left (depending on your strong hand) of your spine. I find this makes things much more comfortable.
I also find shoulder holsters to be extremely comfortable. I bought a DeSantis Patriot because, well, it was cheap, and I wasn't sure if I'd like a shoulder rig. I picked it up at OpticsPlanet.com for significantly less than MSRP.
FWIW, I'm regularly concealing a Stoeger (Beretta) Cougar 8040. This is
NOT a small weapon, being basically a short-barreled Beretta 96...
I'm 5'8" tall and lugging around 220ish pounds.