0

Possible Duplicate:
Storing Images in DB - Yea or Nay?

In terms of performance, scalability, etc.

Community
  • 1
  • 1
h3n
  • 5,142
  • 9
  • 46
  • 76
  • 1
    Duplicate of: http://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay, http://stackoverflow.com/questions/815626/to-do-or-not-to-do-store-images-in-a-database and many more questions – PHeiberg May 19 '11 at 10:21

1 Answers1

0

Don't save to the DB. You will regret it.

The file system is the best place for storing binary files. It's built to do it.

I've had my fingers burned before, writing a CMS system that stored files in the DB. The result was:

  • Massive increase in traffic between the web server and the database
  • Slowdown in database performance
  • Massive increase in the size of the database, resulting in a backup headache

Generally speaking, manipulating binary files on the file system is easy. Using DB tools like SSMS, it's a nightmare.

James McCormack
  • 9,217
  • 3
  • 47
  • 57