Posted by Ed Murphy on 01/15/07 18:19

dmarkle wrote:

> I'm not so sure about this design, though. In the long run, you may
> find it to be quite limiting. I usually recommend against doing
> auditing on the database level whenever I can -- I prefer to audit the
> actions that users do in the application layer.

Auditing on the database level may be necessary if you can't alter the
application, or don't know which part is responsible.

> Not to mention the
> fact that I think your design will be slow and difficult to query when
> the time comes to use it.

I don't see anything particularly wrong with the audit table, assuming
proper indexes.

[Back to original message]