Hello all. Would like some input.

We need to be able to track changes in a (fairly standard) client contact database. I've looked at Bob's "Yet Another Audit Trail" but I'm not sure that it fits the bill. What we need is a system which records when a user makes changes to a field. We need to know which user made the change, when, to what field, and the actual data that has changed, a before + current snapshot. It would be ideal to be able to display this information in a list form. Perhaps even with sortable columns and a simple search filter, one day.

There will be a lot of users (200) and thus, lots of overhead, so which ever notion I go with would have to be fast and not overly CPU intensive. There will be more than 100,000 contacts in this contact management database. So what general method would be best for this? A related table that contains previous iterations of a contact record? Perhaps just one table with some exotic calculated field trickery? Something else entirely which I'm not seeing?

Any input would be appreciated, thanks!

Audit Trail Links