Hi,
I am experiencing an unexpected/unpredictable SLOW performance in my flow that having Gateway to connect MS SQL Server and/or File System to do operations. A simple DB query or write a simple string to a file in File system may spent few minutes to complete the actions.
e.g. This "File System - Append file" action, I simple append a text to a Text file through a Gateway, it tooks from 0s to few minutes to complete.
e.g. This "MS SQL - Create record", I created a record in a table through the same Gateway, it tooks from 0s to few minutes to complete too.
Do you have idea what's wrong? Anything I can do to improve performance?