By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,332 Members | 1,198 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,332 IT Pros & Developers. It's quick & easy.

100 Day Statistics for comp.databases.ms-access

P: n/a
edo
[view with fixed-spaced font]

100 Day Analysis

Following is a summary of articles spanning a 100 day period,
beginning at 10 Sep 2003 06:41:30 GMT and ending at
19 Dec 2003 04:09:06 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" email address and name.
- Original Content Rating (OCR) is the ratio of the original content
volume to the total body volume.

Totals
======

Posters: 2240
Articles: 12479 (2166 with cutlined signatures)
Threads: 3353
Volume generated: 27350.2 kb
- headers: 12010.8 kb (208,575 lines)
- bodies: 14455.8 kb (435,570 lines)
- original: 7662.3 kb (245,013 lines)
- signatures: 871.4 kb (28,461 lines)

Original Content Rating: 0.530

Averages
========

Posts per poster: 5.6
median: 2.0 posts
mode: 1 post - 1046 posters
s: 20.5 posts
Posts per thread: 3.7
median: 3 posts
mode: 2 posts - 844 threads
s: 4.3 posts
Message size: 2244.3 bytes
- header: 985.6 bytes (16.7 lines)
- body: 1186.2 bytes (34.9 lines)
- original: 628.8 bytes (19.6 lines)
- signature: 71.5 bytes (2.3 lines)

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

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

414 1040.4 (442.3/597.6/179.5) "TC" <a@b.c.d>
337 538.9 (298.5/240.1/141.5) Pieter Linden <pi********@hotmail.com>
330 741.7 (322.2/419.2/208.2) "Larry Linson" <bo*****@localhost.not>
273 797.2 (280.9/478.5/258.5) David W. Fenton <dX********@bway.net.invalid>
194 456.6 (212.2/244.2/141.6) "Mike MacSween" <mi******************@btinternet.com>
191 591.6 (230.2/360.1/161.8) MGFoster <me@privacy.com>
189 564.0 (195.0/368.8/161.1) Steve Jorgensen <no****@nospam.nospam>
178 292.1 (167.4/124.5/ 88.7) Tony Toews <tt****@telusplanet.net>
174 331.8 (164.0/167.6/ 51.4) Tom van Stiphout <to*****@no.spam.cox.net>
166 460.0 (145.9/157.0/139.4) "Allen Browne" <al*********@SeeSig.invalid>

These posters accounted for 19.6% of all articles.

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

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

1040.4 (442.3/597.6/179.5) 414 "TC" <a@b.c.d>
797.2 (280.9/478.5/258.5) 273 David W. Fenton <dX********@bway.net.invalid>
741.7 (322.2/419.2/208.2) 330 "Larry Linson" <bo*****@localhost.not>
591.6 (230.2/360.1/161.8) 191 MGFoster <me@privacy.com>
564.0 (195.0/368.8/161.1) 189 Steve Jorgensen <no****@nospam.nospam>
538.9 (298.5/240.1/141.5) 337 Pieter Linden <pi********@hotmail.com>
460.0 (145.9/157.0/139.4) 166 "Allen Browne" <al*********@SeeSig.invalid>
456.6 (212.2/244.2/141.6) 194 "Mike MacSween" <mi******************@btinternet.com>
398.5 (143.5/254.9/ 89.2) 127 "deko" <dj****@hotmail.com>
332.0 (160.0/ 49.3/ 48.1) 137 "Wayne Morgan" <co***************************@hotmail.com>

These posters accounted for 21.6% of the total volume.

Top 10 Posters by Volume of Original Content (min. five posts)
================================================== ============

(kb)
Posts orig Address
----- ----- -------

273 258.5 David W. Fenton <dX********@bway.net.invalid>
330 208.2 "Larry Linson" <bo*****@localhost.not>
414 179.5 "TC" <a@b.c.d>
191 161.8 MGFoster <me@privacy.com>
189 161.1 Steve Jorgensen <no****@nospam.nospam>
27 149.4 "(Pete Cresswell)" <x@y.z>
194 141.6 "Mike MacSween" <mi******************@btinternet.com>
337 141.5 Pieter Linden <pi********@hotmail.com>
166 139.4 "Allen Browne" <al*********@SeeSig.invalid>
81 120.6 Peter Miller <pm*****@pksolutions.com>

These posters accounted for 21.7% of the original volume.

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

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

1.000 ( 6.5 / 6.5) 7 ano1optimist <an**********@aol.com>
1.000 ( 8.0 / 8.0) 10 Ian <an*******@devdex.com>
1.000 ( 5.4 / 5.4) 5 "edself" <ed****@ecomail.org>
1.000 ( 1.2 / 1.2) 5 bala <ba*******@yahoo.com>
1.000 ( 1.0 / 1.0) 5 Lynn <Ly***********@yahoo.com>
1.000 ( 6.1 / 6.1) 5 "Tom Wickerath" <AO****@comcast.net>
1.000 ( 3.8 / 3.8) 6 Tom Dauria <td*****@bu.edu>
1.000 ( 2.9 / 2.9) 6 "Bob Darlington" <bo*@dpcmanAX.com.au>
1.000 ( 6.7 / 6.7) 13 DCM Fan <dc****@aol.comSPNOAM>
1.000 ( 4.0 / 4.0) 7 Svelte Poshy <sv******@yahoo.com>

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

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

0.237 ( 1.4 / 6.0) 5 "John Ortt" <Jo******@STOPSPAMMINGMEbaesystems.com>
0.234 ( 6.6 / 28.0) 12 "JustMe" <te******@sasktel.net>
0.230 ( 5.9 / 25.7) 7 "Andrew Gow" <an*******@orange.net>
0.223 ( 3.8 / 17.3) 9 Kenny G <kg****@hotmail.com>
0.217 ( 23.7 /109.1) 15 mark <ms@nospam.comcast.net>
0.217 ( 3.4 / 15.5) 5 "Nifty" <as*@meifyouwantknow.com>
0.217 ( 13.1 / 60.4) 50 "Phobos" <la******@spammers.co.uk>
0.190 ( 2.4 / 12.4) 7 Re*****@JaxonFamily.net
0.146 ( 5.3 / 36.2) 10 Peter Flick <pf****@bigpondXXremoveXX.net.au>
0.070 ( 3.3 / 46.7) 6 "David Lauberts" <da************@ntlworld.com>

412 posters (18%) had at least five posts.

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

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

117 Security - more complex than I thought
67 Open question - leverage all features liberally, or be selective?
58 No 'real' relational databases?
52 Desire to REMERGE Database and Program!!
45 Compact on close - bad idea?
41 Time dependant PK?
37 OT: Yet Another Patch
33 How often is Access security breached?
30 BEWARE LINKS POSTED FROM ANONYMIZERS!
30 David Fenton is a valued member of this newsgroup

These threads accounted for 4.1% of all articles.

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

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

441.1 (152.2/271.0/160.8) 117 Security - more complex than I thought
275.6 ( 81.7/190.9/ 88.5) 67 Open question - leverage all features liberally, or be selective?
169.6 ( 61.1/106.5/ 58.0) 52 Desire to REMERGE Database and Program!!
152.0 ( 70.0/ 79.7/ 38.4) 58 No 'real' relational databases?
145.8 ( 23.1/122.7/ 12.1) 17 Export of form with 2 graphs As a JPEG
130.5 ( 53.5/ 75.8/ 47.0) 41 Time dependant PK?
119.9 ( 6.3/113.6/111.2) 6 Why must I use PrtDevMode
101.3 ( 11.2/ 90.1/ 18.5) 8 Expressions and the IIf statement
99.0 ( 51.5/ 38.7/ 17.9) 45 Compact on close - bad idea?
95.1 ( 23.1/ 71.6/ 26.0) 20 Duplicated code in a class module

These threads accounted for 6.3% of the total volume.

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

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

1.000 ( 2.3/ 2.3) 5 Newbie. How to delete blank lines in an address
1.000 ( 3.8/ 3.8) 9 Blank Form
0.983 ( 2.9/ 2.9) 6 don't show reminders form on startup
0.978 (111.2/ 113.6) 6 Why must I use PrtDevMode
0.977 ( 7.4/ 7.5) 5 populating textfield from multiple records
0.967 ( 2.9/ 3.0) 7 Playing & recording WAVE-type sound in MS Access - could Me!Message.Action ...
0.943 ( 4.5/ 4.8) 6 Filter By Selection Issue
0.921 ( 3.4/ 3.7) 5 Using MultiSelect List Box on a Subform
0.917 ( 2.4/ 2.6) 5 Compacting a database on close
0.891 ( 4.6/ 5.1) 8 Access 2002 Comments

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

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

0.209 ( 9.8 / 46.9) 9 Combine field in several recs summarized into one record?
0.208 ( 7.1 / 34.4) 17 Putting my Access 97 database on the web
0.208 ( 1.0 / 4.9) 6 CodeModule Find Method regexp
0.206 ( 18.5 / 90.1) 8 Expressions and the IIf statement
0.204 ( 9.8 / 47.8) 9 Error Message After Delete
0.200 ( 4.7 / 23.7) 9 Cannot get the "like" command to work in a sql statement help please
0.197 ( 3.2 / 16.3) 7 Report formating problem
0.186 ( 6.2 / 33.3) 9 Passing typo to form gets runtime error 2105
0.141 ( 7.3 / 51.7) 15 query to define current week?
0.098 ( 12.1 /122.7) 17 Export of form with 2 graphs As a JPEG

758 threads (22%) had at least five posts.

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

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

215 microsoft.public.access.formscoding
143 microsoft.public.access.forms
116 microsoft.public.access.gettingstarted
114 microsoft.public.access
55 microsoft.public.access.formsprogramming
54 microsoft.public.access.queries
45 comp.databases
44 comp.database.ms-access
28 comp.databases.ms-sqlserver
27 microsoft.public.office.developer.vba

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

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

47 "TC" <a@b.c.d>
38 "Steve" <sa****@penn.com>
36 "Bruce M. Thompson" <bthmpson@big_NOSPAM_foot.com>
29 Pieter Linden <pi********@hotmail.com>
27 "Larry Linson" <bo*****@localhost.not>
27 Bobbak <bo****@ottawa.com>
22 "Wayne Morgan" <co***************************@hotmail.com>
22 "HB" <fr*****@telus.net>
20 "Steve" <ss****@bellsouth.net>
19 Tony Toews <tt****@telusplanet.net>

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
NB
This is interesting

NB
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.