1

Possible Duplicate:
store image in database or in a system file ?

I am wondering if it is a better idea to save uploaded file into SQL Server. And if it is convenient to download the file stored in DB. If it works, what type of field should I use to store file? Any help is appreciated.

Community
  • 1
  • 1
Steven Zack
  • 4,984
  • 19
  • 57
  • 88

1 Answers1

3

MS research have written up a good white paper on this - To BLOB or not to BLOB.

Give it a read and make up your mind.

tl;dr:

If most of the files are under ~150kb, might as well store them in the DB.

Oded
  • 489,969
  • 99
  • 883
  • 1,009