Architecture ASP NET MVC project

3

What would be the best way to store user files according to the requirements below:

  • The user can send one or several files at a time;
  • The types of files supported by the application are: mp3, jpg, png, xls, doc, ppt and pdf;
  • The architecture is all based on WCF services where there are 2 projects. The UI project that is done in ASP NET MVC 4 with the framework version 4.5 and the WCF project also in .NET 4.5. The database is Sql Server 2012;

My question is this: Given this scenario what would be the best way to store these files? Serializing the files and storing in the database, save the file direct to the server hd (common upload) and store the basic file information to relate to a user or work with FileTables of Sql Server 2012?

    
asked by anonymous 27.03.2014 / 02:50

1 answer

4

I work with this type of information daily and I can say that it is ideal to have the files saved on a file server, saving them in a folder structure that makes it easier to search for them, and in the database point to that directory . It is also worth reviewing the file server structure, preferably working with at least two HD's in RAID or keeping another server synchronized to perform redundancy and provide a first-rate service.

If you choose the other option, it will soon fill the data limit established by the Express version and you will have to buy another version.

    
27.03.2014 / 03:19