Tips for efficient flow design
Posted: Mon Jun 02, 2025 4:26 pm
I have about 60 flows running on our server and it's getting more unstable over time. I need to restart once or twice a week or processing slows to a crawl. The VM is not powerful enough (Only running 12 GB of RAM and older processors), but it's a struggle to get more virtual resources from IT. Even with no jobs running through the system, processor is between 60-80% and memory is about 85% utilization.
I'd like to know if Switch needs to run on its own server, or if it would be possible to run it on a much more powerful server along side my MIS software. (That server has 256 GB Ram and 56 CPU cores.) Definitely more power available there, I just don't know if Switch is designed to run alone or if it can coexist well with another big app.
Either way, I'd like to get some tips on optimizing my flow design. Is it better to have more flows with less elements, or consolidate them into fewer more complex flows? A lot of my flows are 50+ elements now. Are there any guidelines on how complex a flow should get before splitting it up? Are there changes I can make to my preferences to help Switch stay a little more stable? I build SQL statements with multiple checks to create metadata and sort jobs in flows, but some of my older flows use multiple conditions in 'Condition with variables defined' instead. Is it better to use SQL statements or scripting to replace these multiple condition checks? Any other things to watch out for?
Any tips / tricks / guidance would be appreciated!
I'd like to know if Switch needs to run on its own server, or if it would be possible to run it on a much more powerful server along side my MIS software. (That server has 256 GB Ram and 56 CPU cores.) Definitely more power available there, I just don't know if Switch is designed to run alone or if it can coexist well with another big app.
Either way, I'd like to get some tips on optimizing my flow design. Is it better to have more flows with less elements, or consolidate them into fewer more complex flows? A lot of my flows are 50+ elements now. Are there any guidelines on how complex a flow should get before splitting it up? Are there changes I can make to my preferences to help Switch stay a little more stable? I build SQL statements with multiple checks to create metadata and sort jobs in flows, but some of my older flows use multiple conditions in 'Condition with variables defined' instead. Is it better to use SQL statements or scripting to replace these multiple condition checks? Any other things to watch out for?
Any tips / tricks / guidance would be appreciated!