473,394 Members | 1,887 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

100 Day Statistics for comp.databases.ms-access

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
2 1851
NB
This is interesting

NB
Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: George Augustino | last post by:
REQUEST FOR DISCUSSION (RFD) unmoderated group comp.databases.mysql Newsgroup line: comp.databases.mysql MySQL relational database system discussion group. This is a formal Request For...
1
by: Otis Green | last post by:
Vote for or against a new newsgroup proposal. To summarize what you need to do, just send an empty e-mail to postgresql-ballot@netagw.com You will receive a ballot by e-mail. Follow the...
8
by: William Drew | last post by:
REQUEST FOR DISCUSSION (RFD) unmoderated group comp.databases.mysql This is an invitation to discuss the following proposal to create newsgroup comp.databases.mysql. Please note that YOU...
0
by: Mark Townsend | last post by:
Following is a summary of articles spanning a 7 day period, beginning at 23 Feb 2004 05:29:19 GMT and ending at 01 Mar 2004 04:12:14 GMT. Notes ===== - A line in the body of a post is...
0
by: Cara | last post by:
LAST CALL FOR VOTES (of 2) unmoderated group comp.databases.etl Newsgroups line: comp.databases.etl Extraction, transformation, loading issues. Votes must be received by 23:59:59 UTC, 12 Dec...
0
by: Cara Altman | last post by:
REQUEST FOR DISCUSSION (RFD) unmoderated group comp.databases.etl This is a formal Request For Discussion (RFD) for the creation of a world-wide unmoderated Usenet newsgroup...
6
by: Andy | last post by:
Someone posted this official proposal to create comp.databases.postgresql.general again. He wrote his own charter. As far as I know, he did not consult any of the postgresql groups first. There...
4
by: serge | last post by:
I am running a query in SQL 2000 SP4, Windows 2000 Server that is not being shared with any other users or any sql connections users. The db involves a lot of tables, JOINs, LEFT JOINs, UNIONS...
1
by: Chris Weston | last post by:
Hi. I have automatic statistic update turned on for all my databases. Is this an overhead I can do without? Could I update them overnight when the database is hardly in use? Thanks --...
1
by: integra18 | last post by:
I hope there are some experts that have good advice here. I have been trying to develop a website for the better part of a year now. I'm having a lot of trouble developing a database that will serve...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.