Audit Trail

[JuanVte]

Hello!

I am thinking about implementing an audit trail on MySQL which would work with triggers. Does somebody know if the triggers work when I do an SQL update/insert/delete statement directly from SAS to MySQL?

Thanks!

[JasonDiVirgilio]

They should, but you may want to consider doing the audit trail a different way as triggers can slow down your performance significantly.

If you can grab the audit information (userID, date, etc...) prior to doing the insert/update, then you could put that information into the SQL statement and not rely on the database to do the work.