Database VS Files System for image storage

[one_mind]

Hi,

I have a site where users can upload a logo image for their profile. At the moment, i just upload them to my server and place them in a logos file with each image named the same as their id number.

This works fine but am beginning to wonder if it would be faster to store all the logos in blob fields in a database. Or would that be slower?

Any opinions would be greatly appreciated.

Thanks :)

[adni18]

It's probably more practical to store them as files. I don't know about the speed of database blobs, but if you actually store them as a file, then you can just link to the image right in the HTML, rather than calling a server script to read and print the contents.

[adnovice88]

blobs are not slower but for images to be displayed on a site, they are not worth it.

i agree with adni18, linking to a file from html is cleaner and simpler.

[coopster]

Storing Images in the Filesystem Versus a Database [webmasterworld.com]

[one_mind]

Great link,

Thanks guys :)

[one_mind]

Anyone know anything about storing pdfs in a db?

I have to do something like this soon but am beginning to wonder if it would be better to keep them in a file also?

[jatar_k]

I have always thought keeping large chunks, such as files of any type, is better in the filesystem as opposed to the db itself