|
|
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.
Navigation:
[Reply to this message]
|