Re: Images : Path vs Database
I always choose the file system. My reasoning:
1) I may want to change my hosting site, and dumping a database with images makes for a much larger file. And importing the SQL may have issues (sql limits, php limits, ...) on the new hosting site. I have had this problem and try to avoid it.
2) I may have a small upload limit (in Apache) for files and have to ftp them directly. If I store the images in the file system, I can manually add them to a gallery (create stub image upload and then move the real file to replace the stub file and thumbnail). I have never figured out how to manually do this if the files or images are in the database. Think about the case where the upload limit is 2MB and you have a 3MB image.
I do not have any performance measures. But even if I found a db performance that was better (and I can't see how a db reference would be faster than a file reference) I still would use the file system for the above reasons.
gary
;){kind=link}
;){kind=link}