Help me in saving images in mysql without distorting it.

[oracle]

Hi ,

I need some help here.

Basically I am trying to save an image in the database, I ask my user to upload his/her image which I then save in the database.

However what I have observed is that in turn i distort the image by storing in the database.

May be after storing in DB, its just a BLOB type, no jpg, gif, png association.

Can some one tell me how people like orkut, facebook and others save images in the database without distorting it, ??

Regards,
Imoracle

 

[Corey]

I've personally never have saved it to a database. I usually save it to a folder and reference it.

I did a quick Google search and found this:
http://www.weberdev.com/ViewArticle/Saving-Images-in-MySQL

Have you tried what's in that article?

 

[oracle]

Ya Corey, I already used that for the same. Able to implement the same now successfully.

Any reason why u don't prefer storing images in database.

Also is .xml, .jpg file retrieval faster from the file system itself or from database.

Thanks waise for the quick reply.

 

[Corey]

Well, I would imagine storing a lot of images in a database would slow it down query wise and put extra load there, vs just having it link to a directory where the actual location is.

I'm not really sure on the benchmarks and everything but I'd imagine it would create a very large database, very quickly.

-Corey