[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Pan-devel] ancient DB schema

From: Calin A. Culianu
Subject: Re: [Pan-devel] ancient DB schema
Date: Tue, 8 Jun 2004 09:54:34 -0400 (EDT)

Well again I must repeat myself.. this is a nice db idea but I just to get
article loading to work better with 2 million headers.. that's all. In
fact.. I will leave the current flat files format for this stuff in tact.. 
I am possibly going to finish my db changes at some point, and they will 
only change the way article headers are stored/loaded/sorted/threaded.


On Sat, 5 Jun 2004, K. Haley wrote:

> After looking at the source again I realized that there are some fileds 
> missing from the Server table.  So here is an update to it.  I still 
> don't know how filters would be handled for the groups.
> * primary key
> ! indexed
> A NNTP news server.
> Rank will be used to tell which servers to hit first for a body.
> Unresolved: should we handle multiple hostname+port pairs?
> (just remember to seperate servers that handle different groups.)
>   ! name              (string NOT NULL)
>     hostname          (string NOT NULL)
>     need_auth         (bool)
>     newsrc            (bool)
>     max_conn          (int)
>     username          (string)
>     password          (string)
>     port              (unsigned int=)
>     rank              (unsigned int=0)
>   * id                (integer primary key)

reply via email to

[Prev in Thread] Current Thread [Next in Thread]