EntityFramework-Plus icon indicating copy to clipboard operation
EntityFramework-Plus copied to clipboard

Entity Framework Plus - Audit Extension - Consuming CPU Percentage High (above 50%)

Open manojkumaraut opened this issue 7 years ago • 1 comments

Team, i am using Entity Framework Plus - Audit Extension for the audit trail feature but facing an issue - as its consuming 50% CPU Percentage High and makes the server slow..any other optimization solution to make them low...Thanks and appreciate your help

manojkumaraut avatar Dec 17 '18 07:12 manojkumaraut

Hello @manojkumaraut ,

Unfortunately, if you save a lot entities, it will create a lot of AuditEntryProperty as well. The high consuming CPU is probably caused by the SaveChanges method when saving all audit entry properties.

One way to fix it is to save all audit entries and properties using BulkInsert from Entity Framework Extensions. Our commercial library allow to save entities with high performance bulk operations. Is it a solution that might interest you?

Best Regards,

Jonathan

JonathanMagnan avatar Dec 18 '18 02:12 JonathanMagnan