November 18, 2004 at 7:28 am
So the archive always contains a log of the changes that have been made to a record?
The trigger method does mean that the archiving is done at the database level so even someone messing around in EM or any other app is going to fire the triggers.
One alternative is to encode your archiving routines within stored procedures. This means that the archiving will only happen in response to explicit calls to those stored procedures.
An alternative approach would be to have an updated/created date on your records and have a batch job that runs every night to copy old versions of records into your archive tables. If your app is large then this approach may give you better overall performance in the long run.
Viewing post 1 (of 2 total)
You must be logged in to reply to this topic. Login to reply