The State of The Sponge

I notice that the blog just passed it's 80,000 page load since I started using Statcounter to monitor it, and that's just one day short of its first anniversary so it's time for stats.

Looking at the statistics for the last 1000 visits, one-third of them come from Google searches -- most seem to be to do with materialized views, oddly enough.

186 www.google.com   
77  tkyte.blogspot.com   
23  www.google.co.uk   
23  www.bloglines.com   
20  oracledoug.blogspot.com   
19  www.google.co.in   
14  www.google.com.au   
10  www.google.ca   
9   www.google.fr   
8   thinkoracle.blogspot.com   
7   blogs.oracle.com   
7   orawin.info   
6   www.google.de   
6   oradot.com   
6   www.rittman.net   
5   www.google.es   
5   www.blogger.com   
5   www.petefinnigan.com   
4   my5.statcounter.com   
4   www.google.be
4   www.google.it   
4   search.blogger.com   
4   www.newsgator.co.uk   
4   www.netvibes.com   
3   www.google.com.tr   
3   www.google.fi   
3   uk.my.yahoo.com   
3   www.edpadgett.com   
3   ora-dev.blogspot.com   
3   search.msn.com   
3   www.google.se   
2   www.google.com.sg   
2   www.google.co.il   
2   www.oracle-base.com   
2   www.google.ru   
2   www.google.ro   
2   www.google.ch   
2   search.yahoo.com   
2   pjs-random.blogspot.com   
2   www.google.ie
2   bloglines.com   
2   www.google.com.ph   
2   www.google.nl   
2   oracle-base.com   
2   discuss.joelonsoftware.com   
2   www.google.com.sg   
1   blogsearch.google.com   
1   www.dbasupport.com   
1   my2.statcounter.com   
1   oramossoracle.blogspot.com   
1   www.nomad8.com   
1   www.google.co.za   
1   my.yahoo.com   
1   www.google.com.tw   
1   www.google.com.hk   
1   www.google.pl   
1   www.google.co.kr   
1   tkyte-test.blogspot.com   
1   www.google.is   
1   www.google.cl
1   idyller.blogspot.com   
1   www.google.com.ar   
1   www.google.co.jp   
1   peec2006.blogspot.com   
1   www.google.com.br   
1   www.google.gr   
1   portal.umbrialistens.com   
1   www.google.co.ve   
1   kdsatplay.blogspot.com   
1   www.google.dk   
1   www.google.com.eg   
1   oraqa.com   
1   www.google.com.co   
1   ambigramania.blogspot.com   
1   www.google.pt   
1   www.surfwax.com   
1   www.google.com.mx   
1   www.alltheweb.com

Fifty-two countries are represented, if we ignore the unknowns ...

402 41.66%   United States
132 13.68%   United Kingdom
80   8.29%   Canada
60   6.22%   Lithuania
39   4.04%   Netherlands
37   3.83%   India
26   2.69%   Australia
20   2.07%   Germany
17   1.76%   France
15   1.55%   Switzerland
13   1.35%   Spain
11   1.14%   Unknown   -
9    0.93%   Russian Federation
8    0.83%   Belgium
7    0.73%   Turkey
7    0.73%   Japan
6    0.62%   Norway
6    0.62%   Denmark
5    0.52%   Portugal
4    0.41%   United Arab Emirates
4    0.41%   Italy
4    0.41%   Sweden
4    0.41%   Israel
3    0.31%   Colombia
3    0.31%   Greece
3    0.31%   Singapore
2    0.21%   Romania
2    0.21%   Philippines
2    0.21%   Poland
2    0.21%   Austria
2    0.21%   Ireland
2    0.21%   Serbia And Montenegro
2    0.21%   Finland
2    0.21%   Latvia
2    0.21%   Bolivia
2    0.21%   Uruguay
2    0.21%   Argentina
2    0.21%   South Africa
2    0.21%   Puerto Rico
1    0.10%   Pakistan
1    0.10%   Bulgaria
1    0.10%   Estonia
1    0.10%   Kenya
1    0.10%   Chile
1    0.10%   Andorra
1    0.10%   Ukraine
1    0.10%   Iceland
1    0.10%   New Zealand
1    0.10%   Egypt
1    0.10%   Brazil
1    0.10%   Slovenia
1    0.10%   Korea, Republic Of
1    0.10%   Hong Kong

Good to see the Netherlands up there this time! Readership seems to be up to 13 Dutch people, unless some of them are cheating and using multiple computers.

The most frequently occuring city for Sponge readers is London, UK, then Calgary, Ontario, Arlington, Nieuwegein ...

The most popular article is "Writing Good SQL". It's a perennial favourite with the Google crowd.

That's all -- back to work people!