By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,784 Members | 3,274 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,784 IT Pros & Developers. It's quick & easy.

pictures/movies in BLOB fields ?

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.