Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
To store every record change or not?
Message
From
20/03/2011 06:59:55
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01504208
Message ID:
01504226
Views:
151
>Hi,
>
>I was wondering what others here think about storing changes to every record into some kind of audit trail table? Is this a good and reasonable design or waste of database storage?
>
>TIA.

Hi Dmitry.

As others have mentioned, it depends on your requirements. But with an audittrail, you have powerfull means to:
1. To see who did change what record at what time
2. Undo a change
3. Travel back in time and recontruct the data at some point in time

Walter,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform