pictures/movies in BLOB fields ?

[konsu]

Hello,

I am planning to implement an image and movie library (e.g. a photoalbum),
and one of the ways that I see to store image and movie files is to put them
in to BLOB fields in an sql table. I would greatly appreciate any
information as to how this method compares with simply storing the images
and the movies as plain files on disk. Does MySQL add a lot of overhead when
retrieving images from BLOBs compared to reading the files from the disk?
Any other pros and cons?

thanks
konstantin

[Aggro]

konsu wrote:

I am planning to implement an image and movie library (e.g. a photoalbum),
and one of the ways that I see to store image and movie files is to put them
in to BLOB fields in an sql table. I would greatly appreciate any
information as to how this method compares with simply storing the images
and the movies as plain files on disk. Does MySQL add a lot of overhead when
retrieving images from BLOBs compared to reading the files from the disk?
Any other pros and cons?

If you need to do queries according to the full content of the file,
then you might get advantages on storing the data into database, but
normally you don't need/want to do this.

I personally have always used the simpler method (storing files to disk)
and this is what I always recommend, because it is so much easier to do
and I really don't see many advantages on storing that data to database.