Home » Other » Suggestions & Feedback » Site statistics
Re: Site statistics [message #294067 is a reply to message #294043] Wed, 16 January 2008 05:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
you've named a group as "Unkwown" instead of "Unknown"

Thanks I will fix that in the next update.

Quote:
it be possible for you to count members located in Croatia, please?

You have the full statistics in the zip file you can download at bottom of the page.

COUNTRY                              NB_MEMBER  %TOTAL       RANK    %ASK %ANSWER   %BOTH
----------------------------------- ---------- ------- ---------- ------- ------- -------
Croatia                                     30    0.05         86    1.01   96.97    2.02

Regards
Michel

[Updated on: Thu, 10 July 2008 14:29]

Report message to a moderator

Re: Site statistics [message #294074 is a reply to message #294067] Wed, 16 January 2008 06:13 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Thank you, Michel!

I've noticed the ZIP file, but didn't download it (I thought it was the same as presented on the net, i.e. no additional information). My mistake, sorry!
Re: Site statistics [message #294088 is a reply to message #294074] Wed, 16 January 2008 06:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I didn't want someone feel belittled and ignored because he/she is not in the top 10.

I will modify the page to specify that.

Regards
Michel

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

Report message to a moderator

Re: Site statistics [message #294094 is a reply to message #294088] Wed, 16 January 2008 07:41 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
But, my foot IS little ... Smile
Re: Site statistics [message #313204 is a reply to message #294033] Fri, 11 April 2008 01:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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.

To lighten the page I reduce the size of the images from 977x600 to 606x377, tell me if this is too much.

Regards
Michel

[Updated on: Fri, 11 April 2008 01:26]

Report message to a moderator

Re: Site statistics [message #313216 is a reply to message #313204] Fri, 11 April 2008 01:49 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Thank you for the update, Michel!

However, I was happier with larger images. These are quite small (especially these line graphs). I use 21" screen and Opera is my browser; it allows quite a nice zoom scaling, but - it is just too fuzzy to be able to easily read what's on these graphs.

So, in order to maintain both quality and page lightweight, could you split statistics to more pages? For example, on the first page you'd have "Member statistics", on the second page "Post statistics" (and, possibly, split this page into 2-3 pages (per continent, per country).
Re: Site statistics [message #313233 is a reply to message #313216] Fri, 11 April 2008 03:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is a good idea.
I will wait if there is other follow-up and do it as soon as I have a moment.

Regards
Michel
Re: Site statistics [message #313578 is a reply to message #313233] Sun, 13 April 2008 18:57 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I agree with Littlefoot concerning the image resolution. The labels on some of the graphs are getting close to being unreadable.

Again, thanks for your effort.

David
Re: Site statistics [message #332396 is a reply to message #313204] Tue, 08 July 2008 07:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Forum site statistics page has been updated.

Pictures have been enlarged and page split in two: statistics since the beginning in the first page, evolutions in the second one.

Regards
Michel
Re: Site statistics [message #332421 is a reply to message #332396] Tue, 08 July 2008 08:39 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
This link along with many links within Orafaq produces the following error in Firefox for me. Internet Exploiter does not produce this error, but that is not a product I use. anyone know the reason for the error?

A database error has occurred
Query: INSERT INTO `user` (user_id,user_name,user_password,user_newpassword,user_email,
user_email_authenticated,user_real_name,user_options,
user_token,user_registration) 
VALUES (NULL,'Joy_division','','','',NULL,'','quickbar=1
underline=2
cols=80
rows=25
searchlimit=20
contextlines=5
contextchars=50
skin=orafaq
math=1
rcdays=7
rclimit=50
highlightbroken=1
stubthreshold=0
previewontop=1
editsection=1
editsectiononrightclick=0
showtoc=1
showtoolbar=1
date=0
imagesize=2
thumbsize=2
rememberpassword=0
enotifwatchlistpages=0
enotifusertalkpages=1
enotifminoredits=0
enotifrevealaddr=0
shownumberswatching=1
fancysig=0
externaleditor=0
externaldiff=0
showjumplinks=1
numberheadings=0
uselivepreview=0
variant=en
language=en
searchNs0=1','4ed888f7856d61e466ce83bd5300c126','20080708133702')
Function: User::addToDatabase
Error: 1062 Duplicate entry 'Joy_division' for key 2 (localhost)

Backtrace:

    * GlobalFunctions.php line 602 calls wfbacktrace()
    * Database.php line 473 calls wfdebugdiebacktrace()
    * Database.php line 419 calls databasemysql::reportqueryerror()
    * Database.php line 1023 calls databasemysql::query()
    * User.php line 1454 calls databasemysql::insert()
    * AuthFudforum.php line 135 calls user::addtodatabase()
    * - line - calls auth_fudforum_autologin_hook()
    * Hooks.php line 114 calls call_user_func_array()
    * Setup.php line 227 calls wfrunhooks()
    * index.php line 80 calls require_once()

[Updated on: Thu, 10 July 2008 14:29] by Moderator

Report message to a moderator

Re: Site statistics [message #332426 is a reply to message #332421] Tue, 08 July 2008 08:56 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
No problem here, also using FF:
Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9) Gecko/2008061004 Firefox/3.0

Weird thing your username is capitalized, or is that your user for the 'rest' of OraFAQ?
Re: Site statistics [message #332461 is a reply to message #332426] Tue, 08 July 2008 10:30 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
Also no problem here using:

Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.15) Gecko/20080623 Firefox/2.0.0.15

Perhaps the problem is related to the case difference and the feature that automatically logs you in from the forum to the wiki. Perhaps your usernames for each are different due to the case of the first letter and that creates some sort of conflict.
Re: Site statistics [message #332496 is a reply to message #332461] Tue, 08 July 2008 13:05 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Barbara Boehmer wrote on Tue, 08 July 2008 11:30

Perhaps the problem is related to the case difference and the feature that automatically logs you in from the forum to the wiki. Perhaps your usernames for each are different due to the case of the first letter and that creates some sort of conflict.



Maybe Frank Naude can tell us that. I always user lower case for anything other than having to write grammatically correct sentences, so I don't know how it could have been set that way.

Oh well, I'm sure we'll have an answer soon.

I am using Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9) Gecko/2008052906 Firefox/3.0
Re: Site statistics [message #332508 is a reply to message #332496] Tue, 08 July 2008 14:56 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Yes, it is most likely a case problem. Wiki's like to initcap page names (including user names). So, it thinks your username is "Joy_division" while it's registered as "joy_division" in the forum's database. I'll try to fix it later today or sometime tomorrow.

Best regards.

Frank
Re: Site statistics [message #333184 is a reply to message #332396] Thu, 10 July 2008 14:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I modified the last chart in Forum site statistics.

Regards
Michel
Re: Site statistics [message #352381 is a reply to message #332396] Tue, 07 October 2008 07:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Forum site statistics page has been updated.

A new chart has been added: "Forum activity along the day".

Regards
Michel
Re: Site statistics [message #352513 is a reply to message #352381] Wed, 08 October 2008 02:26 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Michel Cadot
"Forum activity along the day".

I like this one!
Re: Site statistics [message #352519 is a reply to message #352513] Wed, 08 October 2008 02:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Littlefoot wrote on Wed, 08 October 2008 09:26
Michel Cadot
"Forum activity along the day".

I like this one!

Ana gave me the idea to create it asking me if I don't think there are more questions in my daytime (GMT+2) than in his (GMT-7).

If someone has an other idea or wish, it is open.

Regards
Michel

Re: Site statistics [message #379902 is a reply to message #352381] Thu, 08 January 2009 05:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Forum site statistics page has been updated.

Embedding the old site (and years 1998 to 2000) leads to some changes (France get out top 10 member list whereas South Africa enters, for instance).
There is no information about poster IP in old site posts so all posts have "Unknown" localization.

Also I added Total posts (red line) in Posts line charts.

Regards
Michel
Re: Site statistics [message #379906 is a reply to message #379902] Thu, 08 January 2009 05:36 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
We have almost 30.000 members who have never posted a single message! Why did they register? Reading is "free", you don't have to register in order to read. (Yes, I remember discussion about "inactive" members and no, I'm not reviving it).
Re: Site statistics [message #379911 is a reply to message #379906] Thu, 08 January 2009 06:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Actually the position is better than 3 months ago:
0 post: 40.1% -> 39.3%
1 post: 30.8% -> 31.2%
2-3 posts: 17.3% -> 17.6%

So some started to post.

Regards
Michel
Re: Site statistics [message #379917 is a reply to message #379911] Thu, 08 January 2009 07:07 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
LOL!

If we imagine that a "regular" visitor who also posts messages (I believe there are people who read, but do not write much) managed to produce > 15 messages during his/her OraFAQ Forum lifetime, that makes
  74567 (total number of current members) (a sequence - 4567!)
- 71709 (number of users who posted <= 15 messages)
-------
=  2858
members. That makes less than 4%. Scary!
Re: Site statistics [message #397200 is a reply to message #379902] Thu, 09 April 2009 06:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Forum site statistics page has been updated.

2009 starts slowly as 2008 ended but March shows an increase in posts and registrations.

Regards
Michel

[Updated on: Thu, 09 April 2009 06:54]

Report message to a moderator

Re: Site statistics [message #398249 is a reply to message #397200] Wed, 15 April 2009 14:06 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Excellent report.

Babu
Re: Site statistics [message #412821 is a reply to message #397200] Sun, 12 July 2009 10:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Forum site statistics page has been updated with new charts: number of posts and topics each day of the week during these last 3 months.

Regards
Michel
Seven views of Olduvai Gorge [message #412890 is a reply to message #412821] Mon, 13 July 2009 04:58 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Here's another view of the same statistics:

/forum/fa/6522/0/

So what do we see (actually, what I found interesting): I somehow expected Africa and Oceania not to be at the top of Oracle user's list. However, what database do people in South America use? Also, knowing that China makes 1/6 of human population, which database do they prefer?

Does low number of OraFAQ members from these parts of the world mean that they don't use Oracle (or perhaps do use it, but visit other forums) or the fact that languages they speak do not include English (for example, Portuguese in Brazil, Chinese in China, etc.)?

US being at the top of the "number of posts" list was expected; after all, Oracle headquarters are in the US. India is on a high 2nd place, leaving France (khm, Michel Cadot Smile) far behind at the third place. Does it mean that India is a growing market (which will even raise its portion) or ... what? Germany is being outnumbered, but OK - they probably prefer SAP. Right? (Wrong?)

What else do you see? I mean, now we have statistics, but how do we interpret them?
Re: Seven views of Olduvai Gorge [message #414027 is a reply to message #412890] Mon, 20 July 2009 02:48 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Nice graphics.
The thing is, however, that the IP-address is not always telling the location of the people. It might be that they are proxied from another country. (eg at my workplace I use UK and US-based proxies)
Re: Seven views of Olduvai Gorge [message #414273 is a reply to message #414027] Tue, 21 July 2009 05:40 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Right, but that's what we have /forum/fa/3314/0/. Even if the statistics are wrong, they look nice /forum/fa/2944/0/
Re: Site statistics [message #437853 is a reply to message #412821] Wed, 06 January 2010 04:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Forum site statistics page has been updated and contains data for whole 2009.

Regards
Michel
Re: Site statistics [message #437860 is a reply to message #437853] Wed, 06 January 2010 05:13 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I didn't check exact figures, but graphs suggest the following: in 2009, there were less newly registered members and less messages than in previous three years. Why is that so, what do you think? Global recession? People turned to other databases? People turned to other Oracle forums? Semi-hostile OraFAQ Forum environment (don't do this and don't do that, and if you already did it, you did it wrong)? Something else?
Re: Site statistics [message #437883 is a reply to message #437860] Wed, 06 January 2010 06:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Frank did the same remark last year.
There is global recession in posts in all forums I follow including my own ones.
Here's my post statistics, as you can see, it is half what it was in 2007 which means about 7000 less in a year.
/forum/fa/7272/0/

There was also less questions from Indian people (and so less answers) maybe I have some part on this hunting those who just want others to make their job and don't want to learn anything.

Regards
Michel
  • Attachment: myPosts.JPG
    (Size: 53.32KB, Downloaded 1196 times)
Re: Site statistics [message #437885 is a reply to message #437883] Wed, 06 January 2010 06:09 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
There was also less questions from Indian people (and so less answers) maybe I have some part on this hunting those who just want others to make their job and don't want to learn anything.

Is that really true?

sriram Smile
Re: Site statistics [message #437887 is a reply to message #437885] Wed, 06 January 2010 06:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is that really true?

Which part?

Regards
Michel
Re: Site statistics [message #437894 is a reply to message #437887] Wed, 06 January 2010 07:05 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
those who just want others to make their job and don't want to learn anything.


sriram Smile
Re: Site statistics [message #437895 is a reply to message #437887] Wed, 06 January 2010 07:05 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

The strange thing is that we had more visitors in 2009 than in 2008, but fewer users bothered to register or post something.

Also note that the downturn is not only affecting OraFAQ. The number of posts to the Oracle USENET groups and oracle-l list is also down significantly.

Possible interpretations:

1. Oracle is more stable and feature complete and less users are having problems with it.

2. Oracle is declining in popularity (for example, users may turn to other commercial or even open source solutions).

3. Oracle projects all over the world are 'suspended' because of the financial situation and will pick up then the world's economy starts to turn for the better.

4. People prefer BLOGS to FORUMS and are more likely to read and respond to them.

Any other possible explanations? Please share them with us.

Best regards.

Frank
Re: Site statistics [message #437992 is a reply to message #437860] Wed, 06 January 2010 12:21 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Littlefoot wrote on Wed, 06 January 2010 06:13
Semi-hostile OraFAQ Forum environment (don't do this and don't do that, and if you already did it, you did it wrong)? Something else?


This is an excellent topic. An off-topic discussion on speculations. I like it!

Before I even got to Littlefoot's line about the semi-hostile responses, I was thinking that same thing, but thinking harder, I doubt that had any impact. I think the number of people who may turn away will be dwarfed by the number of new people who come in to just look around.
I think maybe we can call it "stabilizing." Maybe more people are searching and finding their answers. Maybe more people are just looking around without any intention to ask or answer. I do that on some forums. I know there are some forums you have to join just to do a search.
It would also be that there was a core group of people who were asking questions and they exhausted most of their questions.

Re: Site statistics [message #438029 is a reply to message #437992] Wed, 06 January 2010 20:24 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Yep, I see only two possible interpretations of more visitors and fewer posts:

1. People are leaving WITH answers because:
1a - There are more answers than there were in previous years
1b - More people are encouraged to Search First by the banner

2. People are leaving WITHOUT answers and without asking because:
2a - They can't be bothered registering / asking. Very possible with increasing density of instant-gratification-Gen-Y-ers in the pool.
2b - They are scared off by responses they have read

I actually think 2b is implausible, because the sort of people that might be scared off are those that wouldn't search and wouldn't see anything to be scared by.

2a is similarly implausible: demographics just don't change that quickly.

So the good news is that - in my opinion - people are getting the help they need.
Re: Site statistics [message #438136 is a reply to message #438029] Thu, 07 January 2010 04:14 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Littlefoot wrote on Wed, 06 January 2010 12:13
People turned to other Oracle forums? Semi-hostile OraFAQ Forum environment (don't do this and don't do that, and if you already did it, you did it wrong)? Something else?
I'm afraid this can have an impact albeit not that huge. On the old forum (you know, the one without registration) the forum was a simple "ask a question, get an actual answer" thing. Nowadays, and this does not encourage me to post more, it is "ask a question, get 5 default answers asking to read this, do that, format here and search there" community. I even hesitate often to post an actual answer, because I didn't follow the forum that much and I couldn't figure out the "code of conduct". I do realize that I have contributed to the default "follow the rules" behaviour.

Don't get me wrong, I still believe it is good to have a set of basic rules, and to ask members to read them, but I also feel that perhaps we should go a little bit back to the roots: provide answers for people that have questions.

But, on the other hand, I might just as well be entirely wrong by thinking that this had any impact at all.

MHE

Edit: typo.

[Updated on: Thu, 07 January 2010 05:58]

Report message to a moderator

Re: Site statistics [message #438146 is a reply to message #438136] Thu, 07 January 2010 04:29 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I'm with @Maaher on this.

Almost every question posted here these days picks up posts of boilerplate text criticising the information provided by the OP and instructing people to read the guidelines.

This, combined with an increased tendency for people to insist on more details before even hazarding a guess at the answer to problems gives the site quite a hostile feeling at times.
Re: Site statistics [message #438153 is a reply to message #438136] Thu, 07 January 2010 04:48 Go to previous messageGo to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
To answer your report message concerning post http://www.orafaq.com/forum/mv/msg/153723/438122/102589/#msg_438122 and my answer.
We choosed that basic question should be answered by hints or pointers to documentation and not by full solution. "Its_me_ved" perfectly knows that and can obviously sees we are doing this in this topic but deliberately ignored it to post his solution as he already did in several posts (and sometimes without checking what he posted is correct, see his posts during the last couple of days).
Now we can change our mind and say we post solutions for an immediate "help" without thinking of the future.
It is of course more satisfying and far easier to get thanks because we give a (most often basic) solution than being ignored (at least) when we just give clues to help people to improve themselves.

Of course, this is just my opinion.

Regards
Michel

[Updated on: Thu, 07 January 2010 04:49]

Report message to a moderator

Previous Topic: Login issue
Next Topic: Email notifications of new comments - broken links
Goto Forum:
  


Current Time: Fri Mar 29 07:55:23 CDT 2024