I need to process a couple thousand records in ServiceNow. If I create a flow that queries for the records, then processes them in a loop I get transaction timeouts after roughly 250 records. It is considered an antipattern to perform such processing in the workflow engine.

But what is the good pattern to follow?