This sums it up very well.
https://www.luckygunner.com/labs/sel...llistic-tests/
Conclusions
Looking at all of this data, it’s tempting to try to sift through the numbers and determine once and for all which load is The One Bullet To Rule Them All. If that kind of data analysis gets you excited, then go for it. If, on the other hand, you just want to find a decent load for your carry gun, you probably don’t need to go through all of that trouble. To the contrary, we did all of this work on these tests so you don’t have to obsess over the ballistic performance aspect of your carry ammo.
If the self-defense load you use is listed here, and you’re not confident in the results you’re seeing, just pick another one that performed at a level you’re more comfortable with. But keep in mind, even though the gelatin tests can tell us a lot, there’s plenty of things they don’t tell us. Ballistics testing doesn’t tell us anything about the felt recoil of a load. We also haven’t addressed accuracy or muzzle flash (which can be an issue in low light). And maybe most important of all, no gelatin test can tell you if a given load will run reliably in your own self-defense pistol. This is all stuff you’ll have to test on your own at the range with your gun.
Once you find a load that works, whatever you decide, try to keep all of this in perspective. Choice of caliber and bullet are not the most important aspects of successful self-defense. Awareness, proper mindset, marksmanship, and discernment of when to use your firearm are generally far more critical to your survival than choice of gear. Having said that, knowing your carry ammo works not only provides peace of mind, there’s a chance that choosing a solid defensive load could be the one factor that tips the scales in your favor in a fight for your life.