Hi DevEx!
I am using the audit module and working through some performance issues. As part of my performance analysis, I have cleared all the types to be tracked through the Audit Module by handling the CustomizeAuditTrailSettings event and clearing the AuditTrailSettings, but i am finding inserts taking place to the audit tables (via SQL tracing). How could there be entries into the tables when I have cleared the audited types? What else should I look for?
It appears that the audit entries are related to a many-to-many relationship. Not sure if this helps.
Hello,
We reproduced the behavior that you described. Please give us additional time to research it.
In the meantime I doubt that this excessive audit entries cause the performance issue that you faced. To get the exact cause of the issue, profile your app. In the following article we collected the most common performance issues and ways to solve them: T148978 - How to measure and improve application performance. Hope it will be helpful for you.
Thanks,
Andrey
Actually, it is the primary cause of my performance issue. The table of audit data item has over 8M rows.
I worked around this by handling the AuditTrailService.Instance.SaveAuditTrailData in a controller, checking the object type of the AuditObject in the list to be recorded and removed it if not a type to be tracked. Performance increased significantly.
Thank you for your help. Looking forward to the fix.
Hello,
Thank you for your feedback. We will update this thread once we have any news.
Andrey