467,104 Members | 1,007 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,104 developers. It's quick & easy.

pictures/movies in BLOB fields ?

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
Jul 20 '05 #1
  • viewed: 2739
Share:
1 Reply
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.
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by hamvil79@gmail.com | last post: by
7 posts views Thread by johnm | last post: by
1 post views Thread by Alexandre Jaquet | last post: by
13 posts views Thread by gooze | last post: by
9 posts views Thread by C.Joseph Drayton | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.