Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
To store every record change or not?
Message
De
20/03/2011 06:59:55
Walter Meester
HoogkarspelPays-Bas
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01504208
Message ID:
01504226
Vues:
148
>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,
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform