I am planning to synchronize around 200 very small files per hour (less than 1KB each file), the source files are on a remote SFTP server and the destination files are on a Windows Server. My fear is the too many connections that I plan to do to the SFTP server (every 10 seconds) to have a near-real time experience.
According to other questions I plan to use WinSCP Synchronize feature and Windows Task Scheduler (to execute a WinSCP script) but as I said I will have to execute it every 10 seconds to have a timely result and the server resources is a constraint.
Any other ideas on how much load will this excessive SFTP connections will mean to the server? Or any suggestion on a better way to keep those folders in "sync". Thanks in advance for any valuable idea.