Statistics for comp.databases.informix

Statistics for comp.databases.informix

Post by Dr. Pabl » Mon, 05 May 2003 16:30:45



Following is a summary of articles spanning a 30 day period,
beginning at 01 Apr 2003 and ending at 30 Apr 2003

Notes
=====

    - A line in the body of a post is considered to be original if it
      does *not* match the regular expression /^\s{0,3}(?:>|:|\S+>|\+\+)/.
    - All text after the last cut line (/^-- $/) in the body is
      considered to be the author's signature.
    - The scanner prefers the Reply-To: header over the From: header
      in determining the "real" e-mail address and name.
    - Original Content Rating (OCR) is the ratio of the original content
      volume to the total body volume.
NOTE  If you reply to a 10 line question with a 2 line answer, then your
      conscience can remain be clear. Be honest with yourself.
    - Find the News-Scan distribution on the CPAN!
      <URL:http://www.perl.com/CPAN/modules/by-module/News/>
      Please send all comments to Greg Bacon <gba...@cs.uah.edu>.
    - Please do not send comments about the use of this software in your
      favourite newsgroup to Greg Bacon! He is not responsible for others.
    - Copyright (c) 1998 Greg Bacon.  All Rights Reserved.
      Verbatim copying and redistribution is permitted without royalty;
      alteration is not permitted.  Redistribution and/or use for any
      commercial purpose is prohibited.

Excluded Posters
================

Totals
======

Posters:  359
Articles: 1071 (168 with cutlined signatures)
Threads:  349
Volume generated: 2901.7 kb
    - headers:     824.5 kb (17,401 lines)
    - bodies:     2024.8 kb (58,085 lines)
    - original:   1005.2 kb (30,037 lines)
    - signatures:   51.4 kb (1,225 lines)

Original Content Rating: 0.496

Averages
========

Posts per poster: 3.0
    median: 1 post
    mode:   1 post - 207 posters
    s:      5.2 posts
Posts per thread: 3.1
    median: 2 posts
    mode:   1 post - 125 threads
    s:      3.1 posts
Message size: 2774.4 bytes
    - header:      788.3 bytes (16.2 lines)
    - body:       1936.0 bytes (54.2 lines)
    - original:    961.0 bytes (28.0 lines)
    - signature:    49.1 bytes (1.1 lines)

Top 10 Posters by Number of Posts
=================================

         (kb)   (kb)  (kb)  (kb)
Posts  Volume (  hdr/ body/ orig)  Address
-----  --------------------------  -------

   53   139.6 ( 52.9/ 77.7/ 33.7)  Jonathan Leffler
   44    87.9 ( 36.3/ 51.5/ 17.9)  Art S. Kagel
   30    64.3 ( 26.0/ 32.1/  6.4)  Paul Watson
   28    39.1 ( 19.8/ 19.3/  3.9)  Obnoxio The Clown
   24    48.2 ( 16.7/ 17.6/  6.1)  Mark D. Stock
   21    50.5 ( 16.5/ 33.9/ 15.2)  ste...@weideneder.de
   19   129.6 ( 15.5/114.2/  9.2)  Madison Pruet
   18    51.2 ( 12.6/ 38.6/ 12.0)  Jack Parker
   17    40.9 ( 14.2/ 26.7/  8.4)  David Williams
   17    39.6 ( 12.1/ 27.4/  7.9)  Tsutomu Ogiwara

These posters accounted for 25.3% of all articles.

Top 10 Posters by Volume
========================

  (kb)   (kb)  (kb)  (kb)
Volume (  hdr/ body/ orig)  Posts  Address
--------------------------  -----  -------

 139.6 ( 52.9/ 77.7/ 33.7)     53  Jonathan Leffler
 129.6 ( 15.5/114.2/  9.2)     19  Madison Pruet
  98.0 (  4.8/ 93.2/ 38.8)      4  Tisha Shirah
  87.9 ( 36.3/ 51.5/ 17.9)     44  Art S. Kagel
  68.9 (  7.9/ 60.9/ 22.2)     10  Kirk S
  64.3 ( 26.0/ 32.1/  6.4)     30  Paul Watson
  56.2 (  0.7/ 55.5/  0.1)      1  vivek.chaudh...@st.com
  55.4 (  2.1/ 53.4/  2.0)      3  james.ch...@jbcconsulting.com
  51.8 (  0.7/ 51.1/ 51.1)      1  Tisha
  51.2 ( 12.6/ 38.6/ 12.0)     18  Jack Parker

These posters accounted for 27.7% of the total volume.

Top 10 Posters by OCR (minimum of five posts)
==============================================

         (kb)    (kb)
OCR      orig /  body  Posts  Address
-----  --------------  -----  -------

1.000  (  1.5 /  1.5)      6  Vladislav Bukreyev
1.000  (  1.1 /  1.1)      5  web_djs
0.989  ( 38.5 / 38.9)      5  Jonathan Leffler
0.893  (  5.9 /  6.7)      5  rastislav.ja...@dignitas.sk
0.781  (  4.6 /  5.9)      5  Thomas Ronayne
0.735  (  4.9 /  6.6)      7  moss...@wellsfargo.com
0.709  ( 15.2 / 21.5)      8  r...@vorbroker.com
0.673  (  4.8 /  7.1)     10  rkusenet
0.657  ( 17.4 / 26.5)      5  Mike ODell
0.627  ( 16.3 / 26.0)     12  Simmons, Keith

Bottom 10 Posters by OCR (minimum of five posts)
=================================================

         (kb)    (kb)
OCR      orig /  body  Posts  Address
-----  --------------  -----  -------

0.206  (  1.8 /  8.9)      5  The Big Potatoe
0.206  (  1.9 /  9.2)      7  Jay Aymond
0.202  (  3.9 / 19.3)     28  Obnoxio The Clown
0.199  (  1.2 /  6.2)      6  Impy
0.199  (  6.4 / 32.1)     30  Paul Watson
0.156  (  2.0 / 12.9)      5  cats_five@[127.0.0.1]
0.129  (  1.4 / 10.6)      9  John Carlson
0.118  (  0.8 /  6.7)      5  Preetinder Dhaliwal
0.101  (  0.7 /  7.0)      6  Praveen Tummala
0.080  (  9.2 /114.2)     19  Madison Pruet

Top 10 Largest Signatures
=========================

 (bytes)      
  size / lines  Posts Signed  Address
--------------  ----- ------  -------

( 7503 /  134)      7      1  John_Tho...@ao.uscourts.gov
( 2102 /   63)      6      6  Vladislav Bukreyev
(  791 /   33)      2      2  Thomas.Mieslin...@gls-germany.com
(  594 /   13)     24     24  Mark D. Stock
(  591 /   10)     11      3  Francisco Roldan
(  399 /    9)      2      2  Marco Greco
(  381 /    6)      2      2  Richard Spitz
(  339 /    8)     53     53  Jonathan Leffler
(  314 /    6)      2      2  sco...@dinecollege.edu
(  278 /    7)      5      2  Jonathan Leffler

if you quote previous article in a non-standard way, it may look
like you have a signature containing more text than reality.

55 posters (15%) had at least five posts.

Top 10 Threads by Number of Posts
=================================

Posts  Subject
-----  -------

   28  Another RAID question
   24  Are Informix Servers Dead?
   20  Case-insensitive search
   13  Need help tunning AIO/CPU vps
   13  Data Modeling "the third way ?"
   13  SPL Question
   12  long checkpoint
   11  Does informix truncate space automatically ?
   11  Informix in the news
   11  Can someone point me in the right direction

These threads accounted for 14.6% of all articles.

Top 10 Threads by Volume
========================

  (kb)   (kb)  (kb)  (kb)
Volume (  hdr/ body/ orig)  Posts  Subject
--------------------------  -----  -------

 313.2 ( 11.8/301.0/101.1)     13  Need help tunning AIO/CPU vps
 100.7 ( 18.4/ 82.0/ 40.5)     24  Are Informix Servers Dead?
  65.2 (  8.1/ 56.6/ 20.2)     10  Cuestino about define in 4gl
  56.2 (  0.7/ 55.5/  0.1)      1  Re: Need help tunning AIO/CPU vps
  51.1 ( 10.4/ 40.4/ 19.4)     13  Data Modeling "the third way ?"
  49.5 ( 21.7/ 25.8/  9.4)     28  Another RAID question
  38.7 (  9.3/ 28.7/  8.1)     10  Difficulty Accessing Informix From Cron (was: Perl)
  38.2 ( 18.4/ 18.3/  7.0)     20  Case-insensitive search
  36.8 (  8.4/ 28.4/ 14.3)     10  unusual FOREACH problem
  34.5 (  1.5/ 32.9/ 19.2)      2  =?Big5?B?pXjGV6ZhsM84MDC4VaFBt8e9VLJ2OTUlqrq2bKXzpmGnfajPpc4=?=

These threads accounted for 27.0% of the total volume.

Top 10 Threads by OCR (minimum of five posts)
==============================================

         (kb)    (kb)
OCR      orig /  body  Posts  Subject
-----  --------------  -----  -------

0.848  (  0.8/   0.9)      5  Does Informix work under Windoze?
0.831  (  2.1/   2.5)      5  XML parser for 4gl
0.779  (  3.2/   4.1)      7  Dropping all tables from a db
0.771  (  2.2/   2.9)      6  Urgent Informix support
0.683  (  7.2/  10.5)     10  sqlcmd OUTPUT syntax?
0.676  (  5.3/   7.8)      6  on key(interrupt)
0.655  (  1.8/   2.7)      5  shmget:[[EExists][17]: Key 52564801
0.639  (  1.8/   2.8)      5  Multiple instances on the same box
0.636  (  6.9/  10.8)      6  unloading data into a file up to 2GB only?
0.614  (  1.1/   1.8)      5  IDS 9.4 install on RED HAT 8.0

Bottom 10 Threads by OCR (minimum of five posts)
=================================================

         (kb)    (kb)
OCR      orig /  body  Posts  Subject
-----  --------------  -----  -------

0.300  (  6.3 / 20.9)      6  how to trace the process that updates a table
0.293  (  3.8 / 13.1)     10  0-level archive > 2 Gb
0.284  (  8.1 / 28.7)     10  Difficulty Accessing Informix From Cron (was: Perl)
0.275  (  5.4 / 19.6)      5  ODBC performance
0.266  (  3.0 / 11.2)      6  failed restore on informix 7.3
0.248  (  5.6 / 22.5)      8  problem installing Informix on SCO
0.245  (  5.7 / 23.4)      9  create temp table: -261 Cannot create file for table - Not owner
0.232  (  4.9 / 21.0)     12  long checkpoint
0.219  (  2.2 / 10.3)      7  Installing IDS 9.4 on Suse-linux
0.168  (  1.9 / 11.5)      7  Raw chunks on Solaris

68 threads (19%) had at least five posts.

Top 10 Targets for Crossposts
=============================

Articles  Newsgroup
--------  ---------

       7  comp.databases.oracle.misc
       2  comp.os.msdos
       2  alt.msdos
       2  microsoft.public.word.conversions
       2  comp.os.msdos.apps
       2  comp.databases.olap
       2  comp.databases.ms-sqlserver
       2  microsoft.public.vb.crystal
       2  comp.databases.oracle
       1  comp.databases.ibm-db2

Top 10 Crossposters
===================

Articles  Address
--------  -------

       6  Agron
       4  Craig
       4  lorabanks
       4  Robert Baer
       3  Jim Kennedy
       3  Manjunath
       2  Andy Hardy
       1  Ed Prochak
       1  John
       1  qwerty