Re: When would it be 'good' to store binary data in a DB?

At 07.08.2001 22:03, Justin Matlock wrote: <cut>

Is this a bad idea? what is the downside to doing it this way? as far as disk usage goes, I seem to have more disk space this way -- inodes aren't getting wasted. The DB servers don't seem to mind at all. Thanks; Justin

Looking at what you've written I'd say your solution seems excellent for the problem. As you say there isn't an easy solution to instant distribution with some level of redundancy between multiple sites, for a big number of files of relatively small size storing them in databases is certainly one of the easier solutions. What you didn't write though, is how you use these files... (I didn't see the word 'PHP' mentioned in your post though...) -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then.