An INSERT trigger fires once per INSERT statement, regardless of how many rows were INSERTed by that statement. If you INSERT 100 rows as 100 separate INSERT statements, the trigger will fire 100 times. It would be far more efficient to INSERT 100 rows in one operation, if possible; then the trigger would only fire once, and it would affect those 100 rows as a batch.