There will be an optimum point of effectiveness. The sweet spot where the amount of effort invested produces the optimal return. Improvements continue with more effort invested, up to a certain point, after which you will break.
Of course, there is also a dose response and overload repair argument going on, but most of those are only relevant in athletic or persuits where physical performance is paramount.
This also, I realise, is the same for medication. Too little paracetamol is ineffective, too much leads to liver failure. Just right leads to resolution.
To identify your dose, first choose your objective. Then look at the input parameters, and define the ones you can control versus the ones you cannot. Read what previous people have found efficatious. Sit down and chat with an expert. Then apply, record, reflect, review. Consistency is key.