Version 1.1.x

DbSyncKit Version 1.1.x has been rigorously tested for performance across various scenarios, showcasing improved efficiency and responsiveness with increased overall performance.

Benchmark Results

Environment Information

  • BenchmarkDotNet Version: v0.13.11
  • Operating System: Windows 10 (10.0.19045.3803/22H2/2022Update)
  • Processor: AMD Ryzen 7 7700X, 1 CPU, 16 logical and 8 physical cores
  • .NET SDK: 8.0.100

Benchmark Configuration

  • Host Environment: .NET 8.0.0 (8.0.23.53103), X64 RyuJIT AVX-512F+CD+BW+DQ+VL+VBMI
  • Default Job: .NET 8.0.0 (8.0.23.53103), X64 RyuJIT AVX-512F+CD+BW+DQ+VL+VBMI

Database Changes Summary

The table below summarizes the changes in the database:

Method Added Edited Deleted Total Source Row Total Destination Row
Album 2 4 0 347 345
Artist 0 3 0 275 275
SyncCustomer 1 17 0 59 58
SyncEmployee 0 3 0 8 8
Genre 0 2 0 25 25
Invoice 6 29 0 412 406
InvoiceLine 36 0 1 2239 2204
MediaType 0 0 0 5 5
Playlist 0 0 0 18 18
PlaylistTrack 9 0 2 8713 8706
Track 2 166 1 3502 3501

These changes in the database are consistent for all benchmarks after this.

Release Information

Benchmark Results

The following table summarizes the benchmark results for key methods in DbSyncKit Version 1.1:

Method Mean Error StdDev Gen0 Gen1 Gen2 Allocated
SyncAlbum 102.415 μs 2.0125 μs 4.2009 μs 22.9492 6.8359 - 377.18 KB
SyncArtist 78.279 μs 1.5452 μs 2.1151 μs 18.5547 6.1035 - 303.02 KB
SyncCustomer 33.291 μs 0.6452 μs 0.7924 μs 5.8594 5.7983 - 94.38 KB
SyncEmployee 6.237 μs 0.1197 μs 0.1120 μs 2.4796 0.4044 - 39.61 KB
SyncGenre 11.169 μs 0.2202 μs 0.3857 μs 3.6011 3.5400 - 56.99 KB
SyncInvoice 146.246 μs 2.8455 μs 4.2590 μs 30.2734 29.7852 - 496.26 KB
SyncInvoiceLine 940.846 μs 18.0998 μs 20.8438 μs 179.6875 74.2188 58.5938 3004.89 KB
SyncMediaType 4.311 μs 0.0861 μs 0.1834 μs 2.0294 0.3662 - 31.53 KB
SyncPlaylist 7.864 μs 0.1566 μs 0.2091 μs 2.8839 0.4272 - 46.5 KB
SyncPlaylistTrack 10,181.365 μs 202.0518 μs 296.1649 μs 1359.3750 1093.7500 609.3750 15238.76 KB
SyncTrack 1,716.959 μs 26.8508 μs 25.1162 μs 300.7813 117.1875 58.5938 4720.62 KB

Compare Versions

Explore the differences between various versions of DbSyncKit to track the evolution of performance and functionality.

For detailed comparisons between different versions, refer to the Get Differences Between Versions page in the documentation.