Statistics for comp.databases.informix

Statistics for comp.databases.informix

Post by Dr. Pabl » Wed, 09 Jul 2003 09:49:19



Following is a summary of articles spanning a 31 day period,
beginning at 01 May 2003 00:18:27 GMT and ending at
31 May 2003 22:58:33 GMT.

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.
    - Modest enhancements by Dr. Pablo MD, PhD, IUD, Bach.Vet.Sci.

Totals
======

Posters:  358
Articles: 1221 (237 with cutlined signatures)
Threads:  339
Volume generated: 3164.7 kb
    - headers:    932.4 kb (19,684 lines)
    - bodies:     2144.6 kb (65,080 lines)
    - original:   1147.0 kb (36,636 lines)
    - signatures: 86.5 kb (2,127 lines)

Original Content Rating: 0.535

Averages
========

Posts per poster: 3.4
    median: 2.0 posts
    mode:   1 post - 162 posters
    s:      6.7 posts
Posts per thread: 3.6
    median: 2 posts
    mode:   1 post - 101 threads
    s:      4.4 posts
Message size: 2654.1 bytes
    - header:     782.0 bytes (16.1 lines)
    - body:       1798.6 bytes (53.3 lines)
    - original:   961.9 bytes (30.0 lines)
    - signature:  72.5 bytes (1.7 lines)

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

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

   64   145.2 ( 45.0/ 63.2/ 22.4)  Mark D. Stock
   55   144.1 ( 53.7/ 81.3/ 37.9)  Jonathan Leffler
   42   110.7 ( 36.8/ 65.0/  6.0)  p...@oninit.com
   37    89.2 ( 25.8/ 63.5/ 16.0)  Murray Wood
   29    51.2 ( 19.5/ 29.3/  6.3)  John Carlson
   26    43.3 ( 17.1/ 26.2/ 13.9)  rkusenet
   25    73.7 ( 17.5/ 56.2/ 10.7)  Jack Parker
   25    59.0 ( 17.9/ 41.0/ 10.2)  Neil Truby
   20    49.8 ( 16.9/ 32.9/  9.8)  ka...@bloomberg.net
   19    39.3 ( 13.6/ 25.7/  8.0)  Rob Vorbroker

These posters accounted for 28.0% of all articles.

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

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

 145.2 ( 45.0/ 63.2/ 22.4)     64  Mark D. Stock
 144.1 ( 53.7/ 81.3/ 37.9)     55  Jonathan Leffler
 110.7 ( 36.8/ 65.0/  6.0)     42  p...@oninit.com
  89.2 ( 25.8/ 63.5/ 16.0)     37  Murray Wood
  73.8 (  9.2/ 64.5/  5.8)     13  Tsutomu Ogiwara
  73.7 ( 17.5/ 56.2/ 10.7)     25  Jack Parker
  72.2 ( 18.0/ 54.2/ 28.4)     18  Michael Krzepkowski
  66.1 (  0.8/ 65.3/ 65.3)      1  Tim
  59.0 ( 17.9/ 41.0/ 10.2)     25  Neil Truby
  52.4 ( 11.4/ 41.0/ 11.1)     17  Bill Dare

These posters accounted for 28.0% of the total volume.

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

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

0.957  (  1.6 /  1.7)      6  Serge Rielau
0.950  (  5.8 /  6.1)      5  Brandt Edwin
0.944  ( 16.7 / 17.7)      8  Oxow
0.892  ( 19.7 / 22.1)      5  Tisha Shirah
0.888  ( 19.7 / 22.2)      6  Helen Wong
0.864  ( 23.3 / 27.0)      5  Jonathan Leffler
0.863  ( 12.3 / 14.3)      5  ja...@luzdelsur.com.pe
0.816  (  7.3 /  8.9)      9  Gustavo Tobares
0.815  (  1.3 /  1.6)      5  Ferro
0.796  ( 33.8 / 42.5)      6  Ernst Meyer

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

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

0.251  (  2.4 /  9.7)     10  David Williams
0.251  ( 16.0 / 63.5)     37  Murray Wood
0.248  ( 10.2 / 41.0)     25  Neil Truby
0.216  (  6.3 / 29.3)     29  John Carlson
0.208  (  0.9 /  4.3)      9  Obnoxio The Clown
0.200  (  3.2 / 16.1)      6  Greg Mitchell
0.190  ( 10.7 / 56.2)     25  Jack Parker
0.101  (  0.9 /  8.8)      5  sco...@dinecollege.edu
0.092  (  6.0 / 65.0)     42  p...@oninit.com
0.089  (  5.8 / 64.5)     13  Tsutomu Ogiwara

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

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

( 4857 /  108)      8      2  John_Tho...@ao.uscourts.gov
( 2992 /   89)      2      1  Mohan Natraj
( 1905 /   68)      3      1  e...@herber-consulting.de
( 1351 /   22)      1      1  Andrew Hamm
( 1233 /   22)     29      2  John Carlson
(  914 /   48)      4      4  Thomas.Mieslin...@gls-germany.com
(  593 /   12)     64     64  Mark D. Stock
(  483 /   10)      1      1  les...@advancedatatools.com
(  381 /    6)      2      2  Richard Spitz
(  348 /   13)      3      3  Clive Eisen

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

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

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

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

   31  Where to find dbselect()?
   22  Informix versus oracle
   21  Bloody ERP schema
   18  4GL Help
   17  Search by index vs. sequential scan
   16  a trigger question
   15  please revive project 4GL++, using 4gl for Windows and New Era
   14  Changing of owner of a table
   14  long transaction aborted
   13  problems installing informix 7.31 on aix

These threads accounted for 14.8% of all articles.

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

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

 105.9 (  9.1/ 96.8/ 29.0)     11  recurring high checkpoints on the 1st of the month
  97.8 ( 11.5/ 85.7/ 52.9)     13  problems installing informix 7.31 on aix
  75.5 ( 24.9/ 32.4/  9.9)     31  Where to find dbselect()?
  75.3 ( 17.0/ 58.3/ 25.1)     21  Bloody ERP schema
  74.1 (  2.8/ 71.0/ 17.9)      4  SNMP
  67.0 (  1.5/ 65.5/ 65.3)      2  HELP: Informix doesn't come up anymore
  62.1 (  5.1/ 57.1/ 11.0)      7  Performance & checkpoint
  47.5 ( 17.7/ 29.2/ 17.2)     22  Informix versus oracle
  45.7 ( 13.3/ 30.4/ 11.6)     17  Search by index vs. sequential scan
  41.1 (  5.7/ 35.4/ 20.8)      8  Technical Query

These threads accounted for 21.9% of the total volume.

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

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

1.000  (  7.1/   7.1)      6  REPLY NEEDED
0.999  ( 13.5/  13.5)      6  RELIABLE AND REPUTABLE PERSON
0.778  (  3.5/   4.5)      5  DB2 to Informix DB connectivity
0.728  (  7.3/  10.1)      6  IDS 7.31.UC2 Crashed...
0.710  (  6.3/   8.9)      6  [Fwd: Re: a trigger question]
0.709  ( 23.4/  33.1)      5  DBD::Informix Update statements crashing engine
0.706  (  3.8/   5.4)      5  How to get license number from CD
0.697  ( 10.0/  14.4)      8  Why it takes long
0.691  (  4.2/   6.0)      5  "Slow System"  Problem
0.680  (  3.6/   5.3)      7  Restore Level 0 NT

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

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

0.300  ( 29.0 / 96.8)     11  recurring high checkpoints on the 1st of the month
0.298  (  4.1 / 13.6)     10  ONTAPE backup on disk: limit of 2Gb
0.294  (  3.7 / 12.6)      6  Informix ODBC on AIX ??
0.270  (  1.9 /  7.1)     10  Link to a table on another DB
0.265  (  2.4 /  9.0)      5  Informix 9.4 fails on Red Hat: Beware of glibc-2.3.2-4.80
0.257  (  1.9 /  7.4)      9  Stored Programs/Triggers
0.248  (  3.3 / 13.2)     11  UK Companies Using Informix
0.237  (  6.6 / 28.0)      5  tables activity
0.216  (  2.8 / 12.8)      9  NUMCPUVPS on a box having multiple Informix Instances
0.193  ( 11.0 / 57.1)      7  Performance & checkpoint

85 threads (25%) had at least five posts.

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

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

       7  comp.lang.java.databases
       6  comp.databases.ibm-db2
       2  comp.databases.oracle.server
       2  comp.lang.perl.misc
       1  microsoft.public.vb.crystal

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

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

       3  Anthony Presley
       2  rkusenet
       2  Hans Forbrich
       2  Obnoxious the troll
       1  qwerty
       1  Fan Ruo Xin
       1  p...@oninit.com
       1  Bob Mariotti
       1  PM \(pm3iinc-nospam\)
       1  maroch...@gmx.de

 
 
 

Statistics for comp.databases.informix

Post by Dr. Pabl » Wed, 09 Jul 2003 09:50:22


Following is a summary of articles spanning a 30 day period,
beginning at 01 Jun 2003 00:09:06 GMT and ending at
30 Jun 2003 22:02:04 GMT.

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.
    - Modest enhancements by Dr. Pablo MD, PhD, IUD, Bach.Vet.Sci.

Totals
======

Posters:  318
Articles: 960 (149 with cutlined signatures)
Threads:  298
Volume generated: 2261.6 kb
    - headers:    755.6 kb (15,642 lines)
    - bodies:     1469.2 kb (44,200 lines)
    - original:   810.4 kb (24,580 lines)
    - signatures: 35.9 kb (877 lines)

Original Content Rating: 0.552

Averages
========

Posts per poster: 3.0
    median: 1.0 post
    mode:   1 post - 165 posters
    s:      5.0 posts
Posts per thread: 3.2
    median: 2.0 posts
    mode:   1 post - 105 threads
    s:      3.6 posts
Message size: 2412.3 bytes
    - header:     806.0 bytes (16.3 lines)
    - body:       1567.1 bytes (46.0 lines)
    - original:   864.5 bytes (25.6 lines)
    - signature:  38.3 bytes (0.9 lines)

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

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

   40   102.4 ( 39.7/ 56.0/ 29.4)  Jonathan Leffler
   32    81.9 ( 32.5/ 48.9/ 20.6)  Michael Krzepkowski
   27    56.1 ( 24.2/ 26.2/  4.0)  p...@oninit.com
   26    38.9 ( 16.8/ 22.1/  4.9)  John Carlson
   25    40.9 ( 18.1/ 22.8/  6.3)  Obnoxio The Clown
   22    32.7 ( 15.0/ 17.7/ 11.6)  rkusenet
   19    53.5 ( 14.6/ 38.9/ 18.6)  ka...@bloomberg.net
   18    36.1 ( 12.8/ 23.3/  9.3)  Tsutomu Ogiwara
   17    37.7 ( 12.0/ 15.6/  6.3)  Mark D. Stock
   16    28.4 ( 11.3/ 17.1/  5.7)  Rob Vorbroker

These posters accounted for 25.2% of all articles.

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

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

 102.4 ( 39.7/ 56.0/ 29.4)     40  Jonathan Leffler
  81.9 ( 32.5/ 48.9/ 20.6)     32  Michael Krzepkowski
  56.1 ( 24.2/ 26.2/  4.0)     27  p...@oninit.com
  53.5 ( 14.6/ 38.9/ 18.6)     19  ka...@bloomberg.net
  42.9 (  9.0/ 33.9/ 17.8)     11  Darrin Wolf
  40.9 ( 18.1/ 22.8/  6.3)     25  Obnoxio The Clown
  38.9 ( 16.8/ 22.1/  4.9)     26  John Carlson
  37.7 ( 12.0/ 15.6/  6.3)     17  Mark D. Stock
  36.9 (  0.6/ 36.3/ 29.5)      1  solobosoe...@aol.com
  36.1 ( 12.8/ 23.3/  9.3)     18  Tsutomu Ogiwara

These posters accounted for 23.3% of the total volume.

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

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

0.978  (  2.8 /  2.9)      7  John M
0.924  (  9.7 / 10.5)      6  Rajib Sarkar
0.906  ( 11.6 / 12.8)      5  Zunino, Kathy
0.864  (  9.8 / 11.3)      6  Gustavo Tobares
0.860  ( 13.9 / 16.2)      7  chris.stau...@reebok.com
0.785  (  2.7 /  3.5)      5  S. R. RAMANA
0.716  (  4.3 /  6.0)      7  kh teoh
0.662  (  7.2 / 10.9)      9  Smitty
0.656  ( 11.6 / 17.7)     22  rkusenet
0.627  (  4.9 /  7.8)      8  Ronald Cole

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

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

0.277  (  6.3 / 22.8)     25  Obnoxio The Clown
0.269  (  2.3 /  8.6)      5  malky
0.258  (  3.7 / 14.5)      8  The Big Potatoe
0.258  (  1.6 /  6.2)      6  Murray Wood \(IList\)
0.221  (  4.9 / 22.1)     26  John Carlson
0.184  (  1.3 /  7.0)      5  Andy Lennard
0.152  (  3.3 / 21.4)      6  ar
0.152  (  4.0 / 26.2)     27  p...@oninit.com
0.135  (  3.7 / 27.2)      8  Brice Avila
0.102  (  2.6 / 25.2)      9  Murray Wood

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

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

( 1267 /   45)      2      2  Thomas.Mieslin...@gls-germany.com
(  706 /    8)      2      1  Martin, Wayne E.
(  617 /   12)     17     17  Mark D. Stock
(  592 /   27)      1      1  Dan Guzman
(  508 /   11)      3      3  les...@advancedatatools.com
(  399 /    9)      1      1  Marco Greco
(  389 /   14)     32      1  Michael Krzepkowski
(  381 /    6)      1      1  Richard Spitz
(  291 /   12)      2      2  Clive Eisen
(  264 /   15)      1      1  Fred Pratt

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

51 posters (16%) had at least five posts.

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

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

   30  Informix versus oracle
   19  DATABASE QUESTION ! ! ! ! ! !
   18  interesting problem
   18  sql server -> informix
   16  Passport Advantage problems
   14  Table split into separate server and instance
   12  Does Informix OLEDB support OpenSchema?
   12  Command Line execution of sql statement
   12  long checkpoints
   11  Can pre-9.4 IDS really only use 2GB of a tape?

These threads accounted for 16.9% of all articles.

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

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

  69.4 ( 24.5/ 44.1/ 23.8)     30  Informix versus oracle
  68.0 (  6.1/ 61.6/ 17.6)      8  oninit dies without error on RedHat 9
  47.5 ( 16.2/ 30.6/ 15.3)     18  interesting problem
  39.9 (  9.1/ 30.8/ 11.4)     12  long checkpoints
  36.9 (  0.6/ 36.3/ 29.5)      1  Toner Supplies.
  36.6 ( 11.6/ 24.5/  8.5)     16  Passport Advantage problems
  36.4 ( 17.7/ 18.1/  8.3)     19  DATABASE QUESTION ! ! ! ! ! !
  33.7 ( 10.2/ 23.2/  7.5)     11  Installation of Informix 9.30 on Linux RH 9.0
  32.0 (  6.7/ 24.4/ 10.9)      9  onconfig file
  32.0 (  8.9/ 23.1/  9.9)     12  Does Informix OLEDB support OpenSchema?

These threads accounted for 19.1% of the total volume.

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

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

0.972  (  3.2/   3.3)      8  Permission Error installing Informix 9.4 IDS on AIX 4.3.3
0.935  (  9.0/   9.7)      6  Query Performance
0.924  (  6.6/   7.2)      6  Entity-relationship between tables
0.895  (  2.6/   2.9)      6  Shared Memory Problems, Informix IDS 7.31 install on SCO UnixWare 7.1.1
0.812  (  4.2/   5.1)      5  Switch Log status
0.719  (  5.8/   8.0)      7  Make BLOBS go into the BLOB space
0.715  ( 15.7/  21.9)     11  How to improve the performance of update statistics
0.671  ( 11.6/  17.3)      7  Off and On Informix Performance Issues
0.668  (  6.4/   9.6)      8  Authentication with PAM
0.645  (  4.6/   7.1)     10  IBM Informix IDS Benchmarking.

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

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

0.346  (  8.5 / 24.5)     16  Passport Advantage problems
0.323  (  7.5 / 23.2)     11  Installation of Informix 9.30 on Linux RH 9.0
0.317  (  3.3 / 10.5)      5  creating procedure for audit table
0.314  (  6.0 / 19.0)      6  DBD::Informix Installation problems on Linux
0.309  (  3.6 / 11.7)      6  big int to ESQL
0.285  ( 17.6 / 61.6)      8  oninit dies without error on RedHat 9
0.268  (  1.5 /  5.6)      6  SQL Syntax Checker
0.260  (  1.5 /  5.6)      7  how to avoid Informix lock due to lan console problems
0.243  (  4.7 / 19.2)      5  Bad performance
0.228  (  2.4 / 10.3)      6  Pb with Informix Connect

60 threads (20%) had at least five posts.

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

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

      19  comp.unix.aix
      17  comp.databases.ms-sqlserver
      14  comp.databases.theory
      14  comp.database.ms-access
       9  rec.woodworking
       3  comp.lang.java.databases
       2  comp.databases.ibm-db2
       1  comp.databases.oracle.server
       1  comp.databases.sybase
       1  comp.sys.ibm.as400.misc

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

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

      11  Darrin Wolf
       8  Cristian Ferrada
       7  Piedro
       6  Steve Kass
       4  Nuno Souto
       4  Biju Varghese
       4  Pupppy Wizzard
       4  akmad
       4  Nicholas Dronen
       4  Jim  Wolfe

 
 
 

Statistics for comp.databases.informix

Post by Madison Prue » Wed, 09 Jul 2003 12:08:22


Hummm --- Guess I've been too quiet the past month.

M.P.

"Dr. Pablo" <dr.pa...@mad.scientist.com> wrote in message

news:3f0a154e$1_1@news.iprimus.com.au...
> Following is a summary of articles spanning a 30 day period,
> beginning at 01 Jun 2003 00:09:06 GMT and ending at
> 30 Jun 2003 22:02:04 GMT.

> 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.
>     - Modest enhancements by Dr. Pablo MD, PhD, IUD, Bach.Vet.Sci.

> Totals
> ======

> Posters:  318
> Articles: 960 (149 with cutlined signatures)
> Threads:  298
> Volume generated: 2261.6 kb
>     - headers:    755.6 kb (15,642 lines)
>     - bodies:     1469.2 kb (44,200 lines)
>     - original:   810.4 kb (24,580 lines)
>     - signatures: 35.9 kb (877 lines)

> Original Content Rating: 0.552

> Averages
> ========

> Posts per poster: 3.0
>     median: 1.0 post
>     mode:   1 post - 165 posters
>     s:      5.0 posts
> Posts per thread: 3.2
>     median: 2.0 posts
>     mode:   1 post - 105 threads
>     s:      3.6 posts
> Message size: 2412.3 bytes
>     - header:     806.0 bytes (16.3 lines)
>     - body:       1567.1 bytes (46.0 lines)
>     - original:   864.5 bytes (25.6 lines)
>     - signature:  38.3 bytes (0.9 lines)

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

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

>    40   102.4 ( 39.7/ 56.0/ 29.4)  Jonathan Leffler
>    32    81.9 ( 32.5/ 48.9/ 20.6)  Michael Krzepkowski
>    27    56.1 ( 24.2/ 26.2/  4.0)  p...@oninit.com
>    26    38.9 ( 16.8/ 22.1/  4.9)  John Carlson
>    25    40.9 ( 18.1/ 22.8/  6.3)  Obnoxio The Clown
>    22    32.7 ( 15.0/ 17.7/ 11.6)  rkusenet
>    19    53.5 ( 14.6/ 38.9/ 18.6)  ka...@bloomberg.net
>    18    36.1 ( 12.8/ 23.3/  9.3)  Tsutomu Ogiwara
>    17    37.7 ( 12.0/ 15.6/  6.3)  Mark D. Stock
>    16    28.4 ( 11.3/ 17.1/  5.7)  Rob Vorbroker

> These posters accounted for 25.2% of all articles.

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

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

>  102.4 ( 39.7/ 56.0/ 29.4)     40  Jonathan Leffler
>   81.9 ( 32.5/ 48.9/ 20.6)     32  Michael Krzepkowski
>   56.1 ( 24.2/ 26.2/  4.0)     27  p...@oninit.com
>   53.5 ( 14.6/ 38.9/ 18.6)     19  ka...@bloomberg.net
>   42.9 (  9.0/ 33.9/ 17.8)     11  Darrin Wolf
>   40.9 ( 18.1/ 22.8/  6.3)     25  Obnoxio The Clown
>   38.9 ( 16.8/ 22.1/  4.9)     26  John Carlson
>   37.7 ( 12.0/ 15.6/  6.3)     17  Mark D. Stock
>   36.9 (  0.6/ 36.3/ 29.5)      1  solobosoe...@aol.com
>   36.1 ( 12.8/ 23.3/  9.3)     18  Tsutomu Ogiwara

> These posters accounted for 23.3% of the total volume.

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

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

> 0.978  (  2.8 /  2.9)      7  John M
> 0.924  (  9.7 / 10.5)      6  Rajib Sarkar
> 0.906  ( 11.6 / 12.8)      5  Zunino, Kathy
> 0.864  (  9.8 / 11.3)      6  Gustavo Tobares
> 0.860  ( 13.9 / 16.2)      7  chris.stau...@reebok.com
> 0.785  (  2.7 /  3.5)      5  S. R. RAMANA
> 0.716  (  4.3 /  6.0)      7  kh teoh
> 0.662  (  7.2 / 10.9)      9  Smitty
> 0.656  ( 11.6 / 17.7)     22  rkusenet
> 0.627  (  4.9 /  7.8)      8  Ronald Cole

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

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

> 0.277  (  6.3 / 22.8)     25  Obnoxio The Clown
> 0.269  (  2.3 /  8.6)      5  malky
> 0.258  (  3.7 / 14.5)      8  The Big Potatoe
> 0.258  (  1.6 /  6.2)      6  Murray Wood \(IList\)
> 0.221  (  4.9 / 22.1)     26  John Carlson
> 0.184  (  1.3 /  7.0)      5  Andy Lennard
> 0.152  (  3.3 / 21.4)      6  ar
> 0.152  (  4.0 / 26.2)     27  p...@oninit.com
> 0.135  (  3.7 / 27.2)      8  Brice Avila
> 0.102  (  2.6 / 25.2)      9  Murray Wood

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

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

> ( 1267 /   45)      2      2  Thomas.Mieslin...@gls-germany.com
> (  706 /    8)      2      1  Martin, Wayne E.
> (  617 /   12)     17     17  Mark D. Stock
> (  592 /   27)      1      1  Dan Guzman
> (  508 /   11)      3      3  les...@advancedatatools.com
> (  399 /    9)      1      1  Marco Greco
> (  389 /   14)     32      1  Michael Krzepkowski
> (  381 /    6)      1      1  Richard Spitz
> (  291 /   12)      2      2  Clive Eisen
> (  264 /   15)      1      1  Fred Pratt

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

> 51 posters (16%) had at least five posts.

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

> Posts  Subject
> -----  -------

>    30  Informix versus oracle
>    19  DATABASE QUESTION ! ! ! ! ! !
>    18  interesting problem
>    18  sql server -> informix
>    16  Passport Advantage problems
>    14  Table split into separate server and instance
>    12  Does Informix OLEDB support OpenSchema?
>    12  Command Line execution of sql statement
>    12  long checkpoints
>    11  Can pre-9.4 IDS really only use 2GB of a tape?

> These threads accounted for 16.9% of all articles.

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

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

>   69.4 ( 24.5/ 44.1/ 23.8)     30  Informix versus oracle
>   68.0 (  6.1/ 61.6/ 17.6)      8  oninit dies without error on RedHat 9
>   47.5 ( 16.2/ 30.6/ 15.3)     18  interesting problem
>   39.9 (  9.1/ 30.8/ 11.4)     12  long checkpoints
>   36.9 (  0.6/ 36.3/ 29.5)      1  Toner Supplies.
>   36.6 ( 11.6/ 24.5/  8.5)     16  Passport Advantage problems
>   36.4 ( 17.7/ 18.1/  8.3)     19  DATABASE QUESTION ! ! ! ! ! !
>   33.7 ( 10.2/ 23.2/  7.5)     11  Installation of Informix 9.30 on Linux
RH 9.0
>   32.0 (  6.7/ 24.4/ 10.9)      9  onconfig file
>   32.0 (  8.9/ 23.1/  9.9)     12  Does Informix OLEDB support OpenSchema?

> These threads accounted for 19.1% of the total volume.

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

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

> 0.972  (  3.2/   3.3)      8  Permission Error installing Informix 9.4 IDS
on AIX 4.3.3
> 0.935  (  9.0/   9.7)      6  Query Performance
> 0.924  (  6.6/   7.2)      6  Entity-relationship between tables
> 0.895  (  2.6/   2.9)      6  Shared Memory Problems, Informix IDS 7.31

install on SCO UnixWare 7.1.1

- Show quoted text -

> 0.812  (  4.2/   5.1)      5  Switch Log status
> 0.719  (  5.8/   8.0)      7  Make BLOBS go into the BLOB space
> 0.715  ( 15.7/  21.9)     11  How to improve the performance of update
statistics
> 0.671  ( 11.6/  17.3)      7  Off and On Informix Performance Issues
> 0.668  (  6.4/   9.6)      8  Authentication with PAM
> 0.645  (  4.6/   7.1)     10  IBM Informix IDS Benchmarking.

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

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

> 0.346  (  8.5 / 24.5)     16  Passport Advantage problems
> 0.323  (  7.5 / 23.2)     11  Installation of Informix 9.30 on Linux RH
9.0
> 0.317  (  3.3 / 10.5)      5  creating procedure for audit table
> 0.314  (  6.0 / 19.0)      6  DBD::Informix Installation problems on Linux
> 0.309  (  3.6 / 11.7)      6  big int to ESQL
> 0.285  ( 17.6 / 61.6)      8  oninit dies without error on RedHat 9
> 0.268  (  1.5 /  5.6)      6  SQL Syntax Checker
> 0.260  (  1.5 /  5.6)      7  how to avoid Informix lock due to lan
console problems
> 0.243  (  4.7 / 19.2)      5  Bad performance
> 0.228  (  2.4 / 10.3)      6  Pb with Informix Connect

> 60 threads (20%) had at least five posts.

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

> Articles  Newsgroup
> --------  ---------

>       19  comp.unix.aix
>       17  comp.databases.ms-sqlserver
>       14  comp.databases.theory
>       14  comp.database.ms-access
>        9  rec.woodworking
>        3  comp.lang.java.databases
>        2  comp.databases.ibm-db2
>        1  comp.databases.oracle.server
>        1  comp.databases.sybase
>        1  comp.sys.ibm.as400.misc

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

> Articles  Address
> --------  -------

>       11  Darrin Wolf
>        8  Cristian Ferrada
>        7  Piedro

...

read more »

 
 
 

Statistics for comp.databases.informix

Post by Jonathan Leffle » Wed, 09 Jul 2003 12:50:57



> Hummm --- Guess I've been too quiet the past month.

No; you're just fixing your OCR into the low range by quoting the
entire article and adding one line of comment and one line of
signature that isn't cutlined.


>>Following is a summary of articles spanning a 30 day period,
>>beginning at 01 Jun 2003 00:09:06 GMT and ending at
>>30 Jun 2003 22:02:04 GMT.

--
Jonathan Leffler                   #include <disclaimer.h>

Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/