what's the best way to store images?

[Anon]

Hi everybody!

I've to store a lot of images. I'm not sure what's the best way to store them. I play with the idea of storing them in a mysql db. that would be cool because manageing of them should be very easy and i wouldn't have to care about making new directorya and so on (my users will upload the images). But i want to choose the fastest way. So wich method would be faster? Storing the images (btw: arount 100 to 200k in size) in a mysql db on a seperate server or on the local file system?

Thanks for your help!

regards from germany
LtData

[brandonschnell]

imho storing the data on a mysql db is the simpliest way from an admin point of view.

but your best best long term is to store the file name, type, size in the database, and store the actual files on the local file system under the apache web root. just use the mysql db to return the http path to the requested image. the system will scale better and prevent overloading of the mysql db.