Skip to content

Instantly share code, notes, and snippets.

@sdrapkin
Created January 11, 2019 18:48
Show Gist options
  • Save sdrapkin/c2d310e0f42b18d8f2beae789294faa8 to your computer and use it in GitHub Desktop.
Save sdrapkin/c2d310e0f42b18d8f2beae789294faa8 to your computer and use it in GitHub Desktop.
TinyORM benchmark January-11-2019
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