This is a discussion on Statistics for comp.databases.informix within the Informix forums, part of the Database Server Software category; --> Following is a summary of articles spanning a 31 day period, beginning at 01 Jul 2003 00:32:43 GMT and ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Following is a summary of articles spanning a 31 day period, beginning at 01 Jul 2003 00:32:43 GMT and ending at 31 Jul 2003 23:10:41 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 <gbacon@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: 260 Articles: 873 (167 with cutlined signatures) Threads: 247 Volume generated: 2474.6 kb - headers: 683.0 kb (14,133 lines) - bodies: 1735.1 kb (46,949 lines) - original: 1038.2 kb (27,744 lines) - signatures: 55.7 kb (1,429 lines) Original Content Rating: 0.598 Averages ======== Posts per poster: 3.4 median: 2.0 posts mode: 1 post - 126 posters s: 5.4 posts Posts per thread: 3.5 median: 3 posts mode: 1 post - 70 threads s: 3.7 posts Message size: 2902.6 bytes - header: 801.1 bytes (16.2 lines) - body: 2035.2 bytes (53.8 lines) - original: 1217.7 bytes (31.8 lines) - signature: 65.3 bytes (1.6 lines) Top 10 Posters by Number of Posts ================================= (kb) (kb) (kb) (kb) Posts Volume ( hdr/ body/ orig) Address ----- -------------------------- ------- 41 110.4 ( 32.0/ 78.4/ 34.4) kagel@bloomberg.net 35 72.1 ( 25.0/ 26.0/ 9.7) Mark D. Stock 33 65.4 ( 24.0/ 39.3/ 17.6) Neil Truby 29 74.6 ( 30.2/ 39.5/ 17.5) Jonathan Leffler 27 60.5 ( 24.2/ 30.6/ 4.2) paul@oninit.com 25 49.2 ( 16.1/ 31.0/ 25.5) Andrew Hamm 24 29.0 ( 15.7/ 13.4/ 4.7) John Carlson 16 67.7 ( 13.2/ 54.5/ 5.6) Madison Pruet 16 45.1 ( 11.2/ 33.9/ 18.9) Chavan Koya 15 28.2 ( 10.1/ 18.1/ 11.5) rkusenet These posters accounted for 29.9% of all articles. Top 10 Posters by Volume ======================== (kb) (kb) (kb) (kb) Volume ( hdr/ body/ orig) Posts Address -------------------------- ----- ------- 236.1 ( 7.7/228.4/224.2) 9 Jay 110.4 ( 32.0/ 78.4/ 34.4) 41 kagel@bloomberg.net 93.1 ( 3.6/ 89.5/ 5.4) 5 Bill Dare 83.6 ( 10.4/ 73.2/ 39.7) 14 Rajasekaran, Rajesh 74.6 ( 30.2/ 39.5/ 17.5) 29 Jonathan Leffler 73.2 ( 2.2/ 71.0/ 68.1) 3 Martin, Wayne E. 72.1 ( 25.0/ 26.0/ 9.7) 35 Mark D. Stock 67.7 ( 13.2/ 54.5/ 5.6) 16 Madison Pruet 65.4 ( 24.0/ 39.3/ 17.6) 33 Neil Truby 60.5 ( 24.2/ 30.6/ 4.2) 27 paul@oninit.com These posters accounted for 37.9% of the total volume. Top 10 Posters by OCR (minimum of five posts) ============================================== (kb) (kb) OCR orig / body Posts Address ----- -------------- ----- ------- 1.000 ( 3.5 / 3.5) 5 Marino Decaro 0.992 ( 15.2 / 15.3) 5 Zunino, Kathy 0.982 (224.2 /228.4) 9 Jay 0.943 ( 23.4 / 24.8) 9 Rajib Sarkar 0.933 ( 15.6 / 16.7) 7 adam@morrison-ind.com 0.892 ( 17.7 / 19.8) 7 Weallans, Malcolm 0.831 ( 4.7 / 5.7) 6 markbtownsend@attbi.com 0.824 ( 25.5 / 31.0) 25 Andrew Hamm 0.746 ( 2.7 / 3.6) 8 Kristofer Andersson 0.636 ( 11.5 / 18.1) 15 rkusenet Bottom 10 Posters by OCR (minimum of five posts) ================================================= (kb) (kb) OCR orig / body Posts Address ----- -------------- ----- ------- 0.334 ( 1.0 / 2.9) 5 Ronald Cole 0.323 ( 4.1 / 12.6) 5 anon 0.273 ( 3.1 / 11.5) 12 Jean Sagi 0.255 ( 2.6 / 10.1) 8 abdoell 0.244 ( 3.9 / 15.9) 6 Brice Avila 0.210 ( 3.7 / 17.6) 12 David Williams 0.157 ( 5.4 / 34.8) 9 Michael Mueller 0.136 ( 4.2 / 30.6) 27 paul@oninit.com 0.103 ( 5.6 / 54.5) 16 Madison Pruet 0.061 ( 5.4 / 89.5) 5 Bill Dare Top 10 Largest Signatures ========================= (bytes) size / lines Posts Signed Address -------------- ----- ------ ------- ( 3440 / 75) 5 1 John_Thomas@ao.uscourts.gov ( 1348 / 40) 1 1 Eric Herber ( 1317 / 33) 1 1 Vardan Aroustamian ( 1205 / 20) 7 2 Weallans, Malcolm ( 1190 / 25) 5 1 Zunino, Kathy ( 1115 / 34) 1 1 William Fields ( 676 / 19) 12 11 Jean Sagi ( 623 / 24) 33 5 Neil Truby ( 617 / 12) 35 35 Mark D. Stock ( 579 / 30) 2 2 Thomas.Mieslinger@gls-germany.com if you quote previous article in a non-standard way, it may look like you have a signature containing more text than reality. 41 posters (15%) had at least five posts. Top 10 Threads by Number of Posts ================================= Posts Subject ----- ------- 38 ORACLE RAC CRASHES ORBITZ 21 Informix and Lawson Software 17 Passport Advantage 16 Alarm program on IDS9.30UC1 14 create temp table with no log 13 IDS FCx on HP-UX 11.11 12 Max size allowed in creation of dbspace 11 What is Informix? 10 Down grade from 9.21.UC2 to 7.30.UC6 10 book These threads accounted for 18.6% of all articles. Top 10 Threads by Volume ======================== (kb) (kb) (kb) (kb) Volume ( hdr/ body/ orig) Posts Subject -------------------------- ----- ------- 135.5 ( 2.3/133.3/133.2) 3 performance problems due to lock waits? 135.0 ( 1.6/133.3/ 66.2) 2 Too many Locks 91.4 ( 44.2/ 47.1/ 24.2) 38 ORACLE RAC CRASHES ORBITZ 63.6 ( 1.0/ 62.6/ 62.6) 1 performance problems due to spin waits? 58.9 ( 1.9/ 57.0/ 28.2) 2 ER problem 9.3.UC2 / linux 51.3 ( 6.9/ 44.5/ 22.7) 9 Clarfication on reorg of critical dbspace... 50.1 ( 14.8/ 32.6/ 18.2) 21 Informix and Lawson Software 42.2 ( 3.7/ 38.5/ 29.6) 5 How to create a table with dynamic table name 38.2 ( 7.2/ 30.0/ 15.8) 10 Down grade from 9.21.UC2 to 7.30.UC6 37.6 ( 2.3/ 35.0/ 17.3) 3 Spin locks bringing system to a crawl These threads accounted for 28.4% of the total volume. Top 10 Threads by OCR (minimum of five posts) ============================================== (kb) (kb) OCR orig / body Posts Subject ----- -------------- ----- ------- 0.872 ( 7.8/ 8.9) 5 Onaudit 0.872 ( 4.4/ 5.0) 5 informix backup 0.821 ( 5.9/ 7.2) 7 dbexport did not create indexes 0.816 ( 3.4/ 4.2) 5 oracle cache fusion against informix XPS? 0.768 ( 29.6/ 38.5) 5 How to create a table with dynamic table name 0.756 ( 12.1/ 15.9) 8 index duplicates PK, is it redundant? 0.729 ( 4.8/ 6.6) 10 book 0.728 ( 3.8/ 5.2) 7 Can't find the Informix 2.81 UC2 CSDK 0.718 ( 4.3/ 6.0) 5 Specify user in sql statement 0.716 ( 14.3/ 19.9) 9 Informix Data Masks Bottom 10 Threads by OCR (minimum of five posts) ================================================= (kb) (kb) OCR orig / body Posts Subject ----- -------------- ----- ------- 0.349 ( 9.8 / 28.0) 5 Unexpected behavior 0.341 ( 6.7 / 19.6) 6 Informix 9.4 install failed 0.329 ( 1.2 / 3.8) 5 Alter Fragment Problems with Serial8 0.324 ( 4.1 / 12.6) 5 Informix under Linux - real crap ! 0.322 ( 1.3 / 3.9) 5 Informix 7.31, oncheck and locking 0.313 ( 3.7 / 11.9) 7 Antwort: Re: IDS 9.x stability on Solaris vs Linux 0.308 ( 3.8 / 12.2) 16 Alarm program on IDS9.30UC1 0.284 ( 3.9 / 13.6) 6 Informix crashes with wrong datatype in stored procedure 0.253 ( 5.9 / 23.2) 8 Level 2 ODBC Drivers for IDS 0.205 ( 5.8 / 28.4) 6 Any ideas 58 threads (23%) had at least five posts. Top Targets for Crossposts ========================== Articles Newsgroup -------- --------- 37 comp.databases.oracle.server 37 comp.databases.ibm-db2 1 comp.databases.oracle Top 10 Crossposters =================== Articles Address -------- ------- 22 Daniel Morgan 8 Blair Adamache 6 Noons 4 Darin McBride 4 Mark A 4 Joel Garry 4 Tom Longfellow 4 Neil Truby 2 Nuno Souto 2 Andrew Hamm |