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
