Lookups And Batch Processing
If you have enabled Batch Processing on any blocks in your flow, best practice is not to use a Lookup block. The Lookup Block and Lookup Functions do not support batch processing. Lookups significantly reduce the performance of Batch Processing, because they must retrieve information one record at a time from the selected entity. The diagram below outlines the progress of a flow that contains both a Lookup block and an Update block with Batch Processing enabled. Steps 2 through 5 are performed one record at a time, which slows down the process of integrating data into the target.