[AccessD] SPAM-LOW: Re: Audit Trails

I can see this kind of thing where data doesn't change often, however as an example, one of my 
clients is working specific records in a table every day, potentially dozens of changes, having 20, 
30, 40 or more copies of each record over a month just seems like an inefficient way of logging 
changes.  Now, we need to find out who changed this specific field...

OTOH I could see this if a record is created once modified once or twice over the life of the record.

John W. Colby
www.ColbyConsulting.com


Mike Mattys wrote:
> Hi Gustav,
> 
> My sense is that there are always optimal points with diminishing
> returns thereafter. No, by schema I am referring to the concept that
> 'more is better' might more likely turn out to be 'more rope to hang' from.
> -
> Michael R Mattys
> MapPoint and Database Dev
> www.mattysconsulting.com
> -
> ----- Original Message ----- 
> From: "Gustav Brock" <Gustav at cactus.dk>
> To: <accessd at databaseadvisors.com>
> Sent: Sunday, July 19, 2009 12:53 PM
> Subject: Re: [AccessD] Audit Trails
> 
> 
> Hi Michael
> 
> That is a valid concern. However, it isn't directly related to auditing if 
> that is what you mean with "this schema".
> 
> There are many ways to prevent such total failures, like mirroring, raid 
> systems, on-line local and/or remote backup, clustered servers, etc.
> 
> /gustav
> 
> 
>>>> mmattys at rochester.rr.com 19-07-2009 16:06 >>>
> I have a reservation about this schema.
> 
> I watched someone tear one of these drives apart trying to connect
> to it some other way after it failed.
> 
> It brings to mind the addage, 'Don't put all your eggs in one basket.'
> Or, at least, make sure you've cloned your eggs.
> 
> -
> Michael R Mattys
> MapPoint and Database Dev
> www.mattysconsulting.com
> -
> 
> ----- Original Message ----- 
> From: "Gustav Brock" <Gustav at cactus.dk>
> To: <accessd at databaseadvisors.com>
> Sent: Sunday, July 19, 2009 9:52 AM
> Subject: Re: [AccessD] Audit Trails
> 
> 
> Hi Max
> 
> Exactly my point: 1.3 TB ~1000 * 1.3 GB databases (and how many GB sized dbs 
> do you hold?).
> Equals £0.11 or less than a US quarter or ?0.15 euro cents per database.
> Hardly a topic for discussion.
> 
> /gustav
> 
> 
>>>> max.wanadoo at gmail.com 19-07-2009 09:33 >>>
> When you consider that last week I bought 1.5Tb HD for £110 sterling from PC
> World. Plugs straight into my usb port and comes up as 1.3Tb formatted.
> 
> I can make copies to my hearts content and never run out of space.
> 
> Max
> 
>