OraFAQ Forum: Suggestions & Feedback » Site statistics

Home » Other » Suggestions & Feedback » Site statistics

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Site statistics [message #237974]

Wed, 16 May 2007 04:11

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I love statistics and geography.
Is it possible to have some on the site.
For instance:
- Members per region (from IP)
- Askers per region
- Histograms of message counts per region

I know that IP is not a definitive evidence for region (for instance, I use 3 IPs, 2 of them registered in Paris/France, the other one in NY/USA) but it is statistically acceptable.

Regards
Michel

[Updated on: Wed, 09 January 2019 03:04]

Report message to a moderator

Re: Site statistics [message #238002 is a reply to message #237974]

Wed, 16 May 2007 05:50

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

We have statistics, but it's not broken down to region.

PS: I can provide you with some raw data if you want to volunteer. Contact me via private mail to discuss this further.

Report message to a moderator

Re: Site statistics [message #238014 is a reply to message #237974]

Wed, 16 May 2007 06:16

Frank
Messages: 7901
Registered: March 2000

Senior Member

Michel Cadot wrote on Wed, 16 May 2007 11:11

- Askers per region

Trying very hard not to sound racist(ic?), but I guess that one isn't too hard..

Report message to a moderator

Re: Site statistics [message #238075 is a reply to message #238014]

Wed, 16 May 2007 11:03

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Statistically? But of course ~1E9 people from India will ask more questions than ~4E6 people from Croatia or even ~3E4 of them in Liechtenstein.

Report message to a moderator

Re: Site statistics [message #238090 is a reply to message #238075]

Wed, 16 May 2007 12:34

Frank
Messages: 7901
Registered: March 2000

Senior Member

lol you are right, but how many of the 30000 in Liechtenstein are too poor to even own a table to put their laptop on?

Report message to a moderator

Re: Site statistics [message #238272 is a reply to message #238090]

Thu, 17 May 2007 04:55

hobbes
Messages: 173
Registered: January 2006

Senior Member

Frank wrote on Wed, 16 May 2007 12:34

how many of the 30000 in Liechtenstein are too poor to even own a table to put their laptop on?

Whatever that ratio may be for the laptop-owning population of Liechtenstein, it should be equivalent to that of any country. I do not know of anyone - Indian or otherwise - rich enough to own a laptop but at the same time too poor to afford a table for it.

Besides, I don't see how owning tables has a bearing on the number of questions asked on orafaq.

Report message to a moderator

Re: Site statistics [message #238293 is a reply to message #238272]

Thu, 17 May 2007 06:14

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Obviously, you didn't think enough about it.

People (AKA users) who own a table, actually, own a schema. So, if you don't own a schema, you don't own a table, you (probably) don't use Oracle much and - consequentially - don't ask many questions about Oracle on OraFAQ.
Am I smart or what? /forum/fa/1986/0/

/forum/fa/1986/0/

Report message to a moderator

Re: Site statistics [message #238306 is a reply to message #237974]

Thu, 17 May 2007 06:41

hobbes
Messages: 173
Registered: January 2006

Senior Member

I bow before thine Superior Intelligence, Littlefoot. You do De Bono proud.

*insert kowtowing emoticon here* (Off-topic: how do you do that? I mean, use emoticons from outside the given list?)

Report message to a moderator

Re: Site statistics [message #238316 is a reply to message #237974]

Thu, 17 May 2007 07:04

hobbes
Messages: 173
Registered: January 2006

Senior Member

Then again, by that reasoning those who don't own tables should be asking fewer questions not more!

Report message to a moderator

Re: Site statistics [message #238325 is a reply to message #238306]

Thu, 17 May 2007 07:19

Maaher
Messages: 7065
Registered: December 2001

Senior Member

hobbes wrote on Thu, 17 May 2007 13:41

*insert kowtowing emoticon here* (Off-topic: how do you do that? I mean, use emoticons from outside the given list?)

*cough*

MHE

Report message to a moderator

Re: Site statistics [message #238330 is a reply to message #237974]

Thu, 17 May 2007 07:29

hobbes
Messages: 173
Registered: January 2006

Senior Member

/forum/fa/1581/0/

Yay! Thank you, Maaher.

For you, Littlefoot: /forum/fa/1578/0/

/forum/fa/1578/0/

Report message to a moderator

Re: Site statistics [message #242455 is a reply to message #237974]

Sat, 02 June 2007 04:30

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I added a page in the wiki with site statistics.
Feel free to correct my bad english and add what you want.
I'm open to any suggestion.

Forum Statistics

Regards
Michel

Report message to a moderator

Re: Site statistics [message #242467 is a reply to message #242455]

Sat, 02 June 2007 08:03

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

That is absolutely ... amazing /forum/fa/451/0/

/forum/fa/451/0/

WOW! Marvelous, Michel, m a r v e l o u s !!!

Report message to a moderator

Re: Site statistics [message #242539 is a reply to message #242467]

Sun, 03 June 2007 13:31

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Thanks for your comment, I really appreciate it.

Regards
Michel

Report message to a moderator

Re: Site statistics [message #250032 is a reply to message #242539]

Sat, 07 July 2007 02:54

Frank
Messages: 7901
Registered: March 2000

Senior Member

Another amazing statistic: 18914 users took the time to register but never made a single post..

Report message to a moderator

Re: Site statistics [message #250049 is a reply to message #250032]

Sat, 07 July 2007 06:53

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

That is a whooping 35%! Some possible reasons:

1) Some user may never wanted to post in the first place, but registered for the additional featured available to registered users.

2) Users that wanted to post, but didn't manage to.

The latter may be a real problem, but we will probably never know.

Report message to a moderator

Re: Site statistics [message #251580 is a reply to message #250049]

Sun, 15 July 2007 01:50

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I have updated the Forum_Statistics wiki page with data from 07/07/07.
I have added new pictures and especially one following Frank remark.
Amazing 90% of members have less than 5 posts.

Regards
Michel

Report message to a moderator

Re: Site statistics [message #251599 is a reply to message #251580]

Sun, 15 July 2007 06:48

Frank
Messages: 7901
Registered: March 2000

Senior Member

Number of posts and topics since the beginning
Belgium: 4206

Maaher's post count: 5905

Huh?

hehe, cool! Mahesh's got a bar of his own Very Happy

Very Happy

[Updated on: Sun, 15 July 2007 06:50]

Report message to a moderator

Re: Site statistics [message #251608 is a reply to message #251599]

Sun, 15 July 2007 08:34

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Same anomaly for me.
Number of France posts since I'm there (18/03/2007): 1830.
My posts in the same time between 3500 and 3600 but only 1733 on France.

I use several IP, one registered in France and the other ones in USA.

Posts and members localization is based on the IP.

Regards
Michel

[Updated on: Sun, 22 July 2007 02:48]

Report message to a moderator

Re: Site statistics [message #253069 is a reply to message #237974]

Sun, 22 July 2007 02:21

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Number of posts and topics during last month of Bangladesh is 105. And my message count was 105 in last month !!! Laughing

Laughing

Laughing

Report message to a moderator

Re: Site statistics [message #253075 is a reply to message #253069]

Sun, 22 July 2007 03:09

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Here's what I have until 07/07/07: Wink

Wink

MONTH         NBPOST
--------- ----------
June              84
July               6

Of course, if you use several IPs I can't know which ones are from you. I have 9 different IPs on June and July for Bangladesh with 101 posts on June and 10 on July.

Regards
Michel

Report message to a moderator

Re: Site statistics [message #253079 is a reply to message #253075]

Sun, 22 July 2007 03:25

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you want to know its private statistics, I can send them to you.
You just have to private me your IP(s) (I don't know users, I only know IPs) and what kind of statistics you want.

Warning! It is dangerous to give your IP to someone that you don't know.

Regards
Michel

[Updated on: Wed, 09 January 2019 03:08]

Report message to a moderator

Re: Site statistics [message #254898 is a reply to message #237974]

Mon, 30 July 2007 00:39

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

One statistics should be added. That is hierarchy of number of averages messages per day. In members section sorting of message count is possible.Also individual person's average messages per day can be seen. But I got no where I can get sorting list of average messages per day. I think it is much important because you and I are not entered in this forum in same day.

Report message to a moderator

Re: Site statistics [message #254915 is a reply to message #254898]

Mon, 30 July 2007 01:20

Frank
Messages: 7901
Registered: March 2000

Senior Member

Posting here is not a competition. It is about helping others, not to get more posts than someone else.

Report message to a moderator

Re: Site statistics [message #254937 is a reply to message #254915]

Mon, 30 July 2007 01:58

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

That's what YOU think /forum/fa/1986/0/

/forum/fa/1986/0/

Report message to a moderator

Re: Site statistics [message #254938 is a reply to message #254898]

Mon, 30 July 2007 02:00

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I agree with Frank, there is no personal data only statistics on forum and large groups. I neither want some competition comes on posts.
Moreover, even I wanted to I don't have any personal data (and I don't want them). I can't say how many times each one posted.

As I said in my previous post, if you want data on you, provide me your IP(s) and what you want and I'll see what I can do.

Regards
Michel

[Updated on: Mon, 30 July 2007 02:20]

Report message to a moderator

Re: Site statistics [message #254943 is a reply to message #237974]

Mon, 30 July 2007 02:12

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Yes , Good idea. I totally agree with you. But statistics give me pleasure.

Report message to a moderator

Re: Site statistics [message #258974 is a reply to message #237974]

Tue, 14 August 2007 00:07

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

I think it's the time to update statistics.

Thanks Michel.

Report message to a moderator

Re: Site statistics [message #258989 is a reply to message #258974]

Tue, 14 August 2007 01:17

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It's a quite long process on my laptop, I planned to do it once per quarter, so you have to wait beginning october...
maybe with new charts...

Regards
Michel

Report message to a moderator

Re: Site statistics [message #272801 is a reply to message #258989]

Sun, 07 October 2007 10:45

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Statistics page have been updated with the last quarter data.

Regards
Michel

Report message to a moderator

Re: Site statistics [message #272811 is a reply to message #272801]

Sun, 07 October 2007 14:01

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

Thanks Michel. A sterling job as usual!

Report message to a moderator

Re: Site statistics [message #272823 is a reply to message #237974]

Sun, 07 October 2007 22:46

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Good, Good one, I got it before EID. I was waiting for it for long days. Thank you Michel.

Report message to a moderator

Re: Site statistics [message #272826 is a reply to message #237974]

Sun, 07 October 2007 23:16

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

In section "Number of users per number of posts" pie chart and histogram shows different result.
Number of users 0 number of posts pie-chart shows 37% but histogram shows 35.75%.

Report message to a moderator

Re: Site statistics [message #272860 is a reply to message #272826]

Mon, 08 October 2007 01:26

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The reason is quite simple: it is Excel bl... rounding algorithm.
It firsts round all data -> 36% for 0,
then sum all % -> get 99%,
then add 1% to each slot starting from the biggest one till it reaches 100%,
so 0 -> 37%

(Sorry, from time to time part of legend disappeared in pies during copy, they are all "rest of world" or "others").

Next update at beginning of 2008...

Forum Statistics
Regards
Michel

Report message to a moderator

Re: Site statistics [message #272868 is a reply to message #237974]

Mon, 08 October 2007 01:42

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

How comes in "number of posts and topics during the last 3 months"
section Bangladesh is included with post 1063, but "number of posts and topics during the last 6 months" Bangladesh is not included though Belgium included with much lower posts that is 682.

Report message to a moderator

Re: Site statistics [message #272914 is a reply to message #272868]

Mon, 08 October 2007 02:57

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Good eyes!
This comes that I didn't update statistics in "number of posts and topics during the last 6 months".
New figures are Bangladesh 1215 and Belgium 870.
I'll update this when I'll come back home, you have to wait about 8 hours.
If you find other inconsistencies, please let me know. There are many charts and despite the care I took, some errors may still remain.

Regards
Michel

Report message to a moderator

Re: Site statistics [message #273017 is a reply to message #272914]

Mon, 08 October 2007 12:29

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

How do you mean "wait 8 hours"? Its URGNT, PLZ!!!

(Disregard the fact that it's been almost half a day since Michel wrote his message).

Report message to a moderator

Re: Site statistics [message #294033 is a reply to message #273017]

Wed, 16 January 2008 02:56

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Forum statistics page (http://www.orafaq.com/wiki/Forum_Statistics) has been updated with the last quarter data and so the whole 2007 ones.

Sorry for the delay.

Regards
Michel

Report message to a moderator

Re: Site statistics [message #294043 is a reply to message #294033]

Wed, 16 January 2008 04:16

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

There's a "Registered members per country" graph; I know that we are puny and can't fit in there (except among the "others"), but - would it be possible for you to count members located in Croatia, please?

Also, hahaha!, there's a typo in that graph - you've named a group as "Unkwown" instead of "Unknown" Smile

Smile

Report message to a moderator

Re: Site statistics [message #294062 is a reply to message #294043]

Wed, 16 January 2008 05:15

Frank
Messages: 7901
Registered: March 2000

Senior Member

Unkwown are the people from the tiny kingdom Unkwow.
It is situated somewhere near Wellkwow

Report message to a moderator

Pages (6): [1 2 3 4 5 6 › »]

Previous Topic:	Problem with OraFAQ site performance
Next Topic:	OraFAQ Forum Guide

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 14:01:18 CST 2024