Anyone else keep working on something just because you started it?

When I started I thought consistency meant never giving up. If something wasn’t working my first instinct was always to try harder and give it more time. But sometimes more effort doesn’t really change the outcome. It just makes it harder to admit that the idea direction or approach might need to change. How do you know when to keep pushing and when to let something go?