I'm debating between storing binary content (i.e. images) in the db (mysql) or the filesystem. I like the idea of the database because everything is in one place, but I've heard using the filesystem has better performance. Is storing binary content in the database a performance hit vs. the file system, or is it just an old wives tale? If I'm going to be writing queries against a table's non-binary fields will I face performance hits because binary columns appear in the table?
Anyone have any thoughts?
Thanks in advance. Scott.