I am looking for the pros and cons of reading each individual file as a stream vs. pulling all the files to a local disk and reading them from there.
In my situation I need to:
- Read the files from a remote server,
- Update a database with information from the files
- Save those files to another remote location,
- Delete them from the original SFTP server.
I know myClient.Download has the ability to perform Tasks 1,3 and 4
in one line of code but then I have to read from another hard-disk (not using SFTP).
so I am wondering of these two methods, is one more performant or reliable with multiple files? Is there anything else I should consider?