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
- Release Tag: v1.1
- Source Code: GitHub Repository
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.