Slow Flow Speeds

Unknown

Slow Flow Speeds

Unknown

Hello,

Im having trouble getting reliable output from my flows. I need to run several thousand patients through my subflows but they are running very slowly and sometimes timing out. Im concerned because the volume will increase as I build out more flows and they will need to run in parallel or very quickly in succession.

It seems as though my local memory is determining how quickly the flow runs because Ive had one fatal error that said the system was out of memory and twice the platform lost its connection and couldnt restart. Both of these were seen when running Debug Flow". I also tried running the flow in a new window but it ended with a 504 timeout.

Could you provide any guidance on how to optimize the speed of the flows and ensure they run as expected?

Thanks."

Unknown

A number of things can affect the speed of the flows.

Memory Size
Passing large files through the flows
Etc.

Unknown

Following is the list :

Run Flow for List Batch Processing

• Allows true parallel
• Bundle steps after For Each into a Sub-Flow
  - Behavior Type is Async and Wait
  -Replace For Each with “Run Flow...” step

One Truth table

• ˜69 rows
• ˜25 columns
• Outputting string (same as rule_selector TT) v. Bool
• Flag with error if Mult returns
• Use Integration details to specify JSON and avoid Stringify and Parse steps
  Losing some cycles with CSV to List step
  Redshift Integration will help to allow Query to List