I have a new i5 that's way faster than my old i7.
It's going to depend on the software you're using. It might be a big difference, or it could be zero difference.
If you are comparing processors from different generations, the newer one will most likely be better.

As fast as my i5 is, I certainly wouldn't spend the money for an i9.