The job they are tasked with, is impossible, and if it were possible, no one would want that sort of police presence and intrusion in their lives.
(The real fix):
The only real fix is to have multiple concealed and armed teachers/staff (volunteers: vetted/selected and trained).
That way you have someone in proximity of where anything could happen. A single cop cannot be in 5 or 6 places at the same time and many of these schools are large, with multiple floors and many rooms...
Likewise, the police cannot really react to the situation fast enough (time to get there - the shooting is often over within a few minutes) and if they do try to rush things when they get there the chances of something going wrong are very high.
The single school resource officer as today is the norm, is an illusion, just like the TSA. It's eyewash for the masses and the sort of junk you expect from the bureaucrats and politicians today that always want to show “action” after a crisis.
If you have a real shooter intent on doing harm, this resource officer will be the first target, and he'll be an easy target (you know who he is - and it's easy to get close to him or behind him...). He would be the first to get shot and maybe even provide a thinking shooter another weapon, more ammo, body armor, a radio to listen to...
My arming school staff (select volunteers) you have enough people spread out over the area to guarantee a rapid response, they know the facility, the shooter does not know who they are (can't take them out in a first strike - shooter has threat from all directions at all times). The resource officer is now part of the selection, training and planning process for the school first responders. He might even be more effective in such a scenario.
The solution is obvious from a tactical viewpoint.
But this is an emotional issue and the solutions need to be in line with what emotional people want/expect. Do not expect this issue to get fixed. But we'll blame lots of people: police, guns, the NRA, violent video games, loss of God, broken homes, psychological drugs, even toxic masculinity... Blame blame blame... Do nothing practical, we haven't yet, and it's been ~22 years since this issue has been highlighted.
“(The real fix):
The only real fix is to have multiple concealed and armed teachers/staff (volunteers: vetted/selected and trained).”
The REAL fix is to return God and prayer to the schools.
RED FLAG LAWS: INNOCENT PEOPLE WILL DIE! 7 minute video!
THANK YOU RINOS!
https://www.bitchute.com/video/Elq3P5UPmJCl/
Hard data to support your “armed teachers” position, courtesy of John Lott:
https://freerepublic.com/focus/news/4069868/posts?page=4
Texas law allows for that. My school district does it. Uvalde chose not to.