Thanks for all of your replies!
So I agree that the bacteria colony will grow to meet the amount of waste in the water but wouldn't the colony be bigger with a slower turnover as more would be required to keep up with the amount of waste in the water?
One of the things that determine beneficial bacteria robustness' is how aerobic the conditions are .
The higher the dissolved oxygen in water, the more robust the beneficial bacterial population.
In some cases this might mean the faster the water moves the better. Although that is not always the case.
Fish like trout prefer colder fast moving streams, so dissolved oxygen is high in those conditions.
Some twarm water ropical species are also rheophillic and come from areas where strong water movement increases the oxygen level, such as many Geophagines, Tommocichla and Hydrocynus.
There are also many species that don't need that movement , and do well in more sedate conditions, Anabanids and others that are able to make use of atmospheric oxygen come to mind.
Water movement is more about what species you keep, than some generic water movement formula.
I keep rheophillic species so I try to match their specific natural flow conditions.
This is the river where I catch many of them.
So this is the flow from my sump to the tank
.