Which is better option to store files in File System (Disk) or Database in ASP.Net

Last Reply on Aug 29, 2013 01:44 AM By Mudassar

Posted on Aug 29, 2013 01:39 AM

I am working on a journal website where user submit manuscripts , pdf files , is it good idea to store pdf files on directory or on database.



Posted on Aug 29, 2013 01:44 AM

Both have advantages and disadvantages


1. You need to convert to binary and store and then again convert

2. Increases database size

3. User cannot view file on server directly thus an added security

4. Can be slower process to get it back from database



1. I recommend to store files in folder and their path in database

2. Easy to implement and does not increase database size

3. No conversion process

4. Will be faster

5. User accessing server can view files, so if not secure you can use it