Re: CMS tutorials

J C Lawrence <[email protected]> Sun, 21 Dec 2003 19:46:16 -0500
Newsgroups gmane.comp.cms.general
Message-ID <[email protected]>
On Sun, 21 Dec 2003 19:37:15 -0500 
J Graham Zahoruiko <J> wrote:

> JC, An alternative is to storing files as BLOBS and content as text or
> XHTML/XML is to store files, images, etc. into the directory structure
> and the rest of the content into the RDBMS or a combination of both.
> I've seen this work perfectly well - while still keeping in mind the
> open architecture approach.

Right, using the RDBMS for meta data and the filesystem for bulk
storage.  It can work quite well, especially when you can re-generate
the meta-data from the filesystem images.  However for the data I
usually handle (eg email and other message frames), I find that external
custom stores such as NETNEWS-style systems ala inn2 are
faster/cheaper/lighter/more-effective.

As always YMWV depending on your data and loads, which is the point.  An
RDBMS is just one tool among many.

-- 
J C Lawrence
---------(*)                Satan, oscillate my metallic sonatas.
[email protected]               He lived as a devil, eh?
http://www.kanga.nu/~claw/  Evil is a name of a foeman, as I live.
--
http://cms-list.org/
please trim your posts.