It depends on the over-clock yield and how sensitive the application or game is to shear clock speed of the CPU.
That being said, if you haven't taken measures to deal with the heat generated in an over-clocked CPU, you could actually degrade the performance of your application or game.