Charles C wrote:
> "Leef_me" <nomail@nomail> wrote:
>> Also, "and if we easily can" seems strange.
> 
> I'll venture the guess that he might've been alluding to the possibility of
> leaving the off-topic group acccessible via the web, but not included in
> the web interface's message digest.

Exactly. If this can be done depends on how the digest SQL queries are
formulated right now (which I don't recall from memory even though I wrote
them many years ago), and if modified queries are still efficient.

	Thorsten

PS: Yes, my original sentence makes more sense if one assumes a few bits
about the inner workings of the news web view ;-)

Post a reply to this message

Charles C wrote:
> I'll venture the guess that he might've been alluding to the possibility of
> leaving the off-topic group acccessible via the web, but not included in
> the web interface's message digest.  In that case, it would not be the same

Exactly. It's not as simple as it sounds, since the digest was simply the
most recent 100 rows in the message table, retrieved with the following query:

  SELECT * from messages ORDER BY id DESC LIMIT 0,100

Note that the message table does *not* contain any group ID. It has never
been necessary. And apart from that, there is not necessarily a 1-1
relationship between a message and a group (i.e. a single message may be
posted in multiple groups simultaneously, at least if you are using the NNTP
interface).

Therefore there is no direct way (from the message table alone) to tell if a
given message is in a particular group. We must also query the threads table.
That said, while I'm not particularly familiar with SQL, it wasn't too hard
to do. This new query is now in place:

  SELECT * from messages,threads
    WHERE messages.id=threads.messageid AND threads.groupid<>41
    ORDER BY messages.id DESC LIMIT 0,100

which to the credit of mysql executes in about 5 milliseconds.

-- Chris

Post a reply to this message