Lars Aronsson wrote:
Blob-like data can be stored on file instead, with only a filename in the database.
For reasons I don't understand, many people keep coming up with this idea, but it's a really bad idea.
First of all, there is no reason to believe that reading from one file out of thousands is any faster than reading one record in the DB out of thousands. Secondly, it makes atomic transactions impossible. It makes backing up a consistent state of the database/file-system mix virtually impossible. It is too difficult to move data around without violating the consistency of the construct. And lastly, it makes creating a full-text search index quite a bit harder.
Convinced yet? ;-)
Timwi