Saving images in SQL SERVER is a good idea?

Question

Saving images in SQL SERVER is a good idea?

Answer 1

No.

You store the PATH to the image in database, and the image somewhere else.

Answer 2

Storing them directly in the tables? No, it's a horrible idea...it wastes tablespace and slows down query execution. ALWAYS store large binary files and the like in a separate folder in the database's path and only store the relative path to the file in the table row. Once you have that, getting at the image (or whatever) is a minor second step.

Answer 3

no, not what a SQL server is designed for really. store file locations in there by all means though, or HTML which will generate and grab the image from your image store location

Answer 4

NEVER store any large files in a database, it defeats the object of a database which is fast retrieval of data. The correct way to do this would be to store the files in specific folders, and if you do need fast access to them you can then store information about them in the database, so you can look them up easily, and also edit information about them quickly.