Store HighRes photos in Database or as File?

Posted by David on Programmers See other posts from Programmers or by David
Published on 2012-03-27T15:32:15Z Indexed on 2012/03/27 17:42 UTC
Read the original article Hit count: 319

I run a site which has a couple of million photos and gets over 1000 photos uploaded each day. Up to now, we haven't kept the original file that was uploaded to conserve on space. However, we are getting to a point that we are starting to see a need to have high-res original versions. I was wondering if its better to store these in the filesystem as an actual file or if its better to store them in a database (ie: mysql). The highres images would be rarely referenced but may be used when someone decides to download it or we decide to use it for rare processes like making a new set of thumbnails sizes/etc.

© Programmers or respective owner

Related posts about mysql

Related posts about image-manipulation