This works for SQL server:

select top 100 count(*) as cnt, thread_title
from posts group by thread_title
order by count(*) desc

will give top 100 posts and the thread title that applies

if you leave off the top 100 it will process all the posts and work for jus=
t =

about any SQL implementation

Bob Ammerman
RAm Systems



----- Original Message ----- =

From: "James Newton, Host" <jamesnewton@piclist.com>
To: "'Microcontroller discussion list - Public.'" <piclist@mit.edu>
Sent: Thursday, March 23, 2006 3:12 PM
Subject: RE: [OT] piclist features


That is not a current feature of the piclist.com archive. Perhaps gmane can
do that?

If someone can suggest some SQL that would efficiently perform such an
analysis on the 302,492 posts that are currently in the data set....

The subject line in the database has the Re: Fw: etc removed so the threads
are possible to group by title, but the processing power required to group
300k records, then count entries in each group, then select the top group
must be fantastic. Or I would think so... I've been wrong before so if an
SQL guru can come up with a good way to do it, I'll implement the feature.

I currently don't record views, but I've been thinking about adding a rating
system to the archive for a long time.

---
James.



> -----Original Message-----
> From: piclist-bounces@mit.edu
> [mailto:piclist-bounces@mit.edu] On Behalf Of G=F6khan SEVER
> Sent: 2006 Mar 23, Thu 11:13
> To: Microcontroller discussion list - Public.
> Subject: Re: [OT] piclist features
> Importance: Low
>
> If you have edaboard membership you can see posting sorting
> methods at the bottom of the sections
>
> "Select sort method" -> by replies and views
>
> Or say i want to sort with both methods, but how?
>
>
> 2006/3/23, James Newton, Host <jamesnewton@piclist.com>:
> >
> > See:
> > http://www.piclist.com at the bottom of the page. It will
> give you the
> > top posters.
> >
> > The most replied postings? I'm not sure I understand what
> you mean. Do
> > you mean the longest running threads? Or the most viewed
> thread in the
> > archive?
> >
> > ---
> > James.
> >
> >
> --
> http://www.piclist.com PIC/SX FAQ & list archive View/change
> your membership options at
> http://mailman.mit.edu/mailman/listinfo/piclist


-- =

http://www.piclist.com PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist =


-- =

http://www.piclist.com PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist