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]

Re: pictures/movies in BLOB fields ?

konsu wrote:
[color=blue]
> 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?[/color]

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.