Should I store images in the database or the filesystem?
I *strongly* recommend storing the file in the filesystem and its LOCATION in the database, though there are several components out there that make storing images in a database really easy. My preference is ASPUpload from Persits Software. You can see how simple the code is by looking at AspUpload.com – User Manual. Chapter 4. You can also handle this type of task without a component, but it’s a lot more code. There are good examples available at ASP 101 and StarDeveloper. Here are the arguments for each methodology. Keep images on the filesystem, and the location and other data in the database • if there is any chance that you will migrate to a different database platform, your current BLOB format might be incompatible with, or at least a pain to convert to, the new format — since, like web browsers, each vendor has implemented things with their own slant. • when your database really goes south, to the point where even the backup is useless, you still have the files on the filesystem
