Re: Database versus filesystem for storing images

If you end up storing the pictures on a separate database server for
performance reasons, Jorge's argument regarding integrity becomes
moot...And his argument so far is the strongest case I've seen for
storing the files in the database.

Scott Marlowe wrote:

>On Fri, 2007-01-05 at 15:54, Jeremy Haile wrote:
>
>
>>Yeah - it can make it easier to implement transactional semantics by
>>storing them in the database, although for simple operations it wouldn't
>>be hard to replicate this manually. And you are going to incur a
>>performance penalty by storing them in the database.
>>
>>Another thing to consider is that storing them in the file system makes
>>it much easier to browse the images using third-party tools, update
>>them, archive them (by gzipping or whatever). This is much more
>>difficult if they are stored in the database.
>>
>>
>
>The biggest performance penalty from them being in the same database as
>your data is that they're going to be the majority of your kernel /
>database buffers. So, as mentioned earlier, it's almost a necessity
>(for performance reasons) to put them into their own db server.
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: don't forget to increase your free space map settings
>
>