The archiving of the records is a simple affair. All that we need to make sure of is that we don't archiving something twice, or that we don't delete something we haven't archived. For high volume tables, this can get interesting, especially if you want to remove the audit records as soon as they are written. (That is, every time that the archive script is run.)
So, to get around that we mark all of the records we want to copy first, then we copy all the marked records, then delete the audit records that are marked. Makes it nice and neat. While it creates an extra query, it is a safegard that is worth it. While playing with audits you can never be to careful.
So that about wraps up the project, more or less. The last part in the series details where you can find the source code (complete) and some other odds and ends.
No comments:
Post a Comment