Basically my theory is that the dreaded "Infection" that arises in hospitals is partly due to the fact that most wells output "stagnant water." I noticed that whenever wounded dwarves were given water in one of my forts that they left buckets full of stagnant water and had much unhappy thoughts from this. One day, I remembered that pumps desalinate water when pumped into an entirely artificial cistern. I also knew that this now desalinated water was always just "water" and never "stagnant water." So, I proceeded to do a little test using a murky pool (which a previous well had drawn stagnant water from as a check.) I pumped from that pool into my artificial cistern, built a well, and saw that it did indeed draw clean "water." Now to perform tests with injured dwarves which is the more difficult portion of testing.
To effectively test this, I will need to construct two sets of wells, one which will draw stagnant water and one which will draw water in the same fort. Then wound a number of dwarves (I am thinking 10 wounded to 50+ healthy with at least 2 dwarves on each medical labor to allow for breaks.) Immediately save after wounding the dwarves, then copy the save. Allow one fort access to the stagnant water by walling off the clean well and allow the other access to the clean water by walling off the stagnant well. Save and copy each fort again, and distribute the copied saves (so the other samples do not need to go through the process themselves.) Now run each save for about 1-2 years. Note how many dwarves receive infection in each fort, repeat. Have others do the same, then try it with soap in each hospital and note the results. My plan is to eventually get a definitive result wiht how to effectively treat wounded dwarves. I just need to figure out how to wound dwarves reliably without fatalities...so far it seems like a fall would work nicely...
If anyone wants to help me with this it would be much appreciated!
(also, the hospital would be fully stocked with supplies and I intend to have enough buckets produced that the doctor wont have issues with no buckets working. maybe the stagnant water causes issues with the reaction. I dont know...)