That's why you should tweak it..
In the example R0J0hound posted changing RES to a higher number will reduce the amount of sprites created..
I'd disable collisions for sprite2 in it's properties if you are never going to use them..
You could fade out faster so the tail is shorter..
All these things can reduce the impact it has on performance..