So my question is that since the difficulty of mining could increase in the long term, as it has so far, when will the miner,  for example become ineffective or at least when will its output be reduced to less than 10% as of today.

I am trying to calculate and see the net revenue of a single S9 miner (without assumptions of any cost) and need to know until when will it bear fruit.

Thanks