Hi. I am been racking my brain over this for the last week; I am a junior web programmer and I have been asked to find the best way to store large amounts of photos and files. I was asked to store them in a mySQL database, but as I suspected my research found that although possible this would cause query speed problems and that it was best to just store the link location and the meta data. My problem is, were the heck should I store the actual files and how do I maintain synchronization between them and the database. I considered using a file sharing service (pay cloud) to store the files because they seem to sell storage much cheaper then database services, but the problem is that if I do that I cannot create a front end for employees to add files, and I can't write scripts to link the data together, because I do not have back end access to the files sharing service (am I the only one who laughs when someone says back end access?).
I did notice that hostings seem to claim that they although they have only 2gb database limits, they have unlimited file storage, but I highly doubt that is true, or else I could just store all the files with my hosting and store the links and meta data in my database, and create front ends to my hearts desire.
If anyone has any ideas it would be greatly appreciated. If my question needs clarification do not hesitate to say so, I am happy to reiterate it. Just to clarify this is for a started magazine company but it will grow, and the industry is very file and picture heavy.
Thanks a bunch,