Custom code patterns, governor limits, async processing, and unit testing.
Newer trigger handler frameworks split things up by feature. Curious if anyone has pushed back on the classic single-trigger guidance.
Need to recompute a derived field on ~1M records nightly. Batch Apex has been fine but I am hitting heap limits on the post-processing. Looking at queueable chains.