Searching \ for '[OT] piclist features' in subject line. ()
Make payments with PayPal - it's fast, free and secure! Help us get a faster server
FAQ page: techref.massmind.org/techref/microchip/devices.htm?key=pic
Search entire site for: 'piclist features'.

Exact match. Not showing close matches.
PICList Thread
'[OT] piclist features'
2006\03\23@131810 by Gökhan SEVER

picon face
Hi,

I have been watching this great virtual community for a while...

I would like to ask that is there a way to list the top-posters of piclist
and most replied postings?

Thanks for your interest...

2006\03\23@133853 by James Newton, Host

face picon face
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.



> {Original Message removed}

2006\03\23@141330 by Gökhan SEVER

picon face
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 <spam_OUTjamesnewtonTakeThisOuTspampiclist.com>:
{Quote hidden}

2006\03\23@151214 by James Newton, Host

face picon face
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 removed}

2006\03\23@152646 by Gökhan SEVER

picon face
Besides, could you please tell me how can achieve to hold suc a huge posting
arciheve?

Microchip's server only holds archieve from 2002 to now...

Also on Edaboard past postings are deleted...

2006\03\23@153055 by Rolf

face picon face
Depending on your database do something like:

Top ten threads....

set rowcount=10
Select subject, count (*) - 1 as replies
from messages
group by subject
order by replies desc

Rolf

James Newton, Host wrote:
{Quote hidden}

>> {Original Message removed}

2006\03\23@154014 by Gökhan SEVER

picon face
Two more questions,

Could i see the all postings for a particular topics at one page?

Like the Microchip's "Printable
Version<forum.microchip.com/printable.aspx?m=38800>"
listings for easy viewing?

2006\03\23@154730 by Danny Sauer

flavicon
face
Did someone ask for some relatively simple SQL?

   SELECT COUNT(subject) AS cnt, subject
          FROM posts
          GROUP BY subject
          ORDER BY cnt DESC
          LIMIT 1;

It may be better to do count(*) depending on how the database
optimizes queries (but probably not), and it'd be good if subject is
an indexed field.  But I don't see it getting much better than that,
if you just want to find the longest thread (presuming the subject
line is the same through the thread)...

It takes 0.00 seconds for 300 records in MySQL, so with 100 times as
many records it should take 100*0.00 = 0 seconds, right? :)

Seriously, in a database with 886659 records it takes about 4.5
seconds (4.8 and 4.4 for count(*) and count(col), respectively) to run
that query on my database server.  The server is a 2.something GHz
Athlon-based system with 2GB RAM and RAID-1 storage running MySQL
5.0something from when 5 was in beta.  With the query cache enabled,
it takes 0.01 seconds to run the query a second time on the unchanged
data... ;)

--Danny

James wrote regarding 'RE: [OT] piclist features' on Thu, Mar 23 at 14:14:
{Quote hidden}

> > {Original Message removed}

2006\03\23@155615 by James Newton, Host

face picon face
Err... Yeah.

The archive is searchable by keyword and you can click on any subject to see
all the posts on that thread. Wasn't that obvious?

---
James.



> {Original Message removed}

2006\03\23@160923 by James Newton, Host

face picon face
MS SQL Server 7 indexes the posts with the first 50 characters of the title,
the date / time stamp, authors name, tag, and an assigned id number.

The web server has each of the emails as a txt file on the hard drive, in
folders by year, month, and day. E.g. the folder \2006\03\23 will hold
today's posts. The email server delivers the posts to a program that finds
in the headers the exact time it hit MITs server and names the file by that
time and places it in today's folder.

When you ask for a list of posts today (or any other day) the SQL server
responds and the list is saved in a text file in the same folder. When the
request is for a day in the past, the SQL server no longer needs to be
involved. E.g. the text file caches the request. The same thing happens for
text searches, and will be added someday for threads.

When you select a specific post from one of these indexes, the exact path
and name of the email are already known, and the script opens the file and
displays it.

I wrote all the ASP scripts, and they are a god awful mess. But they work.

1.4M Hits on 610K pages served to 118K visitors in 170K visits for about
20GB per month. The archive is the 4th most popular page with about 800K
hits per month and the processor has been averaging about 20% busy. But I
think most of that is keyword searches because the search engine about
brings it to its knees... Searching 3GB of text will do that...

---
James.



{Quote hidden}

>

2006\03\23@161301 by Gökhan SEVER

picon face
Actually, you had misunderstood me.

What i try to achieve is listing all the replies at one page .

For example when i found the root subject for * '[OT] Small
delays'<http://www.piclist.com/techref/postbot.asp?by=thread&id=%5BOT%5D+Small+delays&tgt=_top>topic

http://www.piclist.com/techref/postbot.asp?by=thread&id=%5BOT%5D+Small+delays&author=&tgt=_top

*after clicking the main posting i want to see all of the replies together.

Is it possible? or Am i missing something?

2006\03\23@161841 by James Newton, Host

face picon face
6 seconds on my old beater of an SQL server. MS SQL doesn't like LIMIT, but
TOP works.

And the thread with the most posts? (This is absolutely funny)

After no subject, the most common title is...


Unsubscribe


With 187 posts. It had to be huh?


Following that are

177        [EE] Languages, was Bug in Microchip mcc18 std lib
168        [PIC] dsPIC for hobbyists
167        [OT] New Orleans
165        [AD] Looking for work
159        [EE] Printer to PCB?
154        [OT] detecting emergency vehicles


I don't see any reason to make that a regular feature of the archive, but
it's nice to know it can be done.

---
James.



> {Original Message removed}

2006\03\23@181352 by Robert Ammerman

picon face
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 just
about any SQL implementation

Bob Ammerman
RAm Systems



----- Original Message -----
From: "James Newton, Host" <.....jamesnewtonKILLspamspam.....piclist.com>
To: "'Microcontroller discussion list - Public.'" <EraseMEpiclistspam_OUTspamTakeThisOuTmit.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 removed}

2006\03\23@181842 by James Newton, Host

face picon face
When I click on that link, I DO see all the replies to that post. What do
you see?

---
James.



> {Original Message removed}

2006\03\23@215839 by Gökhan SEVER

picon face
But i want to see the whole contents on one page to be able to print the
whole message chain...

Is it clear?

2006/3/24, James Newton, Host <jamesnewtonspamspam_OUTpiclist.com>:
>
> When I click on that link, I DO see all the replies to that post. What do
> you see?
>
> ---
> James.
>

2006\03\24@124127 by Gökhan SEVER

picon face
Check this style if its not clear yet...

http://forum.microchip.com/tm.aspx?m=107014&mpage=1&key=&#107014



2006/3/24, Gökhan SEVER <@spam@gstr2005KILLspamspamgmail.com>:
{Quote hidden}

>

2006\03\24@125934 by Peter

picon face


On Thu, 23 Mar 2006, James Newton, Host wrote:

{Quote hidden}

Unless it is indexed. htdig ? google ?

Peter

2006\03\24@131528 by Danny Sauer

flavicon
face
Peter wrote regarding 'RE: [OT] piclist features' on Fri, Mar 24 at 12:01:
> On Thu, 23 Mar 2006, James Newton, Host wrote:
> > think most of that is keyword searches because the search engine about
> > brings it to its knees... Searching 3GB of text will do that...
>
> Unless it is indexed. htdig ? google ?

MySQL with the text stored in TEXT fields and a FULLTEXT index on the
contents, possibly using compressed tables per month and a UNION table
to search longer timeframes if space is really an issue?  Messages
passed through a tokenizer (the popular spam scanners have this field
down) creating a hash table linking words to files in order to reduce
the searched set?  Etc?

htdig rocks, though...

--Danny

2006\03\24@220644 by James Newton, Host

face picon face
Got it.

Now, when you are viewing a thread in the archive, if you click on the link
(w/post text) or click on the title of the thread, it will show you all the
posts in that thread along with their body text.

If you get a long thread, it's going to take a while...

Is ok? Let me know if you have other suggestions.

---
James.



> {Original Message removed}

2006\03\24@222208 by Gökhan SEVER

picon face
Now, thats ok

I had missed the small point, now i can easily print the whole threads.

Thats exactly what i was trying to achieve..

Thank you very much for clarifying the subject.

2006/3/25, James Newton, Host <RemoveMEjamesnewtonTakeThisOuTspampiclist.com>:
{Quote hidden}

More... (looser matching)
- Last day of these posts
- In 2006 , 2007 only
- Today
- New search...