database - Store user's images in a web application -


i have web application being developed in jsp/servlets.
application allows users upload image files each user account.

what best way store images?
please consider following features i'd have before answer;

  1. i using mysql now, there possibility of moving different database.

  2. i can store images flat files, want admin account have option backup complete database , reload later. ideally backup/reload should work images too. (even if backup done different physical machine , reload done different machine)

  3. using blob/clob option solves problem 2.
    but, what if database becomes large?

store them in file system. it's faster , simpler. often, when accessing image, you're going have save file anyway before can utilize it. can examine images third party tools. can store recordid in filename keep image/record association ever being broken.

many others share opinion: http://forums.asp.net/p/1512925/3610536.aspx


Comments