To those saying it doesn't. 5.7 does in fact have more pentrative power than other equivalents. A FN 5.7 will shred a vest much quicker than a 9m would. The ammo is literally made to function like a rifle round. I have seen demonstrated examples of 5.7 piercing armor that a 9 or 45 had to punch through. Speed=penetrative power.
There's a few more details of the staff relative to the P90. P90 is a projectile weapon with a ton of logistics attached, designed to be fielded in large numbers by trainable soldiers solely for the purpose of engaging other people with similar weapons. The staff on the other hand is a technological artifact and a symbol of religious dominance. It is meant to look like, and act like, magic, when dealing with primitive people whose whole purpose in life is to just survive hard winters and make sure their God doesn't kill them. Given that the Goa'uld are essentially invulnerable to their own weapons anyway, they don't really care how long they last. They kill any attempts at science amongst the Jaffa at their whim. They have priesthoods who can maintain the weapons, but it's closer to a religious ceremony than anything approaching engineering. So, if you want a weapon that is given like a gift, has a tremendous amount of effectiveness against primitive peoples, does not permit its user to understand how it works, is simple to use by primitive people, and essentially lasts forever whilst being competitive against the handful of civilizations that can actually fight the Goa'uld, then that weapon looks pretty much exactly like the staff weapon.
Not the first time I've noticed how Amanda Tapping took the show's weapons training seriously. That flinch seems like a genuine reaction and not a scripted one.
Kinda cute how they're like "Behold, the mighty submachine gun, effective up to 200 yards if you're a really good shot and your target is only wearing a thin shirt" Meanwhile the Barrett M82 "Am I a joke to you?!" xD
SG-1 member Captain Carter did a firepower demonstration with the P90. And when she fires full auto you can see the function of the two stage auto position trigger. squeeze the trigger easy for semi and squeeze the trigger hard for full auto
Is it me, or Teal'c literally gave a signal to O'Neill ? I never noticed this before but, at 1:24 you can clearly see Teal'c nod to O'Neill. Therefore he actually planned of becoming the Shol'va when he first saw SG-1. Which is confirmed in Threshold, on the last scene that replays in his conscience in a talk with Bra'tac about SG-1 and Jaffa freedom.