On Mon, 20 Oct 2003 09:07:24 +1000 (EST) Mark Livingstone <[EMAIL PROTECTED]> wrote:

> On Fri, 10 Oct 2003 01:18:21 -0400 (EDT) Richard Welty
> <[EMAIL PROTECTED]> wrote:
> RW> the simple databases such as berkeley DB, however, are another matter, as
> RW> they're basically simple, fast single key lookups against simple single
> RW> record type arrays of information. my mental picture is of a variant on
> RW> .newsrc, but kept in something berkeley DB like instead of as a flat text
> RW> file.
 
> I notice the latest version of Popfile v0.20 the text classification /
> anti-spam system that has just been released is now storing it's word lists in
> a Berkeley db.
 
> I'm starting to come across it more and more it seems.

in server administration, they've been expected parts of a well administered
un*x system going back well into the 90s, if not before.

the tradeoff is this -- a file such as a newsrc file often has tens of
thousands of lines representing newsgroups. you can read it all in, and
represent it RAM, (slow startup and memory consumption) or use a DB and
only access what you need.

on reflection, you do need to read the whole thing, flat file or DB, just
to find out what you're subscribed to, so the DB file savings are an
illusion as a replacement for newsrc.

what might be good is to retain newsrc, but since there are a number of
characteristics of a newsgroup and articles you might keep beyond just
subscribed/unsubscribed and read/unread, put that stuff in a DB file.

richard
-- 
Richard Welty                                         [EMAIL PROTECTED]
Averill Park Networking                                         518-573-7592
    Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security



-------------------------------------------------------
This SF.net email sponsored by: Enterprise Linux Forum Conference & Expo
The Event For Linux Datacenter Solutions & Strategies in The Enterprise 
Linux in the Boardroom; in the Front Office; & in the Server Room 
http://www.enterpriselinuxforum.com
_______________________________________________
Mahogany-Developers mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/mahogany-developers

Reply via email to