Peter, I've not done it but in your case I would suggest using a separate database to store those log files.
10GB+ on logs is a lot to backup every time 4D backs up etc… Regards, Wayne Wayne Stewart about.me/waynestewart On 11 January 2017 at 09:29, Peter Bozek <[email protected]> wrote: > On Tue, Jan 10, 2017 at 9:53 PM, Dave Nasralla <[email protected]> wrote: > >> Right. In one system people with high level access can request to see >> a social security number of an employee. The system records who viewed >> it, and the user must enter a "why" they are viewing it. >> > > I was following the debate only lightly, so maybe this question was already > discussed: do you keep complete audit trail in data file or export it to > another system? > > I maintain two system that keep audit trail and the table with log records > grows really fast - in one case (20+ workstations) most of the 10+GB data > file consist of audit trail table, even when it deletes records older then > 6 months. The deletion of log entries cancels the main benefit of audit > trail and is a relict of the past, I could disable it and let the data > grow, but maybe there are better way how to handle it (export to separate > single user app?) > > -- > > Peter Bozek > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
