Hi, This is probably one of those questions that spans a couple of saloon's. I am constructing a web application, using MVC servlets, jsps and mySQL, to store articles and images. Users of the website are allowed upload images and word documents. I'm wondering what is received wisdom regarding storage. Is it best to upload these files to a directory and store the file names in the database or is it best to store the whole file as a blob in the database? Any comments would be gratefully received. John
I have always read and heard that storing images and files in general in a database will hinder performance. Personally, I always store them seperately and store the location in the database. I would also like to hear other opinions on this though..