Created
January 11, 2019 18:48
-
-
Save sdrapkin/c2d310e0f42b18d8f2beae789294faa8 to your computer and use it in GitHub Desktop.
TinyORM benchmark January-11-2019
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Warming up DB, DB client code and CLR | |
==================================================================== | |
DataTable, using DbDataAdapter. Change tracking: True. Caching: False. | |
-------------------------------------------------------------------------------------------- | |
[13:32:02] # of elements fetched: 31465. Fetch took: 214.79ms. Enumerating result took: 25.81ms. | |
[13:32:03] # of elements fetched: 31465. Fetch took: 204.54ms. Enumerating result took: 24.42ms. | |
[13:32:03] # of elements fetched: 31465. Fetch took: 195.04ms. Enumerating result took: 24.98ms. | |
[13:32:03] # of elements fetched: 31465. Fetch took: 211.50ms. Enumerating result took: 24.06ms. | |
[13:32:03] # of elements fetched: 31465. Fetch took: 203.68ms. Enumerating result took: 25.46ms. | |
[13:32:03] # of elements fetched: 31465. Fetch took: 193.36ms. Enumerating result took: 24.78ms. | |
[13:32:04] # of elements fetched: 31465. Fetch took: 197.72ms. Enumerating result took: 24.01ms. | |
[13:32:04] # of elements fetched: 31465. Fetch took: 206.35ms. Enumerating result took: 24.91ms. | |
[13:32:04] # of elements fetched: 31465. Fetch took: 188.27ms. Enumerating result took: 24.66ms. | |
[13:32:04] # of elements fetched: 31465. Fetch took: 206.49ms. Enumerating result took: 24.41ms. | |
[13:32:05] # of elements fetched: 31465. Fetch took: 191.99ms. Enumerating result took: 24.29ms. | |
[13:32:05] # of elements fetched: 31465. Fetch took: 203.71ms. Enumerating result took: 23.94ms. | |
[13:32:05] # of elements fetched: 31465. Fetch took: 194.06ms. Enumerating result took: 24.12ms. | |
[13:32:05] # of elements fetched: 31465. Fetch took: 190.35ms. Enumerating result took: 24.03ms. | |
[13:32:05] # of elements fetched: 31465. Fetch took: 190.70ms. Enumerating result took: 24.21ms. | |
[13:32:06] # of elements fetched: 31465. Fetch took: 204.97ms. Enumerating result took: 24.84ms. | |
[13:32:06] # of elements fetched: 31465. Fetch took: 191.10ms. Enumerating result took: 23.54ms. | |
[13:32:06] # of elements fetched: 31465. Fetch took: 204.42ms. Enumerating result took: 24.94ms. | |
[13:32:06] # of elements fetched: 31465. Fetch took: 192.26ms. Enumerating result took: 24.00ms. | |
[13:32:07] # of elements fetched: 31465. Fetch took: 200.25ms. Enumerating result took: 23.49ms. | |
[13:32:07] # of elements fetched: 31465. Fetch took: 192.94ms. Enumerating result took: 23.92ms. | |
[13:32:07] # of elements fetched: 31465. Fetch took: 194.49ms. Enumerating result took: 27.32ms. | |
[13:32:07] # of elements fetched: 31465. Fetch took: 191.27ms. Enumerating result took: 23.82ms. | |
[13:32:07] # of elements fetched: 31465. Fetch took: 197.33ms. Enumerating result took: 24.83ms. | |
[13:32:08] # of elements fetched: 31465. Fetch took: 230.27ms. Enumerating result took: 24.25ms. | |
Starting benchmarks. | |
==================================================================== | |
Handcoded async [GetValues(array), boxing]. Change tracking: False. Caching: False. | |
-------------------------------------------------------------------------------------------- | |
First one warm-up run of each bench type to initialize constructs. Results will not be collected. | |
[13:32:08] # of elements fetched: 31465. Fetch took: 153.51ms. Enumerating result took: 1.47ms. | |
[13:32:08] # of elements fetched individually: 100. Total time: 27.53ms. Time per element: 0.28ms | |
Starting bench runs... | |
Set fetches | |
------------------------- | |
[13:32:08] # of elements fetched: 31465. Fetch took: 121.35ms. Enumerating result took: 1.21ms. | |
[13:32:08] # of elements fetched: 31465. Fetch took: 120.88ms. Enumerating result took: 1.33ms. | |
[13:32:08] # of elements fetched: 31465. Fetch took: 120.94ms. Enumerating result took: 1.04ms. | |
[13:32:08] # of elements fetched: 31465. Fetch took: 119.13ms. Enumerating result took: 1.12ms. | |
[13:32:09] # of elements fetched: 31465. Fetch took: 124.99ms. Enumerating result took: 1.05ms. | |
[13:32:09] # of elements fetched: 31465. Fetch took: 121.08ms. Enumerating result took: 1.03ms. | |
[13:32:09] # of elements fetched: 31465. Fetch took: 120.61ms. Enumerating result took: 1.06ms. | |
[13:32:09] # of elements fetched: 31465. Fetch took: 120.77ms. Enumerating result took: 1.10ms. | |
[13:32:09] # of elements fetched: 31465. Fetch took: 120.89ms. Enumerating result took: 1.04ms. | |
[13:32:09] # of elements fetched: 31465. Fetch took: 119.04ms. Enumerating result took: 1.32ms. | |
[13:32:09] # of elements fetched: 31465. Fetch took: 119.29ms. Enumerating result took: 1.03ms. | |
[13:32:09] # of elements fetched: 31465. Fetch took: 119.18ms. Enumerating result took: 1.04ms. | |
[13:32:10] # of elements fetched: 31465. Fetch took: 123.60ms. Enumerating result took: 1.05ms. | |
[13:32:10] # of elements fetched: 31465. Fetch took: 119.99ms. Enumerating result took: 1.11ms. | |
[13:32:10] # of elements fetched: 31465. Fetch took: 120.76ms. Enumerating result took: 1.07ms. | |
[13:32:10] # of elements fetched: 31465. Fetch took: 123.92ms. Enumerating result took: 1.03ms. | |
[13:32:10] # of elements fetched: 31465. Fetch took: 120.36ms. Enumerating result took: 1.22ms. | |
[13:32:10] # of elements fetched: 31465. Fetch took: 120.42ms. Enumerating result took: 1.06ms. | |
[13:32:10] # of elements fetched: 31465. Fetch took: 121.24ms. Enumerating result took: 1.07ms. | |
[13:32:10] # of elements fetched: 31465. Fetch took: 121.74ms. Enumerating result took: 1.07ms. | |
[13:32:11] # of elements fetched: 31465. Fetch took: 121.75ms. Enumerating result took: 1.03ms. | |
[13:32:11] # of elements fetched: 31465. Fetch took: 119.05ms. Enumerating result took: 1.06ms. | |
[13:32:11] # of elements fetched: 31465. Fetch took: 121.11ms. Enumerating result took: 1.11ms. | |
[13:32:11] # of elements fetched: 31465. Fetch took: 121.16ms. Enumerating result took: 1.06ms. | |
[13:32:11] # of elements fetched: 31465. Fetch took: 119.79ms. Enumerating result took: 1.03ms. | |
Single element fetches | |
------------------------- | |
[13:32:11] # of elements fetched individually: 100. Total time: 27.11ms. Time per element: 0.27ms | |
[13:32:11] # of elements fetched individually: 100. Total time: 26.41ms. Time per element: 0.26ms | |
[13:32:11] # of elements fetched individually: 100. Total time: 25.68ms. Time per element: 0.26ms | |
[13:32:11] # of elements fetched individually: 100. Total time: 25.39ms. Time per element: 0.25ms | |
[13:32:11] # of elements fetched individually: 100. Total time: 25.30ms. Time per element: 0.25ms | |
[13:32:11] # of elements fetched individually: 100. Total time: 25.31ms. Time per element: 0.25ms | |
[13:32:11] # of elements fetched individually: 100. Total time: 25.67ms. Time per element: 0.26ms | |
[13:32:11] # of elements fetched individually: 100. Total time: 25.21ms. Time per element: 0.25ms | |
[13:32:11] # of elements fetched individually: 100. Total time: 25.20ms. Time per element: 0.25ms | |
[13:32:11] # of elements fetched individually: 100. Total time: 25.51ms. Time per element: 0.26ms | |
[13:32:11] # of elements fetched individually: 100. Total time: 25.03ms. Time per element: 0.25ms | |
[13:32:11] # of elements fetched individually: 100. Total time: 28.85ms. Time per element: 0.29ms | |
[13:32:11] # of elements fetched individually: 100. Total time: 25.25ms. Time per element: 0.25ms | |
[13:32:11] # of elements fetched individually: 100. Total time: 25.48ms. Time per element: 0.25ms | |
[13:32:11] # of elements fetched individually: 100. Total time: 24.99ms. Time per element: 0.25ms | |
[13:32:12] # of elements fetched individually: 100. Total time: 25.27ms. Time per element: 0.25ms | |
[13:32:12] # of elements fetched individually: 100. Total time: 26.67ms. Time per element: 0.27ms | |
[13:32:12] # of elements fetched individually: 100. Total time: 25.14ms. Time per element: 0.25ms | |
[13:32:12] # of elements fetched individually: 100. Total time: 26.94ms. Time per element: 0.27ms | |
[13:32:12] # of elements fetched individually: 100. Total time: 25.00ms. Time per element: 0.25ms | |
[13:32:12] # of elements fetched individually: 100. Total time: 24.58ms. Time per element: 0.25ms | |
[13:32:12] # of elements fetched individually: 100. Total time: 25.03ms. Time per element: 0.25ms | |
[13:32:12] # of elements fetched individually: 100. Total time: 24.95ms. Time per element: 0.25ms | |
[13:32:12] # of elements fetched individually: 100. Total time: 25.03ms. Time per element: 0.25ms | |
[13:32:12] # of elements fetched individually: 100. Total time: 25.21ms. Time per element: 0.25ms | |
TinyORM 1-stage async v1.2.6950.23811. Change tracking: False. Caching: False. | |
-------------------------------------------------------------------------------------------- | |
First one warm-up run of each bench type to initialize constructs. Results will not be collected. | |
[13:32:12] # of elements fetched: 31465. Fetch took: 174.24ms. Enumerating result took: 1.10ms. | |
[13:32:12] # of elements fetched individually: 100. Total time: 36.37ms. Time per element: 0.36ms | |
Starting bench runs... | |
Set fetches | |
------------------------- | |
[13:32:12] # of elements fetched: 31465. Fetch took: 134.53ms. Enumerating result took: 1.24ms. | |
[13:32:12] # of elements fetched: 31465. Fetch took: 131.44ms. Enumerating result took: 1.47ms. | |
[13:32:12] # of elements fetched: 31465. Fetch took: 135.41ms. Enumerating result took: 1.29ms. | |
[13:32:13] # of elements fetched: 31465. Fetch took: 130.78ms. Enumerating result took: 1.05ms. | |
[13:32:13] # of elements fetched: 31465. Fetch took: 130.87ms. Enumerating result took: 1.06ms. | |
[13:32:13] # of elements fetched: 31465. Fetch took: 132.62ms. Enumerating result took: 1.07ms. | |
[13:32:13] # of elements fetched: 31465. Fetch took: 132.19ms. Enumerating result took: 1.07ms. | |
[13:32:13] # of elements fetched: 31465. Fetch took: 133.77ms. Enumerating result took: 1.04ms. | |
[13:32:13] # of elements fetched: 31465. Fetch took: 132.83ms. Enumerating result took: 1.07ms. | |
[13:32:13] # of elements fetched: 31465. Fetch took: 136.85ms. Enumerating result took: 1.09ms. | |
[13:32:13] # of elements fetched: 31465. Fetch took: 130.00ms. Enumerating result took: 1.10ms. | |
[13:32:14] # of elements fetched: 31465. Fetch took: 131.39ms. Enumerating result took: 1.05ms. | |
[13:32:14] # of elements fetched: 31465. Fetch took: 131.13ms. Enumerating result took: 1.04ms. | |
[13:32:14] # of elements fetched: 31465. Fetch took: 133.12ms. Enumerating result took: 1.06ms. | |
[13:32:14] # of elements fetched: 31465. Fetch took: 131.72ms. Enumerating result took: 1.07ms. | |
[13:32:14] # of elements fetched: 31465. Fetch took: 133.64ms. Enumerating result took: 1.03ms. | |
[13:32:14] # of elements fetched: 31465. Fetch took: 133.52ms. Enumerating result took: 1.13ms. | |
[13:32:14] # of elements fetched: 31465. Fetch took: 131.47ms. Enumerating result took: 1.04ms. | |
[13:32:15] # of elements fetched: 31465. Fetch took: 134.27ms. Enumerating result took: 1.07ms. | |
[13:32:15] # of elements fetched: 31465. Fetch took: 131.76ms. Enumerating result took: 1.06ms. | |
[13:32:15] # of elements fetched: 31465. Fetch took: 138.07ms. Enumerating result took: 1.74ms. | |
[13:32:15] # of elements fetched: 31465. Fetch took: 132.06ms. Enumerating result took: 1.03ms. | |
[13:32:15] # of elements fetched: 31465. Fetch took: 132.22ms. Enumerating result took: 1.08ms. | |
[13:32:15] # of elements fetched: 31465. Fetch took: 135.90ms. Enumerating result took: 1.21ms. | |
[13:32:15] # of elements fetched: 31465. Fetch took: 130.91ms. Enumerating result took: 1.07ms. | |
Single element fetches | |
------------------------- | |
[13:32:15] # of elements fetched individually: 100. Total time: 24.62ms. Time per element: 0.25ms | |
[13:32:15] # of elements fetched individually: 100. Total time: 25.21ms. Time per element: 0.25ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 24.64ms. Time per element: 0.25ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 24.19ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 23.71ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 23.56ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 23.91ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 24.11ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 24.46ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 23.94ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 23.76ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 24.31ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 23.89ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 23.87ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 23.68ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 23.99ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 24.20ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 24.16ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 23.80ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 23.82ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 24.36ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 23.98ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 23.82ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 24.12ms. Time per element: 0.24ms | |
[13:32:16] # of elements fetched individually: 100. Total time: 24.05ms. Time per element: 0.24ms | |
TinyORM 2-stage async v1.2.6950.23811. Change tracking: False. Caching: False. | |
-------------------------------------------------------------------------------------------- | |
First one warm-up run of each bench type to initialize constructs. Results will not be collected. | |
[13:32:16] # of elements fetched: 31465. Fetch took: 154.76ms. Enumerating result took: 0.95ms. | |
[13:32:16] # of elements fetched individually: 100. Total time: 33.71ms. Time per element: 0.34ms | |
Starting bench runs... | |
Set fetches | |
------------------------- | |
[13:32:16] # of elements fetched: 31465. Fetch took: 154.97ms. Enumerating result took: 0.67ms. | |
[13:32:17] # of elements fetched: 31465. Fetch took: 145.49ms. Enumerating result took: 0.73ms. | |
[13:32:17] # of elements fetched: 31465. Fetch took: 144.63ms. Enumerating result took: 0.87ms. | |
[13:32:17] # of elements fetched: 31465. Fetch took: 143.92ms. Enumerating result took: 0.85ms. | |
[13:32:17] # of elements fetched: 31465. Fetch took: 145.11ms. Enumerating result took: 0.65ms. | |
[13:32:17] # of elements fetched: 31465. Fetch took: 142.72ms. Enumerating result took: 0.66ms. | |
[13:32:17] # of elements fetched: 31465. Fetch took: 147.38ms. Enumerating result took: 0.74ms. | |
[13:32:18] # of elements fetched: 31465. Fetch took: 140.24ms. Enumerating result took: 0.77ms. | |
[13:32:18] # of elements fetched: 31465. Fetch took: 146.93ms. Enumerating result took: 0.67ms. | |
[13:32:18] # of elements fetched: 31465. Fetch took: 144.56ms. Enumerating result took: 0.82ms. | |
[13:32:18] # of elements fetched: 31465. Fetch took: 140.73ms. Enumerating result took: 0.68ms. | |
[13:32:18] # of elements fetched: 31465. Fetch took: 145.16ms. Enumerating result took: 0.72ms. | |
[13:32:18] # of elements fetched: 31465. Fetch took: 146.11ms. Enumerating result took: 0.67ms. | |
[13:32:18] # of elements fetched: 31465. Fetch took: 144.96ms. Enumerating result took: 0.85ms. | |
[13:32:19] # of elements fetched: 31465. Fetch took: 142.33ms. Enumerating result took: 0.68ms. | |
[13:32:19] # of elements fetched: 31465. Fetch took: 143.25ms. Enumerating result took: 0.83ms. | |
[13:32:19] # of elements fetched: 31465. Fetch took: 144.43ms. Enumerating result took: 0.79ms. | |
[13:32:19] # of elements fetched: 31465. Fetch took: 142.51ms. Enumerating result took: 0.78ms. | |
[13:32:19] # of elements fetched: 31465. Fetch took: 143.38ms. Enumerating result took: 0.76ms. | |
[13:32:19] # of elements fetched: 31465. Fetch took: 142.93ms. Enumerating result took: 0.67ms. | |
[13:32:20] # of elements fetched: 31465. Fetch took: 143.76ms. Enumerating result took: 0.80ms. | |
[13:32:20] # of elements fetched: 31465. Fetch took: 143.07ms. Enumerating result took: 0.66ms. | |
[13:32:20] # of elements fetched: 31465. Fetch took: 143.90ms. Enumerating result took: 0.72ms. | |
[13:32:20] # of elements fetched: 31465. Fetch took: 149.47ms. Enumerating result took: 0.68ms. | |
[13:32:20] # of elements fetched: 31465. Fetch took: 145.50ms. Enumerating result took: 0.70ms. | |
Single element fetches | |
------------------------- | |
[13:32:20] # of elements fetched individually: 100. Total time: 25.51ms. Time per element: 0.26ms | |
[13:32:20] # of elements fetched individually: 100. Total time: 24.92ms. Time per element: 0.25ms | |
[13:32:20] # of elements fetched individually: 100. Total time: 24.76ms. Time per element: 0.25ms | |
[13:32:20] # of elements fetched individually: 100. Total time: 24.49ms. Time per element: 0.24ms | |
[13:32:20] # of elements fetched individually: 100. Total time: 24.26ms. Time per element: 0.24ms | |
[13:32:20] # of elements fetched individually: 100. Total time: 24.69ms. Time per element: 0.25ms | |
[13:32:20] # of elements fetched individually: 100. Total time: 24.73ms. Time per element: 0.25ms | |
[13:32:20] # of elements fetched individually: 100. Total time: 24.47ms. Time per element: 0.24ms | |
[13:32:20] # of elements fetched individually: 100. Total time: 24.66ms. Time per element: 0.25ms | |
[13:32:20] # of elements fetched individually: 100. Total time: 24.26ms. Time per element: 0.24ms | |
[13:32:20] # of elements fetched individually: 100. Total time: 24.45ms. Time per element: 0.24ms | |
[13:32:20] # of elements fetched individually: 100. Total time: 24.84ms. Time per element: 0.25ms | |
[13:32:20] # of elements fetched individually: 100. Total time: 24.15ms. Time per element: 0.24ms | |
[13:32:21] # of elements fetched individually: 100. Total time: 24.44ms. Time per element: 0.24ms | |
[13:32:21] # of elements fetched individually: 100. Total time: 24.70ms. Time per element: 0.25ms | |
[13:32:21] # of elements fetched individually: 100. Total time: 26.26ms. Time per element: 0.26ms | |
[13:32:21] # of elements fetched individually: 100. Total time: 24.43ms. Time per element: 0.24ms | |
[13:32:21] # of elements fetched individually: 100. Total time: 25.13ms. Time per element: 0.25ms | |
[13:32:21] # of elements fetched individually: 100. Total time: 24.59ms. Time per element: 0.25ms | |
[13:32:21] # of elements fetched individually: 100. Total time: 24.37ms. Time per element: 0.24ms | |
[13:32:21] # of elements fetched individually: 100. Total time: 24.73ms. Time per element: 0.25ms | |
[13:32:21] # of elements fetched individually: 100. Total time: 24.94ms. Time per element: 0.25ms | |
[13:32:21] # of elements fetched individually: 100. Total time: 24.39ms. Time per element: 0.24ms | |
[13:32:21] # of elements fetched individually: 100. Total time: 24.72ms. Time per element: 0.25ms | |
[13:32:21] # of elements fetched individually: 100. Total time: 24.44ms. Time per element: 0.24ms | |
RepoDb (RawSql) async v1.7.0.5. Change tracking: False. Caching: False. | |
-------------------------------------------------------------------------------------------- | |
First one warm-up run of each bench type to initialize constructs. Results will not be collected. | |
[13:32:21] # of elements fetched: 31465. Fetch took: 156.93ms. Enumerating result took: 1.11ms. | |
[13:32:21] # of elements fetched individually: 100. Total time: 33.00ms. Time per element: 0.33ms | |
Starting bench runs... | |
Set fetches | |
------------------------- | |
[13:32:21] # of elements fetched: 31465. Fetch took: 139.92ms. Enumerating result took: 1.01ms. | |
[13:32:21] # of elements fetched: 31465. Fetch took: 131.24ms. Enumerating result took: 1.05ms. | |
[13:32:21] # of elements fetched: 31465. Fetch took: 131.72ms. Enumerating result took: 1.02ms. | |
[13:32:22] # of elements fetched: 31465. Fetch took: 131.24ms. Enumerating result took: 1.08ms. | |
[13:32:22] # of elements fetched: 31465. Fetch took: 133.34ms. Enumerating result took: 1.02ms. | |
[13:32:22] # of elements fetched: 31465. Fetch took: 132.07ms. Enumerating result took: 1.03ms. | |
[13:32:22] # of elements fetched: 31465. Fetch took: 131.44ms. Enumerating result took: 1.03ms. | |
[13:32:22] # of elements fetched: 31465. Fetch took: 135.18ms. Enumerating result took: 1.09ms. | |
[13:32:22] # of elements fetched: 31465. Fetch took: 131.51ms. Enumerating result took: 1.03ms. | |
[13:32:22] # of elements fetched: 31465. Fetch took: 131.31ms. Enumerating result took: 1.04ms. | |
[13:32:23] # of elements fetched: 31465. Fetch took: 131.87ms. Enumerating result took: 1.06ms. | |
[13:32:23] # of elements fetched: 31465. Fetch took: 131.72ms. Enumerating result took: 1.37ms. | |
[13:32:23] # of elements fetched: 31465. Fetch took: 130.95ms. Enumerating result took: 1.02ms. | |
[13:32:23] # of elements fetched: 31465. Fetch took: 130.92ms. Enumerating result took: 1.01ms. | |
[13:32:23] # of elements fetched: 31465. Fetch took: 133.51ms. Enumerating result took: 1.04ms. | |
[13:32:23] # of elements fetched: 31465. Fetch took: 136.73ms. Enumerating result took: 1.02ms. | |
[13:32:23] # of elements fetched: 31465. Fetch took: 132.42ms. Enumerating result took: 1.00ms. | |
[13:32:23] # of elements fetched: 31465. Fetch took: 132.95ms. Enumerating result took: 1.00ms. | |
[13:32:24] # of elements fetched: 31465. Fetch took: 136.16ms. Enumerating result took: 1.10ms. | |
[13:32:24] # of elements fetched: 31465. Fetch took: 131.67ms. Enumerating result took: 1.03ms. | |
[13:32:24] # of elements fetched: 31465. Fetch took: 132.74ms. Enumerating result took: 1.03ms. | |
[13:32:24] # of elements fetched: 31465. Fetch took: 132.75ms. Enumerating result took: 1.04ms. | |
[13:32:24] # of elements fetched: 31465. Fetch took: 137.32ms. Enumerating result took: 1.34ms. | |
[13:32:24] # of elements fetched: 31465. Fetch took: 131.99ms. Enumerating result took: 1.01ms. | |
[13:32:24] # of elements fetched: 31465. Fetch took: 132.07ms. Enumerating result took: 1.03ms. | |
Single element fetches | |
------------------------- | |
[13:32:24] # of elements fetched individually: 100. Total time: 28.59ms. Time per element: 0.29ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 27.52ms. Time per element: 0.28ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 27.18ms. Time per element: 0.27ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 27.19ms. Time per element: 0.27ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 26.78ms. Time per element: 0.27ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 26.66ms. Time per element: 0.27ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 27.28ms. Time per element: 0.27ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 27.37ms. Time per element: 0.27ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 26.96ms. Time per element: 0.27ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 27.71ms. Time per element: 0.28ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 26.73ms. Time per element: 0.27ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 27.22ms. Time per element: 0.27ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 26.58ms. Time per element: 0.27ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 26.72ms. Time per element: 0.27ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 28.21ms. Time per element: 0.28ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 28.67ms. Time per element: 0.29ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 27.67ms. Time per element: 0.28ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 27.20ms. Time per element: 0.27ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 26.51ms. Time per element: 0.27ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 30.76ms. Time per element: 0.31ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 27.03ms. Time per element: 0.27ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 26.72ms. Time per element: 0.27ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 27.27ms. Time per element: 0.27ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 26.83ms. Time per element: 0.27ms | |
[13:32:25] # of elements fetched individually: 100. Total time: 27.04ms. Time per element: 0.27ms | |
LLBLGen Pro async v5.5.0.0 (v5.5.0), Poco with Raw SQL. Change tracking: False. Caching: False. | |
-------------------------------------------------------------------------------------------- | |
First one warm-up run of each bench type to initialize constructs. Results will not be collected. | |
[13:32:25] # of elements fetched: 31465. Fetch took: 268.59ms. Enumerating result took: 1.18ms. | |
[13:32:25] # of elements fetched individually: 100. Total time: 36.17ms. Time per element: 0.36ms | |
Starting bench runs... | |
Set fetches | |
------------------------- | |
[13:32:26] # of elements fetched: 31465. Fetch took: 149.56ms. Enumerating result took: 1.16ms. | |
[13:32:26] # of elements fetched: 31465. Fetch took: 146.26ms. Enumerating result took: 1.25ms. | |
[13:32:26] # of elements fetched: 31465. Fetch took: 144.36ms. Enumerating result took: 1.10ms. | |
[13:32:26] # of elements fetched: 31465. Fetch took: 149.11ms. Enumerating result took: 1.09ms. | |
[13:32:26] # of elements fetched: 31465. Fetch took: 143.75ms. Enumerating result took: 1.39ms. | |
[13:32:26] # of elements fetched: 31465. Fetch took: 144.18ms. Enumerating result took: 1.05ms. | |
[13:32:27] # of elements fetched: 31465. Fetch took: 145.06ms. Enumerating result took: 1.06ms. | |
[13:32:27] # of elements fetched: 31465. Fetch took: 145.41ms. Enumerating result took: 1.07ms. | |
[13:32:27] # of elements fetched: 31465. Fetch took: 146.33ms. Enumerating result took: 1.14ms. | |
[13:32:27] # of elements fetched: 31465. Fetch took: 149.20ms. Enumerating result took: 1.11ms. | |
[13:32:27] # of elements fetched: 31465. Fetch took: 143.64ms. Enumerating result took: 1.08ms. | |
[13:32:27] # of elements fetched: 31465. Fetch took: 142.71ms. Enumerating result took: 1.05ms. | |
[13:32:27] # of elements fetched: 31465. Fetch took: 144.69ms. Enumerating result took: 1.09ms. | |
[13:32:28] # of elements fetched: 31465. Fetch took: 142.91ms. Enumerating result took: 1.08ms. | |
[13:32:28] # of elements fetched: 31465. Fetch took: 142.61ms. Enumerating result took: 1.09ms. | |
[13:32:28] # of elements fetched: 31465. Fetch took: 142.98ms. Enumerating result took: 1.15ms. | |
[13:32:28] # of elements fetched: 31465. Fetch took: 146.07ms. Enumerating result took: 1.06ms. | |
[13:32:28] # of elements fetched: 31465. Fetch took: 144.09ms. Enumerating result took: 1.07ms. | |
[13:32:28] # of elements fetched: 31465. Fetch took: 144.25ms. Enumerating result took: 1.46ms. | |
[13:32:28] # of elements fetched: 31465. Fetch took: 146.93ms. Enumerating result took: 1.06ms. | |
[13:32:29] # of elements fetched: 31465. Fetch took: 141.88ms. Enumerating result took: 1.07ms. | |
[13:32:29] # of elements fetched: 31465. Fetch took: 142.59ms. Enumerating result took: 1.07ms. | |
[13:32:29] # of elements fetched: 31465. Fetch took: 146.45ms. Enumerating result took: 1.28ms. | |
[13:32:29] # of elements fetched: 31465. Fetch took: 143.53ms. Enumerating result took: 1.11ms. | |
[13:32:29] # of elements fetched: 31465. Fetch took: 144.06ms. Enumerating result took: 1.34ms. | |
Single element fetches | |
------------------------- | |
[13:32:29] # of elements fetched individually: 100. Total time: 34.47ms. Time per element: 0.34ms | |
[13:32:29] # of elements fetched individually: 100. Total time: 32.23ms. Time per element: 0.32ms | |
[13:32:29] # of elements fetched individually: 100. Total time: 31.34ms. Time per element: 0.31ms | |
[13:32:29] # of elements fetched individually: 100. Total time: 29.53ms. Time per element: 0.30ms | |
[13:32:29] # of elements fetched individually: 100. Total time: 28.41ms. Time per element: 0.28ms | |
[13:32:29] # of elements fetched individually: 100. Total time: 28.71ms. Time per element: 0.29ms | |
[13:32:29] # of elements fetched individually: 100. Total time: 28.54ms. Time per element: 0.29ms | |
[13:32:30] # of elements fetched individually: 100. Total time: 28.49ms. Time per element: 0.28ms | |
[13:32:30] # of elements fetched individually: 100. Total time: 30.45ms. Time per element: 0.30ms | |
[13:32:30] # of elements fetched individually: 100. Total time: 30.33ms. Time per element: 0.30ms | |
[13:32:30] # of elements fetched individually: 100. Total time: 28.68ms. Time per element: 0.29ms | |
[13:32:30] # of elements fetched individually: 100. Total time: 28.50ms. Time per element: 0.28ms | |
[13:32:30] # of elements fetched individually: 100. Total time: 28.17ms. Time per element: 0.28ms | |
[13:32:30] # of elements fetched individually: 100. Total time: 28.72ms. Time per element: 0.29ms | |
[13:32:30] # of elements fetched individually: 100. Total time: 28.52ms. Time per element: 0.29ms | |
[13:32:30] # of elements fetched individually: 100. Total time: 27.87ms. Time per element: 0.28ms | |
[13:32:30] # of elements fetched individually: 100. Total time: 27.81ms. Time per element: 0.28ms | |
[13:32:30] # of elements fetched individually: 100. Total time: 28.62ms. Time per element: 0.29ms | |
[13:32:30] # of elements fetched individually: 100. Total time: 28.59ms. Time per element: 0.29ms | |
[13:32:30] # of elements fetched individually: 100. Total time: 30.04ms. Time per element: 0.30ms | |
[13:32:30] # of elements fetched individually: 100. Total time: 28.70ms. Time per element: 0.29ms | |
[13:32:30] # of elements fetched individually: 100. Total time: 29.38ms. Time per element: 0.29ms | |
[13:32:30] # of elements fetched individually: 100. Total time: 29.00ms. Time per element: 0.29ms | |
[13:32:30] # of elements fetched individually: 100. Total time: 28.60ms. Time per element: 0.29ms | |
[13:32:30] # of elements fetched individually: 100. Total time: 28.31ms. Time per element: 0.28ms | |
Dapper async v1.50.5.0. Change tracking: False. Caching: False. | |
-------------------------------------------------------------------------------------------- | |
First one warm-up run of each bench type to initialize constructs. Results will not be collected. | |
[13:32:30] # of elements fetched: 31465. Fetch took: 193.02ms. Enumerating result took: 1.42ms. | |
[13:32:30] # of elements fetched individually: 100. Total time: 46.95ms. Time per element: 0.47ms | |
Starting bench runs... | |
Set fetches | |
------------------------- | |
[13:32:30] # of elements fetched: 31465. Fetch took: 159.85ms. Enumerating result took: 1.09ms. | |
[13:32:31] # of elements fetched: 31465. Fetch took: 162.38ms. Enumerating result took: 1.07ms. | |
[13:32:31] # of elements fetched: 31465. Fetch took: 159.48ms. Enumerating result took: 1.31ms. | |
[13:32:31] # of elements fetched: 31465. Fetch took: 168.54ms. Enumerating result took: 1.11ms. | |
[13:32:31] # of elements fetched: 31465. Fetch took: 162.68ms. Enumerating result took: 1.08ms. | |
[13:32:31] # of elements fetched: 31465. Fetch took: 155.07ms. Enumerating result took: 1.10ms. | |
[13:32:31] # of elements fetched: 31465. Fetch took: 159.65ms. Enumerating result took: 1.28ms. | |
[13:32:32] # of elements fetched: 31465. Fetch took: 158.49ms. Enumerating result took: 1.05ms. | |
[13:32:32] # of elements fetched: 31465. Fetch took: 174.48ms. Enumerating result took: 1.14ms. | |
[13:32:32] # of elements fetched: 31465. Fetch took: 160.30ms. Enumerating result took: 1.15ms. | |
[13:32:32] # of elements fetched: 31465. Fetch took: 162.15ms. Enumerating result took: 1.32ms. | |
[13:32:32] # of elements fetched: 31465. Fetch took: 157.16ms. Enumerating result took: 1.34ms. | |
[13:32:32] # of elements fetched: 31465. Fetch took: 160.13ms. Enumerating result took: 1.39ms. | |
[13:32:33] # of elements fetched: 31465. Fetch took: 162.94ms. Enumerating result took: 1.12ms. | |
[13:32:33] # of elements fetched: 31465. Fetch took: 164.84ms. Enumerating result took: 1.04ms. | |
[13:32:33] # of elements fetched: 31465. Fetch took: 159.57ms. Enumerating result took: 1.45ms. | |
[13:32:33] # of elements fetched: 31465. Fetch took: 160.39ms. Enumerating result took: 1.43ms. | |
[13:32:33] # of elements fetched: 31465. Fetch took: 155.94ms. Enumerating result took: 1.63ms. | |
[13:32:34] # of elements fetched: 31465. Fetch took: 165.76ms. Enumerating result took: 1.02ms. | |
[13:32:34] # of elements fetched: 31465. Fetch took: 157.69ms. Enumerating result took: 1.12ms. | |
[13:32:34] # of elements fetched: 31465. Fetch took: 163.91ms. Enumerating result took: 1.29ms. | |
[13:32:34] # of elements fetched: 31465. Fetch took: 162.00ms. Enumerating result took: 1.10ms. | |
[13:32:34] # of elements fetched: 31465. Fetch took: 156.97ms. Enumerating result took: 1.35ms. | |
[13:32:34] # of elements fetched: 31465. Fetch took: 160.35ms. Enumerating result took: 1.38ms. | |
[13:32:35] # of elements fetched: 31465. Fetch took: 159.85ms. Enumerating result took: 1.13ms. | |
Single element fetches | |
------------------------- | |
[13:32:35] # of elements fetched individually: 100. Total time: 29.00ms. Time per element: 0.29ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 28.77ms. Time per element: 0.29ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 28.00ms. Time per element: 0.28ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 26.19ms. Time per element: 0.26ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 26.17ms. Time per element: 0.26ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 26.45ms. Time per element: 0.26ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 26.01ms. Time per element: 0.26ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 29.54ms. Time per element: 0.30ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 26.19ms. Time per element: 0.26ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 26.50ms. Time per element: 0.27ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 25.85ms. Time per element: 0.26ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 26.24ms. Time per element: 0.26ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 26.17ms. Time per element: 0.26ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 26.69ms. Time per element: 0.27ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 26.44ms. Time per element: 0.26ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 26.46ms. Time per element: 0.26ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 26.42ms. Time per element: 0.26ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 26.18ms. Time per element: 0.26ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 26.60ms. Time per element: 0.27ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 26.19ms. Time per element: 0.26ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 26.53ms. Time per element: 0.27ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 26.11ms. Time per element: 0.26ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 26.26ms. Time per element: 0.26ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 26.36ms. Time per element: 0.26ms | |
[13:32:35] # of elements fetched individually: 100. Total time: 26.41ms. Time per element: 0.26ms | |
NPoco async v3.9.4.0 (v3.9.4.0). Change tracking: False. Caching: False. | |
-------------------------------------------------------------------------------------------- | |
First one warm-up run of each bench type to initialize constructs. Results will not be collected. | |
[13:32:35] # of elements fetched: 31465. Fetch took: 245.50ms. Enumerating result took: 1.24ms. | |
[13:32:36] # of elements fetched individually: 100. Total time: 109.37ms. Time per element: 1.09ms | |
Starting bench runs... | |
Set fetches | |
------------------------- | |
[13:32:36] # of elements fetched: 31465. Fetch took: 163.64ms. Enumerating result took: 1.78ms. | |
[13:32:36] # of elements fetched: 31465. Fetch took: 169.66ms. Enumerating result took: 1.60ms. | |
[13:32:36] # of elements fetched: 31465. Fetch took: 156.95ms. Enumerating result took: 1.61ms. | |
[13:32:36] # of elements fetched: 31465. Fetch took: 159.23ms. Enumerating result took: 1.44ms. | |
[13:32:36] # of elements fetched: 31465. Fetch took: 158.34ms. Enumerating result took: 1.52ms. | |
[13:32:37] # of elements fetched: 31465. Fetch took: 157.97ms. Enumerating result took: 1.79ms. | |
[13:32:37] # of elements fetched: 31465. Fetch took: 160.62ms. Enumerating result took: 1.96ms. | |
[13:32:37] # of elements fetched: 31465. Fetch took: 158.65ms. Enumerating result took: 1.57ms. | |
[13:32:37] # of elements fetched: 31465. Fetch took: 157.95ms. Enumerating result took: 2.69ms. | |
[13:32:37] # of elements fetched: 31465. Fetch took: 160.17ms. Enumerating result took: 1.75ms. | |
[13:32:37] # of elements fetched: 31465. Fetch took: 158.30ms. Enumerating result took: 3.04ms. | |
[13:32:38] # of elements fetched: 31465. Fetch took: 164.00ms. Enumerating result took: 3.66ms. | |
[13:32:38] # of elements fetched: 31465. Fetch took: 174.37ms. Enumerating result took: 4.42ms. | |
[13:32:38] # of elements fetched: 31465. Fetch took: 157.38ms. Enumerating result took: 1.08ms. | |
[13:32:38] # of elements fetched: 31465. Fetch took: 153.64ms. Enumerating result took: 1.15ms. | |
[13:32:38] # of elements fetched: 31465. Fetch took: 156.09ms. Enumerating result took: 1.11ms. | |
[13:32:38] # of elements fetched: 31465. Fetch took: 151.83ms. Enumerating result took: 2.17ms. | |
[13:32:39] # of elements fetched: 31465. Fetch took: 158.57ms. Enumerating result took: 1.11ms. | |
[13:32:39] # of elements fetched: 31465. Fetch took: 153.05ms. Enumerating result took: 1.14ms. | |
[13:32:39] # of elements fetched: 31465. Fetch took: 157.24ms. Enumerating result took: 1.31ms. | |
[13:32:39] # of elements fetched: 31465. Fetch took: 151.90ms. Enumerating result took: 2.06ms. | |
[13:32:39] # of elements fetched: 31465. Fetch took: 155.76ms. Enumerating result took: 1.08ms. | |
[13:32:39] # of elements fetched: 31465. Fetch took: 150.70ms. Enumerating result took: 2.10ms. | |
[13:32:40] # of elements fetched: 31465. Fetch took: 156.16ms. Enumerating result took: 1.12ms. | |
[13:32:40] # of elements fetched: 31465. Fetch took: 154.67ms. Enumerating result took: 1.15ms. | |
Single element fetches | |
------------------------- | |
[13:32:40] # of elements fetched individually: 100. Total time: 83.69ms. Time per element: 0.84ms | |
[13:32:40] # of elements fetched individually: 100. Total time: 84.62ms. Time per element: 0.85ms | |
[13:32:40] # of elements fetched individually: 100. Total time: 83.21ms. Time per element: 0.83ms | |
[13:32:40] # of elements fetched individually: 100. Total time: 77.46ms. Time per element: 0.77ms | |
[13:32:40] # of elements fetched individually: 100. Total time: 75.09ms. Time per element: 0.75ms | |
[13:32:40] # of elements fetched individually: 100. Total time: 74.31ms. Time per element: 0.74ms | |
[13:32:40] # of elements fetched individually: 100. Total time: 74.65ms. Time per element: 0.75ms | |
[13:32:40] # of elements fetched individually: 100. Total time: 75.47ms. Time per element: 0.75ms | |
[13:32:40] # of elements fetched individually: 100. Total time: 76.46ms. Time per element: 0.76ms | |
[13:32:41] # of elements fetched individually: 100. Total time: 74.52ms. Time per element: 0.75ms | |
[13:32:41] # of elements fetched individually: 100. Total time: 79.35ms. Time per element: 0.79ms | |
[13:32:41] # of elements fetched individually: 100. Total time: 75.51ms. Time per element: 0.76ms | |
[13:32:41] # of elements fetched individually: 100. Total time: 74.52ms. Time per element: 0.75ms | |
[13:32:41] # of elements fetched individually: 100. Total time: 81.80ms. Time per element: 0.82ms | |
[13:32:41] # of elements fetched individually: 100. Total time: 75.04ms. Time per element: 0.75ms | |
[13:32:41] # of elements fetched individually: 100. Total time: 81.40ms. Time per element: 0.81ms | |
[13:32:41] # of elements fetched individually: 100. Total time: 76.52ms. Time per element: 0.77ms | |
[13:32:41] # of elements fetched individually: 100. Total time: 76.58ms. Time per element: 0.77ms | |
[13:32:41] # of elements fetched individually: 100. Total time: 76.89ms. Time per element: 0.77ms | |
[13:32:41] # of elements fetched individually: 100. Total time: 76.28ms. Time per element: 0.76ms | |
[13:32:41] # of elements fetched individually: 100. Total time: 77.28ms. Time per element: 0.77ms | |
[13:32:42] # of elements fetched individually: 100. Total time: 77.85ms. Time per element: 0.78ms | |
[13:32:42] # of elements fetched individually: 100. Total time: 80.54ms. Time per element: 0.81ms | |
[13:32:42] # of elements fetched individually: 100. Total time: 78.06ms. Time per element: 0.78ms | |
[13:32:42] # of elements fetched individually: 100. Total time: 77.82ms. Time per element: 0.78ms | |
ServiceStack OrmLite async v5.0.0.0 (v5.4.0.0). Change tracking: False. Caching: False. | |
-------------------------------------------------------------------------------------------- | |
First one warm-up run of each bench type to initialize constructs. Results will not be collected. | |
[13:32:42] # of elements fetched: 31465. Fetch took: 392.27ms. Enumerating result took: 1.19ms. | |
[13:32:42] # of elements fetched individually: 100. Total time: 49.86ms. Time per element: 0.50ms | |
Starting bench runs... | |
Set fetches | |
------------------------- | |
[13:32:43] # of elements fetched: 31465. Fetch took: 320.68ms. Enumerating result took: 1.10ms. | |
[13:32:43] # of elements fetched: 31465. Fetch took: 317.07ms. Enumerating result took: 1.09ms. | |
[13:32:43] # of elements fetched: 31465. Fetch took: 311.77ms. Enumerating result took: 1.13ms. | |
[13:32:43] # of elements fetched: 31465. Fetch took: 316.79ms. Enumerating result took: 1.09ms. | |
[13:32:44] # of elements fetched: 31465. Fetch took: 318.97ms. Enumerating result took: 1.09ms. | |
[13:32:44] # of elements fetched: 31465. Fetch took: 313.57ms. Enumerating result took: 1.11ms. | |
[13:32:44] # of elements fetched: 31465. Fetch took: 347.91ms. Enumerating result took: 1.96ms. | |
[13:32:45] # of elements fetched: 31465. Fetch took: 328.27ms. Enumerating result took: 1.10ms. | |
[13:32:45] # of elements fetched: 31465. Fetch took: 315.36ms. Enumerating result took: 1.11ms. | |
[13:32:45] # of elements fetched: 31465. Fetch took: 325.04ms. Enumerating result took: 1.14ms. | |
[13:32:46] # of elements fetched: 31465. Fetch took: 337.16ms. Enumerating result took: 1.13ms. | |
[13:32:46] # of elements fetched: 31465. Fetch took: 348.90ms. Enumerating result took: 1.19ms. | |
[13:32:47] # of elements fetched: 31465. Fetch took: 346.08ms. Enumerating result took: 1.18ms. | |
[13:32:47] # of elements fetched: 31465. Fetch took: 340.23ms. Enumerating result took: 1.15ms. | |
[13:32:47] # of elements fetched: 31465. Fetch took: 337.76ms. Enumerating result took: 1.11ms. | |
[13:32:48] # of elements fetched: 31465. Fetch took: 335.85ms. Enumerating result took: 1.22ms. | |
[13:32:48] # of elements fetched: 31465. Fetch took: 337.85ms. Enumerating result took: 1.14ms. | |
[13:32:48] # of elements fetched: 31465. Fetch took: 340.32ms. Enumerating result took: 1.52ms. | |
[13:32:49] # of elements fetched: 31465. Fetch took: 332.74ms. Enumerating result took: 1.17ms. | |
[13:32:49] # of elements fetched: 31465. Fetch took: 334.79ms. Enumerating result took: 1.68ms. | |
[13:32:49] # of elements fetched: 31465. Fetch took: 335.54ms. Enumerating result took: 1.18ms. | |
[13:32:50] # of elements fetched: 31465. Fetch took: 336.55ms. Enumerating result took: 1.15ms. | |
[13:32:50] # of elements fetched: 31465. Fetch took: 335.03ms. Enumerating result took: 1.14ms. | |
[13:32:50] # of elements fetched: 31465. Fetch took: 340.82ms. Enumerating result took: 1.15ms. | |
[13:32:51] # of elements fetched: 31465. Fetch took: 332.13ms. Enumerating result took: 1.26ms. | |
Single element fetches | |
------------------------- | |
[13:32:51] # of elements fetched individually: 100. Total time: 29.55ms. Time per element: 0.30ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 29.81ms. Time per element: 0.30ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 30.31ms. Time per element: 0.30ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 29.89ms. Time per element: 0.30ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 29.91ms. Time per element: 0.30ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 30.26ms. Time per element: 0.30ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 29.97ms. Time per element: 0.30ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 30.14ms. Time per element: 0.30ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 30.36ms. Time per element: 0.30ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 30.01ms. Time per element: 0.30ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 30.20ms. Time per element: 0.30ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 29.50ms. Time per element: 0.30ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 28.91ms. Time per element: 0.29ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 29.28ms. Time per element: 0.29ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 30.18ms. Time per element: 0.30ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 30.52ms. Time per element: 0.31ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 30.06ms. Time per element: 0.30ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 33.54ms. Time per element: 0.34ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 30.37ms. Time per element: 0.30ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 29.95ms. Time per element: 0.30ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 30.12ms. Time per element: 0.30ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 30.12ms. Time per element: 0.30ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 29.95ms. Time per element: 0.30ms | |
[13:32:51] # of elements fetched individually: 100. Total time: 29.25ms. Time per element: 0.29ms | |
[13:32:52] # of elements fetched individually: 100. Total time: 29.07ms. Time per element: 0.29ms | |
EF Core async v2.2.1.0 (v2.2.1.18346). Change tracking: False. Caching: False. | |
-------------------------------------------------------------------------------------------- | |
First one warm-up run of each bench type to initialize constructs. Results will not be collected. | |
[13:32:54] # of elements fetched: 31465. Fetch took: 2,025.56ms. Enumerating result took: 1.23ms. | |
[13:32:54] # of elements fetched individually: 100. Total time: 223.26ms. Time per element: 2.23ms | |
Starting bench runs... | |
Set fetches | |
------------------------- | |
[13:32:54] # of elements fetched: 31465. Fetch took: 326.29ms. Enumerating result took: 1.47ms. | |
[13:32:54] # of elements fetched: 31465. Fetch took: 335.53ms. Enumerating result took: 1.43ms. | |
[13:32:55] # of elements fetched: 31465. Fetch took: 339.20ms. Enumerating result took: 1.12ms. | |
[13:32:55] # of elements fetched: 31465. Fetch took: 330.03ms. Enumerating result took: 1.15ms. | |
[13:32:55] # of elements fetched: 31465. Fetch took: 339.19ms. Enumerating result took: 1.35ms. | |
[13:32:56] # of elements fetched: 31465. Fetch took: 331.26ms. Enumerating result took: 1.32ms. | |
[13:32:56] # of elements fetched: 31465. Fetch took: 337.74ms. Enumerating result took: 1.12ms. | |
[13:32:57] # of elements fetched: 31465. Fetch took: 335.09ms. Enumerating result took: 1.19ms. | |
[13:32:57] # of elements fetched: 31465. Fetch took: 334.09ms. Enumerating result took: 1.36ms. | |
[13:32:57] # of elements fetched: 31465. Fetch took: 337.34ms. Enumerating result took: 1.12ms. | |
[13:32:58] # of elements fetched: 31465. Fetch took: 329.42ms. Enumerating result took: 1.34ms. | |
[13:32:58] # of elements fetched: 31465. Fetch took: 335.93ms. Enumerating result took: 1.24ms. | |
[13:32:58] # of elements fetched: 31465. Fetch took: 334.93ms. Enumerating result took: 1.11ms. | |
[13:32:59] # of elements fetched: 31465. Fetch took: 329.49ms. Enumerating result took: 1.16ms. | |
[13:32:59] # of elements fetched: 31465. Fetch took: 328.45ms. Enumerating result took: 1.12ms. | |
[13:32:59] # of elements fetched: 31465. Fetch took: 333.17ms. Enumerating result took: 1.13ms. | |
[13:33:00] # of elements fetched: 31465. Fetch took: 332.82ms. Enumerating result took: 1.12ms. | |
[13:33:00] # of elements fetched: 31465. Fetch took: 332.41ms. Enumerating result took: 1.34ms. | |
[13:33:00] # of elements fetched: 31465. Fetch took: 331.26ms. Enumerating result took: 1.11ms. | |
[13:33:01] # of elements fetched: 31465. Fetch took: 340.29ms. Enumerating result took: 1.36ms. | |
[13:33:01] # of elements fetched: 31465. Fetch took: 340.47ms. Enumerating result took: 1.11ms. | |
[13:33:01] # of elements fetched: 31465. Fetch took: 334.17ms. Enumerating result took: 1.11ms. | |
[13:33:02] # of elements fetched: 31465. Fetch took: 341.98ms. Enumerating result took: 1.15ms. | |
[13:33:02] # of elements fetched: 31465. Fetch took: 336.82ms. Enumerating result took: 1.12ms. | |
[13:33:02] # of elements fetched: 31465. Fetch took: 332.72ms. Enumerating result took: 1.11ms. | |
Single element fetches | |
------------------------- | |
[13:33:03] # of elements fetched individually: 100. Total time: 57.86ms. Time per element: 0.58ms | |
[13:33:03] # of elements fetched individually: 100. Total time: 61.33ms. Time per element: 0.61ms | |
[13:33:03] # of elements fetched individually: 100. Total time: 58.37ms. Time per element: 0.58ms | |
[13:33:03] # of elements fetched individually: 100. Total time: 57.98ms. Time per element: 0.58ms | |
[13:33:03] # of elements fetched individually: 100. Total time: 56.73ms. Time per element: 0.57ms | |
[13:33:03] # of elements fetched individually: 100. Total time: 58.45ms. Time per element: 0.58ms | |
[13:33:03] # of elements fetched individually: 100. Total time: 62.10ms. Time per element: 0.62ms | |
[13:33:03] # of elements fetched individually: 100. Total time: 56.27ms. Time per element: 0.56ms | |
[13:33:03] # of elements fetched individually: 100. Total time: 56.51ms. Time per element: 0.57ms | |
[13:33:03] # of elements fetched individually: 100. Total time: 56.48ms. Time per element: 0.56ms | |
[13:33:03] # of elements fetched individually: 100. Total time: 55.89ms. Time per element: 0.56ms | |
[13:33:03] # of elements fetched individually: 100. Total time: 55.41ms. Time per element: 0.55ms | |
[13:33:03] # of elements fetched individually: 100. Total time: 54.95ms. Time per element: 0.55ms | |
[13:33:03] # of elements fetched individually: 100. Total time: 58.24ms. Time per element: 0.58ms | |
[13:33:03] # of elements fetched individually: 100. Total time: 57.05ms. Time per element: 0.57ms | |
[13:33:04] # of elements fetched individually: 100. Total time: 57.31ms. Time per element: 0.57ms | |
[13:33:04] # of elements fetched individually: 100. Total time: 57.09ms. Time per element: 0.57ms | |
[13:33:04] # of elements fetched individually: 100. Total time: 56.21ms. Time per element: 0.56ms | |
[13:33:04] # of elements fetched individually: 100. Total time: 55.90ms. Time per element: 0.56ms | |
[13:33:04] # of elements fetched individually: 100. Total time: 56.87ms. Time per element: 0.57ms | |
[13:33:04] # of elements fetched individually: 100. Total time: 56.52ms. Time per element: 0.57ms | |
[13:33:04] # of elements fetched individually: 100. Total time: 61.02ms. Time per element: 0.61ms | |
[13:33:04] # of elements fetched individually: 100. Total time: 55.25ms. Time per element: 0.55ms | |
[13:33:04] # of elements fetched individually: 100. Total time: 55.50ms. Time per element: 0.55ms | |
[13:33:04] # of elements fetched individually: 100. Total time: 55.53ms. Time per element: 0.56ms | |
Performing memory measurement runs. | |
==================================================================== | |
Handcoded async [GetValues(array), boxing]. Change tracking: False. Caching: False. | |
-------------------------------------------------------------------------------------------- | |
Starting bench runs... | |
Set fetches | |
------------------------- | |
[13:33:04] # of elements fetched: 31465. Fetch took: 122.15ms. Allocated bytes: 31556336. | |
Single element fetches | |
------------------------- | |
[13:33:04] # of elements fetched individually: 100. Total time: 25.92ms. Allocated bytes per element: 32768. | |
TinyORM 1-stage async v1.2.6950.23811. Change tracking: False. Caching: False. | |
-------------------------------------------------------------------------------------------- | |
Starting bench runs... | |
Set fetches | |
------------------------- | |
[13:33:04] # of elements fetched: 31465. Fetch took: 135.21ms. Allocated bytes: 31567776. | |
Single element fetches | |
------------------------- | |
[13:33:05] # of elements fetched individually: 100. Total time: 55.00ms. Allocated bytes per element: 57392. | |
TinyORM 2-stage async v1.2.6950.23811. Change tracking: False. Caching: False. | |
-------------------------------------------------------------------------------------------- | |
Starting bench runs... | |
Set fetches | |
------------------------- | |
[13:33:05] # of elements fetched: 31465. Fetch took: 154.27ms. Allocated bytes: 39491512. | |
Single element fetches | |
------------------------- | |
[13:33:05] # of elements fetched individually: 100. Total time: 50.76ms. Allocated bytes per element: 57392. | |
RepoDb (RawSql) async v1.7.0.5. Change tracking: False. Caching: False. | |
-------------------------------------------------------------------------------------------- | |
Starting bench runs... | |
Set fetches | |
------------------------- | |
[13:33:05] # of elements fetched: 31465. Fetch took: 136.79ms. Allocated bytes: 15557832. | |
Single element fetches | |
------------------------- | |
[13:33:05] # of elements fetched individually: 100. Total time: 30.74ms. Allocated bytes per element: 40960. | |
LLBLGen Pro async v5.5.0.0 (v5.5.0), Poco with Raw SQL. Change tracking: False. Caching: False. | |
-------------------------------------------------------------------------------------------- | |
Starting bench runs... | |
Set fetches | |
------------------------- | |
[13:33:05] # of elements fetched: 31465. Fetch took: 146.20ms. Allocated bytes: 15550320. | |
Single element fetches | |
------------------------- | |
[13:33:05] # of elements fetched individually: 100. Total time: 34.77ms. Allocated bytes per element: 32768. | |
Dapper async v1.50.5.0. Change tracking: False. Caching: False. | |
-------------------------------------------------------------------------------------------- | |
Starting bench runs... | |
Set fetches | |
------------------------- | |
[13:33:05] # of elements fetched: 31465. Fetch took: 162.22ms. Allocated bytes: 33169824. | |
Single element fetches | |
------------------------- | |
[13:33:05] # of elements fetched individually: 100. Total time: 31.00ms. Allocated bytes per element: 40960. | |
NPoco async v3.9.4.0 (v3.9.4.0). Change tracking: False. Caching: False. | |
-------------------------------------------------------------------------------------------- | |
Starting bench runs... | |
Set fetches | |
------------------------- | |
[13:33:06] # of elements fetched: 31465. Fetch took: 159.57ms. Allocated bytes: 42018008. | |
Single element fetches | |
------------------------- | |
[13:33:06] # of elements fetched individually: 100. Total time: 92.38ms. Allocated bytes per element: 180224. | |
ServiceStack OrmLite async v5.0.0.0 (v5.4.0.0). Change tracking: False. Caching: False. | |
-------------------------------------------------------------------------------------------- | |
Starting bench runs... | |
Set fetches | |
------------------------- | |
[13:33:06] # of elements fetched: 31465. Fetch took: 338.38ms. Allocated bytes: 85240632. | |
Single element fetches | |
------------------------- | |
[13:33:06] # of elements fetched individually: 100. Total time: 31.75ms. Allocated bytes per element: 57344. | |
EF Core async v2.2.1.0 (v2.2.1.18346). Change tracking: False. Caching: False. | |
-------------------------------------------------------------------------------------------- | |
Starting bench runs... | |
Set fetches | |
------------------------- | |
[13:33:06] # of elements fetched: 31465. Fetch took: 331.17ms. Allocated bytes: 75888608. | |
Single element fetches | |
------------------------- | |
[13:33:06] # of elements fetched individually: 100. Total time: 60.37ms. Allocated bytes per element: 106496. | |
Results per framework. Values are given as: 'mean (standard deviation)' | |
============================================================================== | |
Non-change tracking fetches, set fetches (25 runs), no caching | |
------------------------------------------------------------------------------ | |
Handcoded async [GetValues(array), boxing] : 120.92ms (1.46ms) Enum: 1.09ms (0.08ms) | |
TinyORM 1-stage async v1.2.6950.23811 : 132.90ms (1.99ms) Enum: 1.13ms (0.16ms) | |
RepoDb (RawSql) async v1.7.0.5 : 132.99ms (2.26ms) Enum: 1.06ms (0.09ms) | |
TinyORM 2-stage async v1.2.6950.23811 : 144.70ms (2.87ms) Enum: 0.74ms (0.07ms) | |
LLBLGen Pro async v5.5.0.0 (v5.5.0), Poco with Raw SQL : 144.90ms (2.09ms) Enum: 1.14ms (0.11ms) | |
NPoco async v3.9.4.0 (v3.9.4.0) : 158.27ms (5.22ms) Enum: 1.82ms (0.83ms) | |
Dapper async v1.50.5.0 : 161.22ms (4.07ms) Enum: 1.22ms (0.16ms) | |
ServiceStack OrmLite async v5.0.0.0 (v5.4.0.0) : 331.49ms (10.85ms) Enum: 1.21ms (0.20ms) | |
EF Core async v2.2.1.0 (v2.2.1.18346) : 334.40ms (4.02ms) Enum: 1.21ms (0.12ms) | |
Memory usage, per iteration | |
------------------------------------------------------------------------------ | |
LLBLGen Pro async v5.5.0.0 (v5.5.0), Poco with Raw SQL : 15,185 KB (15,550,320 bytes) | |
RepoDb (RawSql) async v1.7.0.5 : 15,193 KB (15,557,832 bytes) | |
Handcoded async [GetValues(array), boxing] : 30,816 KB (31,556,336 bytes) | |
TinyORM 1-stage async v1.2.6950.23811 : 30,827 KB (31,567,776 bytes) | |
Dapper async v1.50.5.0 : 32,392 KB (33,169,824 bytes) | |
TinyORM 2-stage async v1.2.6950.23811 : 38,565 KB (39,491,512 bytes) | |
NPoco async v3.9.4.0 (v3.9.4.0) : 41,033 KB (42,018,008 bytes) | |
EF Core async v2.2.1.0 (v2.2.1.18346) : 74,109 KB (75,888,608 bytes) | |
ServiceStack OrmLite async v5.0.0.0 (v5.4.0.0) : 83,242 KB (85,240,632 bytes) | |
Non-change tracking individual fetches (100 elements, 25 runs), no caching | |
------------------------------------------------------------------------------ | |
TinyORM 1-stage async v1.2.6950.23811 : 0.24ms (0.00ms) per individual fetch | |
TinyORM 2-stage async v1.2.6950.23811 : 0.25ms (0.00ms) per individual fetch | |
Handcoded async [GetValues(array), boxing] : 0.26ms (0.01ms) per individual fetch | |
Dapper async v1.50.5.0 : 0.27ms (0.01ms) per individual fetch | |
RepoDb (RawSql) async v1.7.0.5 : 0.27ms (0.01ms) per individual fetch | |
LLBLGen Pro async v5.5.0.0 (v5.5.0), Poco with Raw SQL : 0.29ms (0.01ms) per individual fetch | |
ServiceStack OrmLite async v5.0.0.0 (v5.4.0.0) : 0.30ms (0.01ms) per individual fetch | |
EF Core async v2.2.1.0 (v2.2.1.18346) : 0.57ms (0.02ms) per individual fetch | |
NPoco async v3.9.4.0 (v3.9.4.0) : 0.78ms (0.03ms) per individual fetch | |
Memory usage, per individual element | |
------------------------------------------------------------------------------ | |
Handcoded async [GetValues(array), boxing] : 32 KB (32,768 bytes) | |
LLBLGen Pro async v5.5.0.0 (v5.5.0), Poco with Raw SQL : 32 KB (32,768 bytes) | |
Dapper async v1.50.5.0 : 40 KB (40,960 bytes) | |
RepoDb (RawSql) async v1.7.0.5 : 40 KB (40,960 bytes) | |
ServiceStack OrmLite async v5.0.0.0 (v5.4.0.0) : 56 KB (57,344 bytes) | |
TinyORM 1-stage async v1.2.6950.23811 : 56 KB (57,392 bytes) | |
TinyORM 2-stage async v1.2.6950.23811 : 56 KB (57,392 bytes) | |
EF Core async v2.2.1.0 (v2.2.1.18346) : 104 KB (106,496 bytes) | |
NPoco async v3.9.4.0 (v3.9.4.0) : 176 KB (180,224 bytes) | |
Complete. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment