Re: Site statistics [message #438165 is a reply to message #438146] |
Thu, 07 January 2010 05:34 |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
I too completely agree with Maaher and JRowbottom.
Agreeing on not providing solutions for the most blatant homework issues is not the same as not giving solutions at all. I think a lot of posters (maybe not the ones asking questions, but the ones answering them) are scared away by the "THOU SHALT NOT ANSWER" critics.
Add to that the already mentioned default critics on new questions, and you have a place far less friendly then it was some years ago.
|
|
|
Re: Site statistics [message #438169 is a reply to message #438165] |
Thu, 07 January 2010 05:45 |
|
Michel Cadot
Messages: 68641 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:Agreeing on not providing solutions for the most blatant homework issues is not the same as not giving solutions at all.
I agree with that but the point was not that in this topic. It was that we provided hints to OP, we were waiting he posts something from what he found/tried before posting something more this is what we usually did.
Regards
Michel
[Updated on: Thu, 07 January 2010 05:48] Report message to a moderator
|
|
|
|
|
|
|
Re: Site statistics [message #489424 is a reply to message #464760] |
Sun, 16 January 2011 03:12 |
|
Michel Cadot
Messages: 68641 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Forum site statistics page has been updated and contains whole 2010 data.
For those who are interesting in this, I can provide a new feature: personal statistics.
As I will not provide different statistics and/or charts to each one, I open the question to which ones you are interesting in.
Here are a couple of examples which are not exclusive:
- raw data (as a csv file) with number of posts each day in each forum
- summary data (number of posts per month, number of posts per forum...)
- charts like the ones in the Forum site statistics page, choose which ones you are interesting in
- ...
The most asked ones are those I will provide.
Next, which way do you prefer to get them:
- PM
- Update of your personal wiki page, see mine as an example. Remember that your personal page is public, so if you don't want to show your statistics forget this option.
Waiting for your comments...
Regards
Michel
[Updated on: Sun, 16 January 2011 10:18] Report message to a moderator
|
|
|
|
|
Re: Site statistics [message #489440 is a reply to message #489434] |
Sun, 16 January 2011 10:20 |
|
Michel Cadot
Messages: 68641 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Thanks Barbara, I fixed the links.
It is weird as the links were correct when I first wrote the post, I think "Preview" scrambled them. Tell me if you see them as well.
Regards
Michel
[Updated on: Sun, 16 January 2011 10:21] Report message to a moderator
|
|
|
|
|
Re: Site statistics [message #489451 is a reply to message #489440] |
Sun, 16 January 2011 12:18 |
|
Barbara Boehmer
Messages: 9088 Registered: November 2002 Location: California, USA
|
Senior Member |
|
|
Michel,
The links work now. Thanks.
I have a request. It isn't anything urgent or important, just something to consider if you have some extra time. Could you show the top users for each forum, something like they do now on the OTN forums? Sometimes code is clearer than description, so please see the pseudo-code below. It is pseudo-code since I do not know the table structure of these forums and because it is written how I would do it in SQL for an Oracle database, not MySQL.
select forum, person, posts
from (select forum, person, count(*) posts,
row_number () over (partition by forum order by count(*) desc) rn
from table
group by forum, person)
where rn <= 10
order by forum, posts desc;
|
|
|
Re: Site statistics [message #489454 is a reply to message #489451] |
Sun, 16 January 2011 13:37 |
|
Michel Cadot
Messages: 68641 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Barbara,
I have no access to OraFAQ database, Frank gives me some extracts in 3 csv files.
These ones are anonymous as I currently don't need any name to build statistics.
Here are the description of the 3 files (as external tables (I use an Oracle database), I think the names are clear):
SQL> desc ORAFAQ_FORUM_EXT
Name Null? Type
-------------------------------- -------- ----------------------
ID NUMBER(38)
FORUM_NAME VARCHAR2(50 CHAR)
THREAD_CNT NUMBER(38)
POST_COUNT NUMBER(38)
SQL> desc ORAFAQ_MEMBER_EXT
Name Null? Type
-------------------------------- -------- ----------------------
IP VARCHAR2(15 CHAR)
MSG_COUNT NUMBER(38)
JOIN_DATE NUMBER(38)
SQL> desc ORAFAQ_MSG_EXT
Name Null? Type
-------------------------------- -------- ----------------------
ID NUMBER(38)
THREAD_ID NUMBER(38)
IP VARCHAR2(15 CHAR)
POST_STAMP NUMBER(38)
FORUM_ID NUMBER(38)
From them I fill the following tables to create the statistics (in short I add the country and continent I determine from IP):
SQL> desc ORAFAQ_FORUM
Name Null? Type
-------------------------------- -------- ----------------------
ID NOT NULL NUMBER(38)
FORUM_NAME NOT NULL VARCHAR2(50 CHAR)
THREAD_CNT NOT NULL NUMBER(38)
POST_COUNT NOT NULL NUMBER(38)
SQL> desc ORAFAQ_MEMBER
Name Null? Type
-------------------------------- -------- ----------------------
IP NOT NULL VARCHAR2(15 CHAR)
IP_NUM NUMBER(38)
COUNTRY VARCHAR2(50 CHAR)
CONTINENT1 VARCHAR2(30 CHAR)
CONTINENT2 VARCHAR2(30 CHAR)
CONT_ID NUMBER(38)
CONT_SID NUMBER(38)
JOIN_DATE NOT NULL DATE
MSG_COUNT NOT NULL NUMBER(38)
SQL> desc ORAFAQ_MSG
Name Null? Type
-------------------------------- -------- ----------------------
ID NOT NULL NUMBER(38)
THREAD_ID NOT NULL NUMBER(38)
FORUM_ID NOT NULL NUMBER(38)
IP NOT NULL VARCHAR2(15 CHAR)
IP_NUM NUMBER(38)
COUNTRY VARCHAR2(50 CHAR)
CONTINENT1 VARCHAR2(30 CHAR)
CONTINENT2 VARCHAR2(30 CHAR)
CONT_ID NUMBER(38)
CONT_SID NUMBER(38)
POST_STAMP NOT NULL NUMBER(38)
As IPs are something with security concern, we (Frank and I) agree that these information will not come out his database.
For the "personal statistics" I suggested here, there will be a prerequisite I didn't talk about so far but wanted to add it in a future post for those that are interested, this prerequisite is to "register" for this, that is post to Frank that he or she agrees that Frank gives me the list of IPs for this account (some persons, as I do, use several IPs, actually at my office there currently are 6 random IPs allocated to me).
So I can't currently provide what you ask but I think it is interesting. I think we should continue this part of the discussion in Moderators forum if you want to go forward.
Regards
Michel
[Updated on: Sun, 16 January 2011 13:39] Report message to a moderator
|
|
|
|
|
|
|
|
Re: Site statistics [message #538747 is a reply to message #518879] |
Mon, 09 January 2012 04:56 |
|
Michel Cadot
Messages: 68641 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Forum site statistics page has been updated.
A new chart has been added: "Active members".
This chart contains 2 lines.
1/ Posting members: number of members that have posted in the quarter. Actually it is posting IPs this is a slighty more than
posting members as some members have several IPs.
A point to mention is that less and less people use modem but cable or ADSL and so more and more people have static IP address, this explains the decreasing of this line.
2/ Visiting members: number of members that have visited in the quarter. This is real members not IP; to be recorded member must have logged in (and so only registered members are recorded). Frank does not record all visits just the last visit time, so I will build this history with one point per member each quarter. This means this "line" currently have one point, for the last quarter.
Regards
Michel
[Updated on: Mon, 09 January 2012 04:59] Report message to a moderator
|
|
|
|
Re: Site statistics [message #538756 is a reply to message #538751] |
Mon, 09 January 2012 05:35 |
|
Michel Cadot
Messages: 68641 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Visiting "line" is currently the lone pink point at the right of the chart.
I can start this line only from now as Frank does not record this information, so you have the "single point line", just for the last quarter.
Regards
Michel
[Updated on: Mon, 09 January 2012 05:35] Report message to a moderator
|
|
|
|
|
|
|
|
|
Re: Site statistics [message #595691 is a reply to message #591420] |
Thu, 12 September 2013 14:16 |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
Hi Michel,
In the OraFAQ forum homepage, at the bottom we see logged users stats, one of which is -
Most users ever online was XXXX on Day, DD Month YYYY HH24:MI
Is it possible to find the trend of maximum number of users online on the day basis. As I have observed, mostly on Tuesdays there are maximum number of posts, so, might also be, number of users online are more on Tuesdays than other week days.
Regards,
Lalit
|
|
|
|
|
|
|
|
|
|
|
Re: Site statistics [message #631690 is a reply to message #631688] |
Sat, 17 January 2015 17:18 |
|
Littlefoot
Messages: 21807 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
That's nice, having people posting more messages than before.
But, I'm afraid that OraFAQ is turning into a small "private" club. You'll have 20 members, frequent posters, who will talk exclusively to each other, discussing highly scientific problems. Everything else will be FAQ, answered many times long time ago.
It is number of active members that keeps a forum alive. I've been a member of a nice, small forum. Everyone knew everyone, many of them personally. Two or three couples even got married. Finally, people just quit comming there and it died. There's still its skeleton somewhere out there, hidden behind a forgotten IP address.
Do you understand what I'm saying? We are dying.
|
|
|
|
|