Home » Other » Suggestions & Feedback » Site statistics
Site statistics [message #237974] Wed, 16 May 2007 04:11 Go to next message
Michel Cadot
Messages: 60060
Registered: March 2007
Location: Nanterre, France, http://...
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 2 one registered in Paris/France, the other in NY/USA) but it is statistically acceptable.

Regards
Michel
Re: Site statistics [message #238002 is a reply to message #237974] Wed, 16 May 2007 05:50 Go to previous messageGo to next message
Frank Naude
Messages: 4420
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.
Re: Site statistics [message #238014 is a reply to message #237974] Wed, 16 May 2007 06:16 Go to previous messageGo to next message
Frank
Messages: 7880
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..
Re: Site statistics [message #238075 is a reply to message #238014] Wed, 16 May 2007 11:03 Go to previous messageGo to next message
Littlefoot
Messages: 19901
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.
Re: Site statistics [message #238090 is a reply to message #238075] Wed, 16 May 2007 12:34 Go to previous messageGo to next message
Frank
Messages: 7880
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?
Re: Site statistics [message #238272 is a reply to message #238090] Thu, 17 May 2007 04:55 Go to previous messageGo to next message
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.
Re: Site statistics [message #238293 is a reply to message #238272] Thu, 17 May 2007 06:14 Go to previous messageGo to next message
Littlefoot
Messages: 19901
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? ./fa/1986/0/
Re: Site statistics [message #238306 is a reply to message #237974] Thu, 17 May 2007 06:41 Go to previous messageGo to next message
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?)
Re: Site statistics [message #238316 is a reply to message #237974] Thu, 17 May 2007 07:04 Go to previous messageGo to next message
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!
Re: Site statistics [message #238325 is a reply to message #238306] Thu, 17 May 2007 07:19 Go to previous messageGo to next message
Maaher
Messages: 7055
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
Re: Site statistics [message #238330 is a reply to message #237974] Thu, 17 May 2007 07:29 Go to previous messageGo to next message
hobbes
Messages: 173
Registered: January 2006
Senior Member
./fa/1581/0/ Yay! Thank you, Maaher.

For you, Littlefoot: ./fa/1578/0/
Re: Site statistics [message #242455 is a reply to message #237974] Sat, 02 June 2007 04:30 Go to previous messageGo to next message
Michel Cadot
Messages: 60060
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Site statistics [message #242467 is a reply to message #242455] Sat, 02 June 2007 08:03 Go to previous messageGo to next message
Littlefoot
Messages: 19901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That is absolutely ... amazing ./fa/451/0/ WOW! Marvelous, Michel, m a r v e l o u s !!!
Re: Site statistics [message #242539 is a reply to message #242467] Sun, 03 June 2007 13:31 Go to previous messageGo to next message
Michel Cadot
Messages: 60060
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for your comment, I really appreciate it.

Regards
Michel

Re: Site statistics [message #250032 is a reply to message #242539] Sat, 07 July 2007 02:54 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Another amazing statistic: 18914 users took the time to register but never made a single post..
Re: Site statistics [message #250049 is a reply to message #250032] Sat, 07 July 2007 06:53 Go to previous messageGo to next message
Frank Naude
Messages: 4420
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.
Re: Site statistics [message #251580 is a reply to message #250049] Sun, 15 July 2007 01:50 Go to previous messageGo to next message
Michel Cadot
Messages: 60060
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Site statistics [message #251599 is a reply to message #251580] Sun, 15 July 2007 06:48 Go to previous messageGo to next message
Frank
Messages: 7880
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

[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 Go to previous messageGo to next message
Michel Cadot
Messages: 60060
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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
Re: Site statistics [message #253075 is a reply to message #253069] Sun, 22 July 2007 03:09 Go to previous messageGo to next message
Michel Cadot
Messages: 60060
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Here's what I have until 07/07/07: 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
Re: Site statistics [message #253079 is a reply to message #253075] Sun, 22 July 2007 03:25 Go to previous messageGo to next message
Michel Cadot
Messages: 60060
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you wants 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
Re: Site statistics [message #254898 is a reply to message #237974] Mon, 30 July 2007 00:39 Go to previous messageGo to next message
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.
Re: Site statistics [message #254915 is a reply to message #254898] Mon, 30 July 2007 01:20 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Posting here is not a competition. It is about helping others, not to get more posts than someone else.
Re: Site statistics [message #254937 is a reply to message #254915] Mon, 30 July 2007 01:58 Go to previous messageGo to next message
Littlefoot
Messages: 19901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That's what YOU think ./fa/1986/0/

Re: Site statistics [message #254938 is a reply to message #254898] Mon, 30 July 2007 02:00 Go to previous messageGo to next message
Michel Cadot
Messages: 60060
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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.
Re: Site statistics [message #258974 is a reply to message #237974] Tue, 14 August 2007 00:07 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I think it's the time to update statistics.


Thanks Michel.
Re: Site statistics [message #258989 is a reply to message #258974] Tue, 14 August 2007 01:17 Go to previous messageGo to next message
Michel Cadot
Messages: 60060
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Site statistics [message #272801 is a reply to message #258989] Sun, 07 October 2007 10:45 Go to previous messageGo to next message
Michel Cadot
Messages: 60060
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Statistics page have been updated with the last quarter data.

Regards
Michel
Re: Site statistics [message #272811 is a reply to message #272801] Sun, 07 October 2007 14:01 Go to previous messageGo to next message
Frank Naude
Messages: 4420
Registered: April 1998
Senior Member
Thanks Michel. A sterling job as usual!
Re: Site statistics [message #272823 is a reply to message #237974] Sun, 07 October 2007 22:46 Go to previous messageGo to next message
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.
Re: Site statistics [message #272826 is a reply to message #237974] Sun, 07 October 2007 23:16 Go to previous messageGo to next message
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%.
Re: Site statistics [message #272860 is a reply to message #272826] Mon, 08 October 2007 01:26 Go to previous messageGo to next message
Michel Cadot
Messages: 60060
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Site statistics [message #272868 is a reply to message #237974] Mon, 08 October 2007 01:42 Go to previous messageGo to next message
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.
Re: Site statistics [message #272914 is a reply to message #272868] Mon, 08 October 2007 02:57 Go to previous messageGo to next message
Michel Cadot
Messages: 60060
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Site statistics [message #273017 is a reply to message #272914] Mon, 08 October 2007 12:29 Go to previous messageGo to next message
Littlefoot
Messages: 19901
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).
Re: Site statistics [message #294033 is a reply to message #273017] Wed, 16 January 2008 02:56 Go to previous messageGo to next message
Michel Cadot
Messages: 60060
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Site statistics [message #294043 is a reply to message #294033] Wed, 16 January 2008 04:16 Go to previous messageGo to next message
Littlefoot
Messages: 19901
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
Re: Site statistics [message #294062 is a reply to message #294043] Wed, 16 January 2008 05:15 Go to previous messageGo to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Unkwown are the people from the tiny kingdom Unkwow.
It is situated somewhere near Wellkwow
Previous Topic: PM not working due to insufficient space
Next Topic: SQL*Plus FAQ for client tools forum
Goto Forum:
  


Current Time: Fri Dec 26 06:57:17 CST 2014

Total time taken to generate the page: 0.15899 seconds