RSS

Audit Trail Performance Comparison

02 May

Below are audit trail performance testing in different technologies / approaches.

  • Baseline: Standard DML operations with no audit trail.
  • Change Data Capture (CDC): DML operations with CDC to capture audit trail in system tables.
  • Trigger: DML operations with trigger to record audit trail in different table.
  • Entity Framework 1: DML operations with audit trail recording in Entity Framework’s SaveChanges() method by accessing EF’s OriginalValues object for tracking data changes.
  • Entity Framework 2: DML operations with audit trail recording in Entity Framework’s SaveChanges() method by accessing EF’s DbSet object for tracking data changes.
Insert Update Delete All
Baseline 1717.05 2353.95 2650.5 6761.95
Change Data Capture (CDC) 1632 2399 2649 6689
Trigger 1649.6 2347.25 2708.3 6723.65
Entity Framework 1 3517.4 4214.6 3350.3 11106.15
Entity Framework 2 3386.35 5678 4916.95 13993.9
Test results are in millisecond. Operations are performed with 500 records.

Advertisements
 
Leave a comment

Posted by on May 2, 2012 in General

 

Tags: , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: