Page 1 of 1
Put images into database or not? [SOLVED]
Posted: Mon Feb 05, 2007 2:45 pm
by 50cc
I am building a site where users can upload pictures. I was wondering which would be better save the uploaded images as 'normal' files or putting each image into a MySQL database. Putting all the images into a database would make it easier to backup all the data for my site. But would it have disadvantages?
Posted: Mon Feb 05, 2007 3:02 pm
by Luke
Just store the filenames of the images in the database. Files belong in file systems. You have one at your disposal... why create another one inside of a database?
Posted: Mon Feb 05, 2007 3:04 pm
by feyd
Posted: Sat Feb 24, 2007 6:34 am
by survivant
I read that the main problem with storing the images into the database is the overhead to retrieve the images using a php script. If I use a servlet to retreive the images, will it be better than a php script ?
I think that I'll stick with the databse to store the image path, names, description.. and keep the images into the HD for better performance, but I really want to supporte clustoring, that why I taught he database approach .
thanks
Posted: Sat Feb 24, 2007 10:08 am
by feyd
survivant wrote:If I use a servlet to retreive the images, will it be better than a php script ?
Last I saw.. no.