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?
We have addressed the issue described in this ticket and will include a fix in our next maintenance update. To apply this solution before official release, request a hotfix by clicking the appropriate version link.
Note: Hotfixes may be unavailable for betas/updates set for release within a week.
Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
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