Re: Site statistics [message #294067 is a reply to message #294043] |
Wed, 16 January 2008 05:39 |
|
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 #313216 is a reply to message #313204] |
Fri, 11 April 2008 01:49 |
|
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 #332421 is a reply to message #332396] |
Tue, 08 July 2008 08:39 |
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 |
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 #332496 is a reply to message #332461] |
Tue, 08 July 2008 13:05 |
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 |
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Seven views of Olduvai Gorge [message #412890 is a reply to message #412821] |
Mon, 13 July 2009 04:58 |
|
Littlefoot
Messages: 21806 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Here's another view of the same statistics:
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 ) 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 |
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: Site statistics [message #437895 is a reply to message #437887] |
Wed, 06 January 2010 07:05 |
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 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
Littlefoot wrote on Wed, 06 January 2010 06:13Semi-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 |
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 |
|
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
Littlefoot wrote on Wed, 06 January 2010 12:13People 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 |
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 |
|
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
|
|
|