Save image in database?

Question

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

Duplicate:

• http://stackoverflow.com/questions/766048/store-image-in-database-or-in-a-system-file
• http://stackoverflow.com/questions/713243/should-i-store-my-images-in-the-database-or-folders
• http://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay

Hi,

I have a question: where is better to save my images? In SQL database or on my disc and save links to my images in database?

Regard, Andrei.

Answer 1

I don't like storing images in databases. You could register meta data about the image in the database and keep the blob on the disk. The downside of this is that you have to keep disk and database in sync. If you're using an ORM, they tend to have "before delete" events you can use to delete the image from disk before you delete it from your db.

Answer 2

From a performance and ease-of-use standpoint, I've always found storing them on the disk better. While you can spend the time building the indexes correctly for storing it in the database, it just seems like wasted time to me.

Also, that way, your images are transportable, so if you need to move them do to spatial considerations, it's easy to do so.

Cheers,
Eric

Answer 3

No, i don,t user a set of images or the same image, users will upload images.I have a Silverlight application, it runs in a browser....

Answer 4

I think it's better avoiding blobs in the database. A quick link: http://www.volny.cz/iprenosil/interbase/ip_ib_strings.htm

Answer 5

In SQL 2005 exists type "image". Is a limit size for these type too?