...
Cache Size and Segmentation
The Indexing Field of incoming UDRs should preferably be either an increasing sequence number or a timestamp with good locality to preserve performance of workflow executions.
For large cache sizes, it may be a good idea to split them to multiple workflows in order to preserve performance.
For large cache sizes, splitting batches of incoming UDRs into multiple transactions may improve performance of workflow runs.
Minimizing the cache size may improve the performance of the duplicate checks by the Duplicate UDR agents and the speed of Search and Delete operations using the Duplicate UDR Inspector.
...