Our all files were as blob datas in the database. And obviously it was horrible writing or reading large files with that way. So we created Restful API to write files to the file system of the server and all of our programs used this api to save or get files. But this way also is problematic. Because there are lots of concurrent file transfer requests and our server’s operating system is windows. So it causes delays, timeouts, data loss and etc. when transferring the file. I want to know what is the best pratice of working with files?
Source: Windows Questions