Here are some excerpts from the experts who experimented over a 170 years ago and blew up a lot of guns.
"Another advantage of using gunpowder of a suitable granulation is the absence of sharp recoil; and thus greater accuracy of range is obtained—accuracy of range and steadiness of weapon being inseparable.
Large-grain gunpowder is not only a more effectual expellant than the fine grain, but is much more safe to use, for by using it the risk of bursting the barrel is much lessened; as a very simple illustration will show. If we estimate the force generated by the usual charge of 21⁄2 drachms (I confine the question to the 14-bore gun, for uniformity) to be 5,000 lbs., whether the powder be fine or coarse grain, it follows that the fine powder, igniting so rapidly, will exert all its force on the breech end of the gun; whereas the coarse powder, igniting less rapidly, distributes this force over the whole length of the barrel: hence the greater risk of a gun bursting with fine powder than with coarse. If we suppose the fine powder to be entirely ignited when it reaches half way up the barrel, then the force of 5,000 lbs. is exerted on the lower half of the barrel; but if the coarser grain is not entirely ignited until it reaches[36] the muzzle, then the force of 5,000 lbs. will be distributed over the whole length of the gun.
Fine grain, when unconfined, explodes quicker than large, or is sooner burnt out, and consequently generates more force in the same period of time; but when it comes to large quantities, its very quickness is detrimental to its force, by condensing the air around the exterior of the mass of fluid which thus constrains its bound. In small quantities, the proportion of condensation is not so apparent, and hence the reason why greater velocities can be obtained with small arms than with cannon."
"Another advantage of using gunpowder of a suitable granulation is the absence of sharp recoil; and thus greater accuracy of range is obtained—accuracy of range and steadiness of weapon being inseparable.
Large-grain gunpowder is not only a more effectual expellant than the fine grain, but is much more safe to use, for by using it the risk of bursting the barrel is much lessened; as a very simple illustration will show. If we estimate the force generated by the usual charge of 21⁄2 drachms (I confine the question to the 14-bore gun, for uniformity) to be 5,000 lbs., whether the powder be fine or coarse grain, it follows that the fine powder, igniting so rapidly, will exert all its force on the breech end of the gun; whereas the coarse powder, igniting less rapidly, distributes this force over the whole length of the barrel: hence the greater risk of a gun bursting with fine powder than with coarse. If we suppose the fine powder to be entirely ignited when it reaches half way up the barrel, then the force of 5,000 lbs. is exerted on the lower half of the barrel; but if the coarser grain is not entirely ignited until it reaches[36] the muzzle, then the force of 5,000 lbs. will be distributed over the whole length of the gun.
Fine grain, when unconfined, explodes quicker than large, or is sooner burnt out, and consequently generates more force in the same period of time; but when it comes to large quantities, its very quickness is detrimental to its force, by condensing the air around the exterior of the mass of fluid which thus constrains its bound. In small quantities, the proportion of condensation is not so apparent, and hence the reason why greater velocities can be obtained with small arms than with cannon."