The traditional approach of changing your program every 12 weeks might actually make sense in order to prevent plateaus. However, there is no hard and fast rule.
If you can’t lift heavy or it’s not your thing, please don’t think lifting lighter weights is a waste of time.
