Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
1768 lines (1550 sloc) 114 KB
+-------------------------------------------------------------------------------------------
| Raw Data Access / ORM Benchmarks.
| Code available at : https://github.com/FransBouma/RawDataAccessBencher
| Benchmarks run on : Friday, November 15, 2019 9:14:52 PM
| Registered benchmarks :
| Handcoded materializer using DbDataReader. Change tracking: False. Caching: False.
| Handcoded materializer using DbDataReader and GetFieldValue<T>. Change tracking: False. Caching: False.
| RepoDb (RawSql) v1.9.5.0. Change tracking: False. Caching: False.
| RepoDb (Poco) v1.9.5.0. Change tracking: False. Caching: False.
| Handcoded materializer using DbDataReader (GetValues(array), boxing). Change tracking: False. Caching: False.
| Handcoded materializer using DbDataReader (GetValue(Ordinal), boxing). Change tracking: False. Caching: False.
| Raw DbDataReader materializer using object arrays. Change tracking: False. Caching: False.
| Entity Framework Core v2.2.6.0 (v2.2.6.19169). Change tracking: False. Caching: False.
| Entity Framework Core v2.2.6.0 (v2.2.6.19169). Change tracking: True. Caching: False.
| Entity Framework Core v2.2.6.0 (v2.2.6.19169) Poco DTO Graph. Change tracking: False. Caching: False.
| NPoco v4.0.1.0 (v4.0.1.0). Change tracking: False. Caching: False.
| LINQ to DB v2.7.4.0 (v2.7.4) (compiled). Change tracking: False. Caching: False.
| LINQ to DB v2.7.4.0 (v2.7.4) (normal). Change tracking: False. Caching: False.
| Jerrycurl v1.0.0.0. Change tracking: False. Caching: False.
| LLBLGen Pro v5.6.0.0 (v5.6.0), Poco with Raw SQL. Change tracking: False. Caching: False.
| LLBLGen Pro v5.6.0.0 (v5.6.0), Poco typed view with QuerySpec. Change tracking: False. Caching: False.
| LLBLGen Pro v5.6.0.0 (v5.6.0), Poco typed view with Linq. Change tracking: False. Caching: False.
| LLBLGen Pro v5.6.0.0 (v5.6.0), DataTable based TypedView. Change tracking: False. Caching: False.
| LLBLGen Pro v5.6.0.0 (v5.6.0). Change tracking: True. Caching: True.
| LLBLGen Pro v5.6.0.0 (v5.6.0). Change tracking: True. Caching: False.
| LLBLGen Pro v5.6.0.0 (v5.6.0), Poco DTO graph. Change tracking: False. Caching: False.
| Dapper v1.60.0.0. Change tracking: False. Caching: False.
| Tortuga Chain v2.1.0.0. Change tracking: False. Caching: False.
| ServiceStack OrmLite v5.0.0.0 (v5.5.0.0). Change tracking: False. Caching: False.
| DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
| Tortuga Chain, Compiled v2.1.0.0. Change tracking: False. Caching: False.
| Run set benchmarks : True
| Run individual fetch benchmarks: True
| Number of set fetches : 10
| Number of individual keys : 100
| Release build : True
| Client OS : Microsoft Windows NT 10.0.18362.0 (64bit)
| Bencher runs as 64bit : True
| .NET Type : .NET Core
| CLR version : .NETCoreApp 2.2
| Number of CPUs : 4
| Server used : .
| Catalog used : AdventureWorks
| SQL Server version used : 14.00.1000
+-------------------------------------------------------------------------------------------
Warming up DB, DB client code and CLR
====================================================================
DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
--------------------------------------------------------------------------------------------
[21:14:52] # of elements fetched: 31465. Fetch took: 280.45ms. Enumerating result took: 30.04ms.
[21:14:52] # of elements fetched: 31465. Fetch took: 221.58ms. Enumerating result took: 29.01ms.
[21:14:53] # of elements fetched: 31465. Fetch took: 235.99ms. Enumerating result took: 28.99ms.
[21:14:53] # of elements fetched: 31465. Fetch took: 217.57ms. Enumerating result took: 28.48ms.
[21:14:53] # of elements fetched: 31465. Fetch took: 205.65ms. Enumerating result took: 45.79ms.
[21:14:53] # of elements fetched: 31465. Fetch took: 210.79ms. Enumerating result took: 28.60ms.
[21:14:54] # of elements fetched: 31465. Fetch took: 210.03ms. Enumerating result took: 28.41ms.
[21:14:54] # of elements fetched: 31465. Fetch took: 207.25ms. Enumerating result took: 27.88ms.
[21:14:54] # of elements fetched: 31465. Fetch took: 215.81ms. Enumerating result took: 28.33ms.
[21:14:54] # of elements fetched: 31465. Fetch took: 230.56ms. Enumerating result took: 28.35ms.
Starting benchmarks.
====================================================================
Handcoded materializer using DbDataReader. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:14:55] # of elements fetched: 31465. Fetch took: 122.10ms. Enumerating result took: 1.37ms.
[21:14:55] # of elements fetched individually: 100. Total time: 61.16ms. Time per element: 0.61ms
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:14:55] # of elements fetched: 31465. Fetch took: 115.97ms. Enumerating result took: 0.92ms.
[21:14:55] # of elements fetched: 31465. Fetch took: 115.15ms. Enumerating result took: 0.91ms.
[21:14:55] # of elements fetched: 31465. Fetch took: 114.01ms. Enumerating result took: 0.92ms.
[21:14:55] # of elements fetched: 31465. Fetch took: 118.23ms. Enumerating result took: 1.25ms.
[21:14:55] # of elements fetched: 31465. Fetch took: 115.17ms. Enumerating result took: 0.91ms.
[21:14:55] # of elements fetched: 31465. Fetch took: 112.70ms. Enumerating result took: 1.00ms.
[21:14:55] # of elements fetched: 31465. Fetch took: 114.45ms. Enumerating result took: 0.98ms.
[21:14:56] # of elements fetched: 31465. Fetch took: 114.46ms. Enumerating result took: 1.09ms.
[21:14:56] # of elements fetched: 31465. Fetch took: 116.84ms. Enumerating result took: 0.89ms.
[21:14:56] # of elements fetched: 31465. Fetch took: 112.95ms. Enumerating result took: 0.96ms.
Single element fetches
-------------------------
[21:14:56] # of elements fetched individually: 100. Total time: 16.22ms. Time per element: 0.16ms
[21:14:56] # of elements fetched individually: 100. Total time: 14.03ms. Time per element: 0.14ms
[21:14:56] # of elements fetched individually: 100. Total time: 13.35ms. Time per element: 0.13ms
[21:14:56] # of elements fetched individually: 100. Total time: 14.33ms. Time per element: 0.14ms
[21:14:56] # of elements fetched individually: 100. Total time: 13.52ms. Time per element: 0.14ms
[21:14:56] # of elements fetched individually: 100. Total time: 15.00ms. Time per element: 0.15ms
[21:14:56] # of elements fetched individually: 100. Total time: 13.98ms. Time per element: 0.14ms
[21:14:56] # of elements fetched individually: 100. Total time: 13.85ms. Time per element: 0.14ms
[21:14:56] # of elements fetched individually: 100. Total time: 14.37ms. Time per element: 0.14ms
[21:14:56] # of elements fetched individually: 100. Total time: 13.50ms. Time per element: 0.13ms
Handcoded materializer using DbDataReader and GetFieldValue<T>. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:14:56] # of elements fetched: 31465. Fetch took: 181.41ms. Enumerating result took: 1.55ms.
[21:14:56] # of elements fetched individually: 100. Total time: 17.27ms. Time per element: 0.17ms
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:14:56] # of elements fetched: 31465. Fetch took: 157.90ms. Enumerating result took: 1.05ms.
[21:14:57] # of elements fetched: 31465. Fetch took: 159.67ms. Enumerating result took: 1.12ms.
[21:14:57] # of elements fetched: 31465. Fetch took: 162.16ms. Enumerating result took: 1.17ms.
[21:14:57] # of elements fetched: 31465. Fetch took: 160.08ms. Enumerating result took: 1.02ms.
[21:14:57] # of elements fetched: 31465. Fetch took: 162.91ms. Enumerating result took: 1.14ms.
[21:14:57] # of elements fetched: 31465. Fetch took: 161.25ms. Enumerating result took: 1.08ms.
[21:14:57] # of elements fetched: 31465. Fetch took: 158.29ms. Enumerating result took: 1.06ms.
[21:14:58] # of elements fetched: 31465. Fetch took: 161.89ms. Enumerating result took: 1.07ms.
[21:14:58] # of elements fetched: 31465. Fetch took: 161.34ms. Enumerating result took: 1.03ms.
[21:14:58] # of elements fetched: 31465. Fetch took: 161.22ms. Enumerating result took: 1.02ms.
Single element fetches
-------------------------
[21:14:58] # of elements fetched individually: 100. Total time: 16.80ms. Time per element: 0.17ms
[21:14:58] # of elements fetched individually: 100. Total time: 13.88ms. Time per element: 0.14ms
[21:14:58] # of elements fetched individually: 100. Total time: 13.99ms. Time per element: 0.14ms
[21:14:58] # of elements fetched individually: 100. Total time: 14.44ms. Time per element: 0.14ms
[21:14:58] # of elements fetched individually: 100. Total time: 14.00ms. Time per element: 0.14ms
[21:14:58] # of elements fetched individually: 100. Total time: 13.74ms. Time per element: 0.14ms
[21:14:58] # of elements fetched individually: 100. Total time: 14.87ms. Time per element: 0.15ms
[21:14:58] # of elements fetched individually: 100. Total time: 14.07ms. Time per element: 0.14ms
[21:14:58] # of elements fetched individually: 100. Total time: 13.90ms. Time per element: 0.14ms
[21:14:58] # of elements fetched individually: 100. Total time: 13.85ms. Time per element: 0.14ms
RepoDb (RawSql) v1.9.5.0. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:15:00] # of elements fetched: 31465. Fetch took: 2,008.49ms. Enumerating result took: 1.02ms.
[21:15:00] # of elements fetched individually: 100. Total time: 19.68ms. Time per element: 0.20ms
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:15:00] # of elements fetched: 31465. Fetch took: 118.53ms. Enumerating result took: 0.94ms.
[21:15:00] # of elements fetched: 31465. Fetch took: 119.70ms. Enumerating result took: 0.94ms.
[21:15:00] # of elements fetched: 31465. Fetch took: 116.06ms. Enumerating result took: 0.93ms.
[21:15:01] # of elements fetched: 31465. Fetch took: 117.07ms. Enumerating result took: 0.93ms.
[21:15:01] # of elements fetched: 31465. Fetch took: 120.91ms. Enumerating result took: 0.93ms.
[21:15:01] # of elements fetched: 31465. Fetch took: 118.47ms. Enumerating result took: 0.92ms.
[21:15:01] # of elements fetched: 31465. Fetch took: 119.80ms. Enumerating result took: 0.97ms.
[21:15:01] # of elements fetched: 31465. Fetch took: 118.07ms. Enumerating result took: 0.93ms.
[21:15:01] # of elements fetched: 31465. Fetch took: 121.51ms. Enumerating result took: 0.99ms.
[21:15:01] # of elements fetched: 31465. Fetch took: 136.46ms. Enumerating result took: 1.13ms.
Single element fetches
-------------------------
[21:15:01] # of elements fetched individually: 100. Total time: 17.68ms. Time per element: 0.18ms
[21:15:01] # of elements fetched individually: 100. Total time: 15.98ms. Time per element: 0.16ms
[21:15:01] # of elements fetched individually: 100. Total time: 16.00ms. Time per element: 0.16ms
[21:15:01] # of elements fetched individually: 100. Total time: 17.08ms. Time per element: 0.17ms
[21:15:01] # of elements fetched individually: 100. Total time: 15.86ms. Time per element: 0.16ms
[21:15:01] # of elements fetched individually: 100. Total time: 15.04ms. Time per element: 0.15ms
[21:15:01] # of elements fetched individually: 100. Total time: 15.10ms. Time per element: 0.15ms
[21:15:01] # of elements fetched individually: 100. Total time: 15.33ms. Time per element: 0.15ms
[21:15:01] # of elements fetched individually: 100. Total time: 14.78ms. Time per element: 0.15ms
[21:15:01] # of elements fetched individually: 100. Total time: 15.76ms. Time per element: 0.16ms
RepoDb (Poco) v1.9.5.0. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:15:05] # of elements fetched: 31465. Fetch took: 3,415.41ms. Enumerating result took: 1.07ms.
[21:15:07] # of elements fetched individually: 100. Total time: 1,791.11ms. Time per element: 17.91ms
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:15:07] # of elements fetched: 31465. Fetch took: 129.35ms. Enumerating result took: 0.91ms.
[21:15:07] # of elements fetched: 31465. Fetch took: 122.80ms. Enumerating result took: 0.98ms.
[21:15:07] # of elements fetched: 31465. Fetch took: 125.05ms. Enumerating result took: 0.90ms.
[21:15:07] # of elements fetched: 31465. Fetch took: 125.11ms. Enumerating result took: 1.00ms.
[21:15:07] # of elements fetched: 31465. Fetch took: 119.92ms. Enumerating result took: 0.91ms.
[21:15:07] # of elements fetched: 31465. Fetch took: 125.02ms. Enumerating result took: 1.00ms.
[21:15:08] # of elements fetched: 31465. Fetch took: 125.14ms. Enumerating result took: 0.91ms.
[21:15:08] # of elements fetched: 31465. Fetch took: 124.60ms. Enumerating result took: 1.25ms.
[21:15:08] # of elements fetched: 31465. Fetch took: 123.66ms. Enumerating result took: 0.95ms.
[21:15:08] # of elements fetched: 31465. Fetch took: 122.68ms. Enumerating result took: 0.92ms.
Single element fetches
-------------------------
[21:15:08] # of elements fetched individually: 100. Total time: 20.23ms. Time per element: 0.20ms
[21:15:08] # of elements fetched individually: 100. Total time: 19.56ms. Time per element: 0.20ms
[21:15:08] # of elements fetched individually: 100. Total time: 19.96ms. Time per element: 0.20ms
[21:15:08] # of elements fetched individually: 100. Total time: 19.50ms. Time per element: 0.19ms
[21:15:08] # of elements fetched individually: 100. Total time: 19.49ms. Time per element: 0.19ms
[21:15:08] # of elements fetched individually: 100. Total time: 25.27ms. Time per element: 0.25ms
[21:15:08] # of elements fetched individually: 100. Total time: 22.25ms. Time per element: 0.22ms
[21:15:08] # of elements fetched individually: 100. Total time: 21.86ms. Time per element: 0.22ms
[21:15:08] # of elements fetched individually: 100. Total time: 21.79ms. Time per element: 0.22ms
[21:15:08] # of elements fetched individually: 100. Total time: 19.95ms. Time per element: 0.20ms
Handcoded materializer using DbDataReader (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.
[21:15:08] # of elements fetched: 31465. Fetch took: 138.58ms. Enumerating result took: 1.25ms.
[21:15:08] # of elements fetched individually: 100. Total time: 24.20ms. Time per element: 0.24ms
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:15:09] # of elements fetched: 31465. Fetch took: 131.57ms. Enumerating result took: 1.10ms.
[21:15:09] # of elements fetched: 31465. Fetch took: 133.29ms. Enumerating result took: 1.07ms.
[21:15:09] # of elements fetched: 31465. Fetch took: 130.58ms. Enumerating result took: 1.22ms.
[21:15:09] # of elements fetched: 31465. Fetch took: 129.96ms. Enumerating result took: 1.09ms.
[21:15:09] # of elements fetched: 31465. Fetch took: 132.81ms. Enumerating result took: 1.09ms.
[21:15:09] # of elements fetched: 31465. Fetch took: 127.05ms. Enumerating result took: 1.21ms.
[21:15:09] # of elements fetched: 31465. Fetch took: 130.50ms. Enumerating result took: 1.38ms.
[21:15:09] # of elements fetched: 31465. Fetch took: 132.69ms. Enumerating result took: 1.19ms.
[21:15:10] # of elements fetched: 31465. Fetch took: 129.60ms. Enumerating result took: 1.10ms.
[21:15:10] # of elements fetched: 31465. Fetch took: 134.80ms. Enumerating result took: 1.21ms.
Single element fetches
-------------------------
[21:15:10] # of elements fetched individually: 100. Total time: 17.74ms. Time per element: 0.18ms
[21:15:10] # of elements fetched individually: 100. Total time: 13.69ms. Time per element: 0.14ms
[21:15:10] # of elements fetched individually: 100. Total time: 13.72ms. Time per element: 0.14ms
[21:15:10] # of elements fetched individually: 100. Total time: 14.57ms. Time per element: 0.15ms
[21:15:10] # of elements fetched individually: 100. Total time: 16.17ms. Time per element: 0.16ms
[21:15:10] # of elements fetched individually: 100. Total time: 15.65ms. Time per element: 0.16ms
[21:15:10] # of elements fetched individually: 100. Total time: 18.14ms. Time per element: 0.18ms
[21:15:10] # of elements fetched individually: 100. Total time: 27.00ms. Time per element: 0.27ms
[21:15:10] # of elements fetched individually: 100. Total time: 33.61ms. Time per element: 0.34ms
[21:15:10] # of elements fetched individually: 100. Total time: 48.42ms. Time per element: 0.48ms
Handcoded materializer using DbDataReader (GetValue(Ordinal), boxing). Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:15:10] # of elements fetched: 31465. Fetch took: 155.53ms. Enumerating result took: 1.56ms.
[21:15:10] # of elements fetched individually: 100. Total time: 53.03ms. Time per element: 0.53ms
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:15:10] # of elements fetched: 31465. Fetch took: 154.51ms. Enumerating result took: 1.41ms.
[21:15:11] # of elements fetched: 31465. Fetch took: 157.51ms. Enumerating result took: 1.17ms.
[21:15:11] # of elements fetched: 31465. Fetch took: 146.15ms. Enumerating result took: 1.11ms.
[21:15:11] # of elements fetched: 31465. Fetch took: 150.67ms. Enumerating result took: 1.42ms.
[21:15:11] # of elements fetched: 31465. Fetch took: 153.27ms. Enumerating result took: 1.41ms.
[21:15:11] # of elements fetched: 31465. Fetch took: 152.76ms. Enumerating result took: 1.12ms.
[21:15:11] # of elements fetched: 31465. Fetch took: 148.98ms. Enumerating result took: 1.39ms.
[21:15:11] # of elements fetched: 31465. Fetch took: 150.42ms. Enumerating result took: 1.71ms.
[21:15:12] # of elements fetched: 31465. Fetch took: 157.62ms. Enumerating result took: 1.10ms.
[21:15:12] # of elements fetched: 31465. Fetch took: 137.48ms. Enumerating result took: 1.84ms.
Single element fetches
-------------------------
[21:15:12] # of elements fetched individually: 100. Total time: 38.86ms. Time per element: 0.39ms
[21:15:12] # of elements fetched individually: 100. Total time: 37.06ms. Time per element: 0.37ms
[21:15:12] # of elements fetched individually: 100. Total time: 40.49ms. Time per element: 0.40ms
[21:15:12] # of elements fetched individually: 100. Total time: 35.63ms. Time per element: 0.36ms
[21:15:12] # of elements fetched individually: 100. Total time: 13.82ms. Time per element: 0.14ms
[21:15:12] # of elements fetched individually: 100. Total time: 13.16ms. Time per element: 0.13ms
[21:15:12] # of elements fetched individually: 100. Total time: 13.04ms. Time per element: 0.13ms
[21:15:12] # of elements fetched individually: 100. Total time: 13.29ms. Time per element: 0.13ms
[21:15:12] # of elements fetched individually: 100. Total time: 13.97ms. Time per element: 0.14ms
[21:15:12] # of elements fetched individually: 100. Total time: 42.43ms. Time per element: 0.42ms
Raw DbDataReader materializer using object arrays. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:15:12] # of elements fetched: 31465. Fetch took: 154.19ms. Enumerating result took: 1.96ms.
[21:15:12] # of elements fetched individually: 100. Total time: 41.20ms. Time per element: 0.41ms
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:15:12] # of elements fetched: 31465. Fetch took: 147.62ms. Enumerating result took: 2.43ms.
[21:15:13] # of elements fetched: 31465. Fetch took: 144.31ms. Enumerating result took: 2.32ms.
[21:15:13] # of elements fetched: 31465. Fetch took: 151.85ms. Enumerating result took: 1.84ms.
[21:15:13] # of elements fetched: 31465. Fetch took: 148.27ms. Enumerating result took: 2.17ms.
[21:15:13] # of elements fetched: 31465. Fetch took: 141.86ms. Enumerating result took: 2.02ms.
[21:15:13] # of elements fetched: 31465. Fetch took: 154.19ms. Enumerating result took: 1.72ms.
[21:15:13] # of elements fetched: 31465. Fetch took: 221.71ms. Enumerating result took: 4.03ms.
[21:15:14] # of elements fetched: 31465. Fetch took: 196.85ms. Enumerating result took: 2.20ms.
[21:15:14] # of elements fetched: 31465. Fetch took: 150.03ms. Enumerating result took: 1.70ms.
[21:15:14] # of elements fetched: 31465. Fetch took: 153.68ms. Enumerating result took: 2.38ms.
Single element fetches
-------------------------
[21:15:14] # of elements fetched individually: 100. Total time: 60.96ms. Time per element: 0.61ms
[21:15:14] # of elements fetched individually: 100. Total time: 21.89ms. Time per element: 0.22ms
[21:15:14] # of elements fetched individually: 100. Total time: 21.68ms. Time per element: 0.22ms
[21:15:14] # of elements fetched individually: 100. Total time: 24.13ms. Time per element: 0.24ms
[21:15:14] # of elements fetched individually: 100. Total time: 86.24ms. Time per element: 0.86ms
[21:15:14] # of elements fetched individually: 100. Total time: 74.49ms. Time per element: 0.74ms
[21:15:14] # of elements fetched individually: 100. Total time: 23.11ms. Time per element: 0.23ms
[21:15:14] # of elements fetched individually: 100. Total time: 21.70ms. Time per element: 0.22ms
[21:15:14] # of elements fetched individually: 100. Total time: 23.32ms. Time per element: 0.23ms
[21:15:14] # of elements fetched individually: 100. Total time: 48.51ms. Time per element: 0.49ms
Entity Framework Core v2.2.6.0 (v2.2.6.19169). Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:15:16] # of elements fetched: 31465. Fetch took: 1,919.02ms. Enumerating result took: 0.97ms.
[21:15:16] # of elements fetched individually: 100. Total time: 173.93ms. Time per element: 1.74ms
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:15:17] # of elements fetched: 31465. Fetch took: 127.48ms. Enumerating result took: 1.00ms.
[21:15:17] # of elements fetched: 31465. Fetch took: 140.45ms. Enumerating result took: 0.96ms.
[21:15:17] # of elements fetched: 31465. Fetch took: 163.13ms. Enumerating result took: 1.28ms.
[21:15:17] # of elements fetched: 31465. Fetch took: 126.31ms. Enumerating result took: 0.92ms.
[21:15:17] # of elements fetched: 31465. Fetch took: 131.34ms. Enumerating result took: 0.95ms.
[21:15:17] # of elements fetched: 31465. Fetch took: 139.12ms. Enumerating result took: 1.13ms.
[21:15:18] # of elements fetched: 31465. Fetch took: 136.45ms. Enumerating result took: 1.13ms.
[21:15:18] # of elements fetched: 31465. Fetch took: 141.73ms. Enumerating result took: 0.87ms.
[21:15:18] # of elements fetched: 31465. Fetch took: 130.42ms. Enumerating result took: 0.87ms.
[21:15:18] # of elements fetched: 31465. Fetch took: 128.32ms. Enumerating result took: 0.88ms.
Single element fetches
-------------------------
[21:15:18] # of elements fetched individually: 100. Total time: 41.58ms. Time per element: 0.42ms
[21:15:18] # of elements fetched individually: 100. Total time: 34.98ms. Time per element: 0.35ms
[21:15:18] # of elements fetched individually: 100. Total time: 34.36ms. Time per element: 0.34ms
[21:15:18] # of elements fetched individually: 100. Total time: 35.89ms. Time per element: 0.36ms
[21:15:18] # of elements fetched individually: 100. Total time: 37.46ms. Time per element: 0.37ms
[21:15:18] # of elements fetched individually: 100. Total time: 35.73ms. Time per element: 0.36ms
[21:15:18] # of elements fetched individually: 100. Total time: 35.83ms. Time per element: 0.36ms
[21:15:18] # of elements fetched individually: 100. Total time: 36.42ms. Time per element: 0.36ms
[21:15:18] # of elements fetched individually: 100. Total time: 35.49ms. Time per element: 0.35ms
[21:15:18] # of elements fetched individually: 100. Total time: 36.22ms. Time per element: 0.36ms
Entity Framework Core v2.2.6.0 (v2.2.6.19169). Change tracking: True. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:15:19] # of elements fetched: 31465. Fetch took: 464.96ms. Enumerating result took: 1.46ms.
[21:15:19] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 411.62ms.
[21:15:20] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 322.55ms.
[21:15:20] # of elements fetched individually: 100. Total time: 61.42ms. Time per element: 0.61ms
[21:15:20] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 351.59ms.
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:15:20] # of elements fetched: 31465. Fetch took: 366.04ms. Enumerating result took: 1.38ms.
[21:15:21] # of elements fetched: 31465. Fetch took: 383.84ms. Enumerating result took: 1.74ms.
[21:15:21] # of elements fetched: 31465. Fetch took: 407.82ms. Enumerating result took: 1.43ms.
[21:15:22] # of elements fetched: 31465. Fetch took: 373.05ms. Enumerating result took: 1.30ms.
[21:15:22] # of elements fetched: 31465. Fetch took: 408.86ms. Enumerating result took: 1.42ms.
[21:15:23] # of elements fetched: 31465. Fetch took: 422.43ms. Enumerating result took: 1.34ms.
[21:15:23] # of elements fetched: 31465. Fetch took: 393.25ms. Enumerating result took: 1.73ms.
[21:15:23] # of elements fetched: 31465. Fetch took: 389.57ms. Enumerating result took: 2.73ms.
[21:15:24] # of elements fetched: 31465. Fetch took: 415.53ms. Enumerating result took: 1.44ms.
[21:15:24] # of elements fetched: 31465. Fetch took: 377.88ms. Enumerating result took: 2.11ms.
Single element fetches
-------------------------
[21:15:24] # of elements fetched individually: 100. Total time: 56.03ms. Time per element: 0.56ms
[21:15:24] # of elements fetched individually: 100. Total time: 53.69ms. Time per element: 0.54ms
[21:15:24] # of elements fetched individually: 100. Total time: 50.88ms. Time per element: 0.51ms
[21:15:25] # of elements fetched individually: 100. Total time: 42.34ms. Time per element: 0.42ms
[21:15:25] # of elements fetched individually: 100. Total time: 38.21ms. Time per element: 0.38ms
[21:15:25] # of elements fetched individually: 100. Total time: 69.96ms. Time per element: 0.70ms
[21:15:25] # of elements fetched individually: 100. Total time: 67.17ms. Time per element: 0.67ms
[21:15:25] # of elements fetched individually: 100. Total time: 53.21ms. Time per element: 0.53ms
[21:15:25] # of elements fetched individually: 100. Total time: 60.88ms. Time per element: 0.61ms
[21:15:25] # of elements fetched individually: 100. Total time: 61.92ms. Time per element: 0.62ms
Eager Load fetches
-------------------------
[21:15:25] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 103.16ms.
[21:15:25] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 103.28ms.
[21:15:25] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 100.11ms.
[21:15:25] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 98.33ms.
[21:15:25] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 89.46ms.
[21:15:26] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 97.99ms.
[21:15:26] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 100.51ms.
[21:15:26] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 93.07ms.
[21:15:26] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 91.62ms.
[21:15:26] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 89.65ms.
Async eager Load fetches
-------------------------
[21:15:26] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 117.06ms.
[21:15:26] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 118.76ms.
[21:15:26] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 116.16ms.
[21:15:27] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 118.47ms.
[21:15:27] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 120.70ms.
[21:15:27] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 118.76ms.
[21:15:27] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 117.34ms.
[21:15:27] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 117.65ms.
[21:15:27] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 117.10ms.
[21:15:27] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 118.63ms.
Set Inserts
-------------------------
[21:15:28] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 125.14ms.
[21:15:28] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 122.49ms.
[21:15:28] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 126.59ms.
[21:15:28] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 124.89ms.
[21:15:28] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 124.87ms.
[21:15:28] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 124.10ms.
[21:15:28] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 123.05ms.
[21:15:29] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 120.42ms.
[21:15:29] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 126.51ms.
[21:15:29] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 228.14ms.
Entity Framework Core v2.2.6.0 (v2.2.6.19169) Poco DTO Graph. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:15:29] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 143.39ms.
[21:15:29] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 97.62ms.
Doing a GC collect...
Done.
Starting bench runs...
Eager Load fetches
-------------------------
[21:15:29] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 32.75ms.
[21:15:29] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 33.23ms.
[21:15:29] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 33.79ms.
[21:15:30] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 33.17ms.
[21:15:30] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 33.16ms.
[21:15:30] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 33.48ms.
[21:15:30] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 31.96ms.
[21:15:30] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 32.78ms.
[21:15:30] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 34.56ms.
[21:15:30] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 33.07ms.
Async eager Load fetches
-------------------------
[21:15:30] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 52.00ms.
[21:15:30] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 50.14ms.
[21:15:30] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 51.83ms.
[21:15:30] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 50.96ms.
[21:15:30] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 50.07ms.
[21:15:30] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 51.70ms.
[21:15:30] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 51.49ms.
[21:15:30] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 51.61ms.
[21:15:30] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 50.46ms.
[21:15:30] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 51.83ms.
NPoco v4.0.1.0 (v4.0.1.0). Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:15:31] # of elements fetched: 31465. Fetch took: 254.48ms. Enumerating result took: 1.29ms.
[21:15:31] # of elements fetched individually: 100. Total time: 89.50ms. Time per element: 0.89ms
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:15:31] # of elements fetched: 31465. Fetch took: 171.48ms. Enumerating result took: 1.26ms.
[21:15:31] # of elements fetched: 31465. Fetch took: 173.10ms. Enumerating result took: 1.09ms.
[21:15:31] # of elements fetched: 31465. Fetch took: 172.08ms. Enumerating result took: 1.02ms.
[21:15:31] # of elements fetched: 31465. Fetch took: 164.81ms. Enumerating result took: 1.12ms.
[21:15:32] # of elements fetched: 31465. Fetch took: 162.34ms. Enumerating result took: 2.03ms.
[21:15:32] # of elements fetched: 31465. Fetch took: 167.13ms. Enumerating result took: 1.06ms.
[21:15:32] # of elements fetched: 31465. Fetch took: 169.64ms. Enumerating result took: 1.00ms.
[21:15:32] # of elements fetched: 31465. Fetch took: 172.27ms. Enumerating result took: 1.35ms.
[21:15:32] # of elements fetched: 31465. Fetch took: 168.92ms. Enumerating result took: 1.08ms.
[21:15:33] # of elements fetched: 31465. Fetch took: 166.76ms. Enumerating result took: 1.09ms.
Single element fetches
-------------------------
[21:15:33] # of elements fetched individually: 100. Total time: 65.39ms. Time per element: 0.65ms
[21:15:33] # of elements fetched individually: 100. Total time: 59.29ms. Time per element: 0.59ms
[21:15:33] # of elements fetched individually: 100. Total time: 59.24ms. Time per element: 0.59ms
[21:15:33] # of elements fetched individually: 100. Total time: 60.07ms. Time per element: 0.60ms
[21:15:33] # of elements fetched individually: 100. Total time: 59.17ms. Time per element: 0.59ms
[21:15:33] # of elements fetched individually: 100. Total time: 60.13ms. Time per element: 0.60ms
[21:15:33] # of elements fetched individually: 100. Total time: 59.64ms. Time per element: 0.60ms
[21:15:33] # of elements fetched individually: 100. Total time: 59.86ms. Time per element: 0.60ms
[21:15:33] # of elements fetched individually: 100. Total time: 59.34ms. Time per element: 0.59ms
[21:15:33] # of elements fetched individually: 100. Total time: 61.56ms. Time per element: 0.62ms
LINQ to DB v2.7.4.0 (v2.7.4) (compiled). Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:15:34] # of elements fetched: 31465. Fetch took: 625.95ms. Enumerating result took: 1.31ms.
[21:15:34] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 497.59ms.
[21:15:35] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 250.66ms.
[21:15:35] # of elements fetched individually: 100. Total time: 39.74ms. Time per element: 0.40ms
[21:15:35] # of elements inserted as set: 0 (batch size: 100). Set insert took: 57.88ms.
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:15:35] # of elements fetched: 31465. Fetch took: 125.01ms. Enumerating result took: 1.05ms.
[21:15:35] # of elements fetched: 31465. Fetch took: 122.25ms. Enumerating result took: 0.89ms.
[21:15:35] # of elements fetched: 31465. Fetch took: 127.39ms. Enumerating result took: 0.92ms.
[21:15:35] # of elements fetched: 31465. Fetch took: 121.96ms. Enumerating result took: 0.80ms.
[21:15:36] # of elements fetched: 31465. Fetch took: 124.23ms. Enumerating result took: 0.87ms.
[21:15:36] # of elements fetched: 31465. Fetch took: 123.37ms. Enumerating result took: 0.84ms.
[21:15:36] # of elements fetched: 31465. Fetch took: 123.41ms. Enumerating result took: 0.80ms.
[21:15:36] # of elements fetched: 31465. Fetch took: 127.23ms. Enumerating result took: 0.84ms.
[21:15:36] # of elements fetched: 31465. Fetch took: 126.43ms. Enumerating result took: 0.87ms.
[21:15:36] # of elements fetched: 31465. Fetch took: 142.20ms. Enumerating result took: 1.06ms.
Single element fetches
-------------------------
[21:15:36] # of elements fetched individually: 100. Total time: 17.81ms. Time per element: 0.18ms
[21:15:36] # of elements fetched individually: 100. Total time: 17.02ms. Time per element: 0.17ms
[21:15:36] # of elements fetched individually: 100. Total time: 16.65ms. Time per element: 0.17ms
[21:15:36] # of elements fetched individually: 100. Total time: 18.06ms. Time per element: 0.18ms
[21:15:36] # of elements fetched individually: 100. Total time: 18.39ms. Time per element: 0.18ms
[21:15:36] # of elements fetched individually: 100. Total time: 19.63ms. Time per element: 0.20ms
[21:15:36] # of elements fetched individually: 100. Total time: 17.47ms. Time per element: 0.17ms
[21:15:37] # of elements fetched individually: 100. Total time: 23.34ms. Time per element: 0.23ms
[21:15:37] # of elements fetched individually: 100. Total time: 20.19ms. Time per element: 0.20ms
[21:15:37] # of elements fetched individually: 100. Total time: 19.66ms. Time per element: 0.20ms
Eager Load fetches
-------------------------
[21:15:37] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 199.53ms.
[21:15:37] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 183.61ms.
[21:15:37] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 185.41ms.
[21:15:37] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 177.76ms.
[21:15:38] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 176.24ms.
[21:15:38] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 175.66ms.
[21:15:38] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 178.73ms.
[21:15:38] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 178.25ms.
[21:15:38] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 176.71ms.
[21:15:39] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 174.88ms.
Async eager Load fetches
-------------------------
[21:15:39] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 182.46ms.
[21:15:39] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 181.38ms.
[21:15:39] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 173.62ms.
[21:15:39] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 178.43ms.
[21:15:39] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 178.98ms.
[21:15:40] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 182.68ms.
[21:15:40] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 178.90ms.
[21:15:40] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 182.78ms.
[21:15:40] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 178.77ms.
[21:15:40] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 185.48ms.
Set Inserts
-------------------------
[21:15:41] # of elements inserted as set: 0 (batch size: 100). Set insert took: 24.82ms.
[21:15:41] # of elements inserted as set: 0 (batch size: 100). Set insert took: 25.79ms.
[21:15:41] # of elements inserted as set: 0 (batch size: 100). Set insert took: 24.98ms.
[21:15:41] # of elements inserted as set: 0 (batch size: 100). Set insert took: 24.72ms.
[21:15:41] # of elements inserted as set: 0 (batch size: 100). Set insert took: 24.91ms.
[21:15:41] # of elements inserted as set: 0 (batch size: 100). Set insert took: 24.75ms.
[21:15:41] # of elements inserted as set: 0 (batch size: 100). Set insert took: 25.43ms.
[21:15:41] # of elements inserted as set: 0 (batch size: 100). Set insert took: 26.35ms.
[21:15:42] # of elements inserted as set: 0 (batch size: 100). Set insert took: 26.65ms.
[21:15:42] # of elements inserted as set: 0 (batch size: 100). Set insert took: 24.56ms.
LINQ to DB v2.7.4.0 (v2.7.4) (normal). Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:15:42] # of elements fetched: 31465. Fetch took: 134.57ms. Enumerating result took: 0.86ms.
[21:15:42] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 233.89ms.
[21:15:42] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 198.93ms.
[21:15:42] # of elements fetched individually: 100. Total time: 34.07ms. Time per element: 0.34ms
[21:15:42] # of elements inserted as set: 0 (batch size: 100). Set insert took: 24.35ms.
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:15:43] # of elements fetched: 31465. Fetch took: 125.10ms. Enumerating result took: 0.87ms.
[21:15:43] # of elements fetched: 31465. Fetch took: 132.09ms. Enumerating result took: 0.81ms.
[21:15:43] # of elements fetched: 31465. Fetch took: 130.43ms. Enumerating result took: 0.97ms.
[21:15:43] # of elements fetched: 31465. Fetch took: 125.79ms. Enumerating result took: 0.84ms.
[21:15:43] # of elements fetched: 31465. Fetch took: 128.06ms. Enumerating result took: 0.81ms.
[21:15:43] # of elements fetched: 31465. Fetch took: 126.29ms. Enumerating result took: 0.80ms.
[21:15:43] # of elements fetched: 31465. Fetch took: 128.54ms. Enumerating result took: 0.84ms.
[21:15:44] # of elements fetched: 31465. Fetch took: 157.64ms. Enumerating result took: 0.98ms.
[21:15:44] # of elements fetched: 31465. Fetch took: 143.91ms. Enumerating result took: 0.80ms.
[21:15:44] # of elements fetched: 31465. Fetch took: 127.05ms. Enumerating result took: 1.05ms.
Single element fetches
-------------------------
[21:15:44] # of elements fetched individually: 100. Total time: 29.16ms. Time per element: 0.29ms
[21:15:44] # of elements fetched individually: 100. Total time: 25.61ms. Time per element: 0.26ms
[21:15:44] # of elements fetched individually: 100. Total time: 31.67ms. Time per element: 0.32ms
[21:15:44] # of elements fetched individually: 100. Total time: 21.48ms. Time per element: 0.21ms
[21:15:44] # of elements fetched individually: 100. Total time: 23.53ms. Time per element: 0.24ms
[21:15:44] # of elements fetched individually: 100. Total time: 18.71ms. Time per element: 0.19ms
[21:15:44] # of elements fetched individually: 100. Total time: 23.89ms. Time per element: 0.24ms
[21:15:44] # of elements fetched individually: 100. Total time: 21.50ms. Time per element: 0.21ms
[21:15:44] # of elements fetched individually: 100. Total time: 21.23ms. Time per element: 0.21ms
[21:15:44] # of elements fetched individually: 100. Total time: 19.60ms. Time per element: 0.20ms
Eager Load fetches
-------------------------
[21:15:45] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 179.26ms.
[21:15:45] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 179.17ms.
[21:15:45] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 177.24ms.
[21:15:45] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 174.38ms.
[21:15:45] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 178.23ms.
[21:15:45] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 174.27ms.
[21:15:46] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 178.50ms.
[21:15:46] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 176.27ms.
[21:15:46] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 177.10ms.
[21:15:46] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 174.49ms.
Async eager Load fetches
-------------------------
[21:15:46] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 180.74ms.
[21:15:47] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 187.51ms.
[21:15:47] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 183.73ms.
[21:15:47] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 182.67ms.
[21:15:47] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 186.46ms.
[21:15:47] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 186.42ms.
[21:15:48] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 183.50ms.
[21:15:48] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 184.57ms.
[21:15:48] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 183.89ms.
[21:15:48] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 187.92ms.
Set Inserts
-------------------------
[21:15:48] # of elements inserted as set: 0 (batch size: 100). Set insert took: 25.59ms.
[21:15:48] # of elements inserted as set: 0 (batch size: 100). Set insert took: 24.22ms.
[21:15:49] # of elements inserted as set: 0 (batch size: 100). Set insert took: 25.28ms.
[21:15:49] # of elements inserted as set: 0 (batch size: 100). Set insert took: 24.58ms.
[21:15:49] # of elements inserted as set: 0 (batch size: 100). Set insert took: 26.67ms.
[21:15:49] # of elements inserted as set: 0 (batch size: 100). Set insert took: 25.93ms.
[21:15:49] # of elements inserted as set: 0 (batch size: 100). Set insert took: 25.25ms.
[21:15:49] # of elements inserted as set: 0 (batch size: 100). Set insert took: 22.11ms.
[21:15:49] # of elements inserted as set: 0 (batch size: 100). Set insert took: 25.04ms.
[21:15:50] # of elements inserted as set: 0 (batch size: 100). Set insert took: 26.05ms.
Jerrycurl v1.0.0.0. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:15:50] # of elements fetched: 31465. Fetch took: 456.94ms. Enumerating result took: 1.34ms.
[21:15:50] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 125.00ms.
[21:15:50] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 59.29ms.
[21:15:50] # of elements fetched individually: 100. Total time: 44.92ms. Time per element: 0.45ms
[21:15:51] # of elements inserted as set: 0 (batch size: 100). Set insert took: 820.60ms.
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:15:51] # of elements fetched: 31465. Fetch took: 128.56ms. Enumerating result took: 1.03ms.
[21:15:51] # of elements fetched: 31465. Fetch took: 129.28ms. Enumerating result took: 0.98ms.
[21:15:52] # of elements fetched: 31465. Fetch took: 131.12ms. Enumerating result took: 1.04ms.
[21:15:52] # of elements fetched: 31465. Fetch took: 129.38ms. Enumerating result took: 1.03ms.
[21:15:52] # of elements fetched: 31465. Fetch took: 131.86ms. Enumerating result took: 1.12ms.
[21:15:52] # of elements fetched: 31465. Fetch took: 124.90ms. Enumerating result took: 1.07ms.
[21:15:52] # of elements fetched: 31465. Fetch took: 128.79ms. Enumerating result took: 1.06ms.
[21:15:52] # of elements fetched: 31465. Fetch took: 128.52ms. Enumerating result took: 1.08ms.
[21:15:52] # of elements fetched: 31465. Fetch took: 126.61ms. Enumerating result took: 1.19ms.
[21:15:53] # of elements fetched: 31465. Fetch took: 128.42ms. Enumerating result took: 1.31ms.
Single element fetches
-------------------------
[21:15:53] # of elements fetched individually: 100. Total time: 32.01ms. Time per element: 0.32ms
[21:15:53] # of elements fetched individually: 100. Total time: 35.62ms. Time per element: 0.36ms
[21:15:53] # of elements fetched individually: 100. Total time: 32.75ms. Time per element: 0.33ms
[21:15:53] # of elements fetched individually: 100. Total time: 29.41ms. Time per element: 0.29ms
[21:15:53] # of elements fetched individually: 100. Total time: 29.54ms. Time per element: 0.30ms
[21:15:53] # of elements fetched individually: 100. Total time: 29.17ms. Time per element: 0.29ms
[21:15:53] # of elements fetched individually: 100. Total time: 29.01ms. Time per element: 0.29ms
[21:15:53] # of elements fetched individually: 100. Total time: 29.56ms. Time per element: 0.30ms
[21:15:53] # of elements fetched individually: 100. Total time: 29.65ms. Time per element: 0.30ms
[21:15:53] # of elements fetched individually: 100. Total time: 29.68ms. Time per element: 0.30ms
Eager Load fetches
-------------------------
[21:15:53] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 16.59ms.
[21:15:53] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 17.32ms.
[21:15:53] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 16.85ms.
[21:15:53] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 16.66ms.
[21:15:53] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 16.46ms.
[21:15:53] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 18.07ms.
[21:15:53] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 17.37ms.
[21:15:53] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 17.33ms.
[21:15:53] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 17.57ms.
[21:15:53] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 17.29ms.
Async eager Load fetches
-------------------------
[21:15:53] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 25.28ms.
[21:15:53] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 25.21ms.
[21:15:53] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 24.10ms.
[21:15:54] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 23.11ms.
[21:15:54] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 24.48ms.
[21:15:54] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 24.55ms.
[21:15:54] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 25.41ms.
[21:15:54] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 24.27ms.
[21:15:54] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 24.58ms.
[21:15:54] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 24.46ms.
Set Inserts
-------------------------
[21:15:54] # of elements inserted as set: 0 (batch size: 100). Set insert took: 81.24ms.
[21:15:54] # of elements inserted as set: 0 (batch size: 100). Set insert took: 79.89ms.
[21:15:54] # of elements inserted as set: 0 (batch size: 100). Set insert took: 79.30ms.
[21:15:55] # of elements inserted as set: 0 (batch size: 100). Set insert took: 78.29ms.
[21:15:55] # of elements inserted as set: 0 (batch size: 100). Set insert took: 78.60ms.
[21:15:55] # of elements inserted as set: 0 (batch size: 100). Set insert took: 78.94ms.
[21:15:55] # of elements inserted as set: 0 (batch size: 100). Set insert took: 78.44ms.
[21:15:55] # of elements inserted as set: 0 (batch size: 100). Set insert took: 79.87ms.
[21:15:55] # of elements inserted as set: 0 (batch size: 100). Set insert took: 81.29ms.
[21:15:56] # of elements inserted as set: 0 (batch size: 100). Set insert took: 77.16ms.
LLBLGen Pro v5.6.0.0 (v5.6.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.
[21:15:56] # of elements fetched: 31465. Fetch took: 264.73ms. Enumerating result took: 1.25ms.
[21:15:56] # of elements fetched individually: 100. Total time: 29.26ms. Time per element: 0.29ms
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:15:56] # of elements fetched: 31465. Fetch took: 124.87ms. Enumerating result took: 0.95ms.
[21:15:56] # of elements fetched: 31465. Fetch took: 124.85ms. Enumerating result took: 1.14ms.
[21:15:56] # of elements fetched: 31465. Fetch took: 130.16ms. Enumerating result took: 0.96ms.
[21:15:57] # of elements fetched: 31465. Fetch took: 127.12ms. Enumerating result took: 1.00ms.
[21:15:57] # of elements fetched: 31465. Fetch took: 129.29ms. Enumerating result took: 0.95ms.
[21:15:57] # of elements fetched: 31465. Fetch took: 130.67ms. Enumerating result took: 0.95ms.
[21:15:57] # of elements fetched: 31465. Fetch took: 128.18ms. Enumerating result took: 0.98ms.
[21:15:57] # of elements fetched: 31465. Fetch took: 126.90ms. Enumerating result took: 1.02ms.
[21:15:57] # of elements fetched: 31465. Fetch took: 128.90ms. Enumerating result took: 1.10ms.
[21:15:57] # of elements fetched: 31465. Fetch took: 129.87ms. Enumerating result took: 1.03ms.
Single element fetches
-------------------------
[21:15:57] # of elements fetched individually: 100. Total time: 19.35ms. Time per element: 0.19ms
[21:15:58] # of elements fetched individually: 100. Total time: 28.21ms. Time per element: 0.28ms
[21:15:58] # of elements fetched individually: 100. Total time: 26.37ms. Time per element: 0.26ms
[21:15:58] # of elements fetched individually: 100. Total time: 17.23ms. Time per element: 0.17ms
[21:15:58] # of elements fetched individually: 100. Total time: 19.24ms. Time per element: 0.19ms
[21:15:58] # of elements fetched individually: 100. Total time: 17.63ms. Time per element: 0.18ms
[21:15:58] # of elements fetched individually: 100. Total time: 18.09ms. Time per element: 0.18ms
[21:15:58] # of elements fetched individually: 100. Total time: 17.69ms. Time per element: 0.18ms
[21:15:58] # of elements fetched individually: 100. Total time: 17.68ms. Time per element: 0.18ms
[21:15:58] # of elements fetched individually: 100. Total time: 19.60ms. Time per element: 0.20ms
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco typed view with QuerySpec. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:15:58] # of elements fetched: 31465. Fetch took: 333.04ms. Enumerating result took: 1.16ms.
[21:15:58] # of elements fetched individually: 100. Total time: 51.93ms. Time per element: 0.52ms
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:15:58] # of elements fetched: 31465. Fetch took: 147.83ms. Enumerating result took: 1.11ms.
[21:15:59] # of elements fetched: 31465. Fetch took: 146.35ms. Enumerating result took: 1.53ms.
[21:15:59] # of elements fetched: 31465. Fetch took: 151.86ms. Enumerating result took: 1.03ms.
[21:15:59] # of elements fetched: 31465. Fetch took: 150.47ms. Enumerating result took: 1.21ms.
[21:15:59] # of elements fetched: 31465. Fetch took: 147.57ms. Enumerating result took: 1.07ms.
[21:15:59] # of elements fetched: 31465. Fetch took: 144.30ms. Enumerating result took: 0.97ms.
[21:15:59] # of elements fetched: 31465. Fetch took: 142.71ms. Enumerating result took: 1.04ms.
[21:16:00] # of elements fetched: 31465. Fetch took: 150.67ms. Enumerating result took: 1.25ms.
[21:16:00] # of elements fetched: 31465. Fetch took: 145.36ms. Enumerating result took: 1.01ms.
[21:16:00] # of elements fetched: 31465. Fetch took: 149.83ms. Enumerating result took: 1.05ms.
Single element fetches
-------------------------
[21:16:00] # of elements fetched individually: 100. Total time: 26.04ms. Time per element: 0.26ms
[21:16:00] # of elements fetched individually: 100. Total time: 34.40ms. Time per element: 0.34ms
[21:16:00] # of elements fetched individually: 100. Total time: 31.99ms. Time per element: 0.32ms
[21:16:00] # of elements fetched individually: 100. Total time: 29.01ms. Time per element: 0.29ms
[21:16:00] # of elements fetched individually: 100. Total time: 28.43ms. Time per element: 0.28ms
[21:16:00] # of elements fetched individually: 100. Total time: 28.87ms. Time per element: 0.29ms
[21:16:00] # of elements fetched individually: 100. Total time: 27.33ms. Time per element: 0.27ms
[21:16:00] # of elements fetched individually: 100. Total time: 28.14ms. Time per element: 0.28ms
[21:16:00] # of elements fetched individually: 100. Total time: 28.26ms. Time per element: 0.28ms
[21:16:00] # of elements fetched individually: 100. Total time: 28.53ms. Time per element: 0.29ms
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco typed view with Linq. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:16:01] # of elements fetched: 31465. Fetch took: 248.97ms. Enumerating result took: 0.97ms.
[21:16:01] # of elements fetched individually: 100. Total time: 166.52ms. Time per element: 1.67ms
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:16:01] # of elements fetched: 31465. Fetch took: 145.30ms. Enumerating result took: 1.21ms.
[21:16:01] # of elements fetched: 31465. Fetch took: 148.88ms. Enumerating result took: 0.96ms.
[21:16:01] # of elements fetched: 31465. Fetch took: 148.01ms. Enumerating result took: 0.93ms.
[21:16:01] # of elements fetched: 31465. Fetch took: 148.75ms. Enumerating result took: 0.99ms.
[21:16:02] # of elements fetched: 31465. Fetch took: 153.84ms. Enumerating result took: 0.99ms.
[21:16:02] # of elements fetched: 31465. Fetch took: 151.32ms. Enumerating result took: 1.01ms.
[21:16:02] # of elements fetched: 31465. Fetch took: 150.29ms. Enumerating result took: 1.26ms.
[21:16:02] # of elements fetched: 31465. Fetch took: 152.05ms. Enumerating result took: 1.01ms.
[21:16:02] # of elements fetched: 31465. Fetch took: 149.83ms. Enumerating result took: 1.15ms.
[21:16:02] # of elements fetched: 31465. Fetch took: 146.90ms. Enumerating result took: 1.06ms.
Single element fetches
-------------------------
[21:16:03] # of elements fetched individually: 100. Total time: 85.68ms. Time per element: 0.86ms
[21:16:03] # of elements fetched individually: 100. Total time: 75.18ms. Time per element: 0.75ms
[21:16:03] # of elements fetched individually: 100. Total time: 87.33ms. Time per element: 0.87ms
[21:16:03] # of elements fetched individually: 100. Total time: 75.70ms. Time per element: 0.76ms
[21:16:03] # of elements fetched individually: 100. Total time: 76.61ms. Time per element: 0.77ms
[21:16:03] # of elements fetched individually: 100. Total time: 75.17ms. Time per element: 0.75ms
[21:16:03] # of elements fetched individually: 100. Total time: 75.32ms. Time per element: 0.75ms
[21:16:03] # of elements fetched individually: 100. Total time: 73.85ms. Time per element: 0.74ms
[21:16:03] # of elements fetched individually: 100. Total time: 74.33ms. Time per element: 0.74ms
[21:16:03] # of elements fetched individually: 100. Total time: 75.92ms. Time per element: 0.76ms
LLBLGen Pro v5.6.0.0 (v5.6.0), DataTable based TypedView. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:16:04] # of elements fetched: 31465. Fetch took: 260.49ms. Enumerating result took: 5.07ms.
[21:16:04] # of elements fetched individually: 100. Total time: 65.82ms. Time per element: 0.66ms
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:16:04] # of elements fetched: 31465. Fetch took: 245.12ms. Enumerating result took: 3.09ms.
[21:16:04] # of elements fetched: 31465. Fetch took: 242.41ms. Enumerating result took: 3.47ms.
[21:16:04] # of elements fetched: 31465. Fetch took: 246.42ms. Enumerating result took: 3.45ms.
[21:16:05] # of elements fetched: 31465. Fetch took: 253.44ms. Enumerating result took: 3.40ms.
[21:16:05] # of elements fetched: 31465. Fetch took: 239.37ms. Enumerating result took: 3.57ms.
[21:16:05] # of elements fetched: 31465. Fetch took: 242.24ms. Enumerating result took: 4.03ms.
[21:16:06] # of elements fetched: 31465. Fetch took: 242.50ms. Enumerating result took: 3.86ms.
[21:16:06] # of elements fetched: 31465. Fetch took: 251.04ms. Enumerating result took: 3.55ms.
[21:16:06] # of elements fetched: 31465. Fetch took: 241.86ms. Enumerating result took: 3.47ms.
[21:16:06] # of elements fetched: 31465. Fetch took: 243.92ms. Enumerating result took: 3.36ms.
Single element fetches
-------------------------
[21:16:06] # of elements fetched individually: 100. Total time: 50.66ms. Time per element: 0.51ms
[21:16:06] # of elements fetched individually: 100. Total time: 45.41ms. Time per element: 0.45ms
[21:16:07] # of elements fetched individually: 100. Total time: 41.39ms. Time per element: 0.41ms
[21:16:07] # of elements fetched individually: 100. Total time: 41.91ms. Time per element: 0.42ms
[21:16:07] # of elements fetched individually: 100. Total time: 41.70ms. Time per element: 0.42ms
[21:16:07] # of elements fetched individually: 100. Total time: 40.48ms. Time per element: 0.40ms
[21:16:07] # of elements fetched individually: 100. Total time: 44.02ms. Time per element: 0.44ms
[21:16:07] # of elements fetched individually: 100. Total time: 40.76ms. Time per element: 0.41ms
[21:16:07] # of elements fetched individually: 100. Total time: 42.59ms. Time per element: 0.43ms
[21:16:07] # of elements fetched individually: 100. Total time: 41.68ms. Time per element: 0.42ms
LLBLGen Pro v5.6.0.0 (v5.6.0). Change tracking: True. Caching: True.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:16:07] # of elements fetched: 31465. Fetch took: 348.14ms. Enumerating result took: 9.39ms.
[21:16:07] # of elements fetched individually: 100. Total time: 74.75ms. Time per element: 0.75ms
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:16:08] # of elements fetched: 31465. Fetch took: 57.53ms. Enumerating result took: 4.13ms.
[21:16:08] # of elements fetched: 31465. Fetch took: 61.88ms. Enumerating result took: 4.25ms.
[21:16:08] # of elements fetched: 31465. Fetch took: 62.54ms. Enumerating result took: 4.82ms.
[21:16:08] # of elements fetched: 31465. Fetch took: 61.45ms. Enumerating result took: 4.59ms.
[21:16:08] # of elements fetched: 31465. Fetch took: 62.47ms. Enumerating result took: 4.42ms.
[21:16:08] # of elements fetched: 31465. Fetch took: 61.23ms. Enumerating result took: 4.23ms.
[21:16:08] # of elements fetched: 31465. Fetch took: 61.79ms. Enumerating result took: 4.51ms.
[21:16:08] # of elements fetched: 31465. Fetch took: 63.45ms. Enumerating result took: 4.46ms.
[21:16:09] # of elements fetched: 31465. Fetch took: 60.65ms. Enumerating result took: 4.70ms.
[21:16:09] # of elements fetched: 31465. Fetch took: 60.92ms. Enumerating result took: 4.61ms.
Single element fetches
-------------------------
[21:16:09] # of elements fetched individually: 100. Total time: 9.66ms. Time per element: 0.10ms
[21:16:09] # of elements fetched individually: 100. Total time: 10.27ms. Time per element: 0.10ms
[21:16:09] # of elements fetched individually: 100. Total time: 10.40ms. Time per element: 0.10ms
[21:16:09] # of elements fetched individually: 100. Total time: 9.98ms. Time per element: 0.10ms
[21:16:09] # of elements fetched individually: 100. Total time: 11.01ms. Time per element: 0.11ms
[21:16:09] # of elements fetched individually: 100. Total time: 9.69ms. Time per element: 0.10ms
[21:16:09] # of elements fetched individually: 100. Total time: 9.73ms. Time per element: 0.10ms
[21:16:09] # of elements fetched individually: 100. Total time: 9.42ms. Time per element: 0.09ms
[21:16:09] # of elements fetched individually: 100. Total time: 10.12ms. Time per element: 0.10ms
[21:16:09] # of elements fetched individually: 100. Total time: 10.34ms. Time per element: 0.10ms
LLBLGen Pro v5.6.0.0 (v5.6.0). Change tracking: True. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:16:09] # of elements fetched: 31465. Fetch took: 224.19ms. Enumerating result took: 5.66ms.
[21:16:10] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 150.26ms.
[21:16:10] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 125.08ms.
[21:16:10] # of elements fetched individually: 100. Total time: 53.00ms. Time per element: 0.53ms
[21:16:11] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 903.52ms.
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:16:11] # of elements fetched: 31465. Fetch took: 232.60ms. Enumerating result took: 5.98ms.
[21:16:12] # of elements fetched: 31465. Fetch took: 227.41ms. Enumerating result took: 5.62ms.
[21:16:12] # of elements fetched: 31465. Fetch took: 229.80ms. Enumerating result took: 5.65ms.
[21:16:12] # of elements fetched: 31465. Fetch took: 226.06ms. Enumerating result took: 5.46ms.
[21:16:12] # of elements fetched: 31465. Fetch took: 229.71ms. Enumerating result took: 5.50ms.
[21:16:13] # of elements fetched: 31465. Fetch took: 225.29ms. Enumerating result took: 5.46ms.
[21:16:13] # of elements fetched: 31465. Fetch took: 231.58ms. Enumerating result took: 5.48ms.
[21:16:13] # of elements fetched: 31465. Fetch took: 231.31ms. Enumerating result took: 5.87ms.
[21:16:14] # of elements fetched: 31465. Fetch took: 228.15ms. Enumerating result took: 5.86ms.
[21:16:14] # of elements fetched: 31465. Fetch took: 255.36ms. Enumerating result took: 5.97ms.
Single element fetches
-------------------------
[21:16:14] # of elements fetched individually: 100. Total time: 25.34ms. Time per element: 0.25ms
[21:16:14] # of elements fetched individually: 100. Total time: 31.49ms. Time per element: 0.31ms
[21:16:14] # of elements fetched individually: 100. Total time: 30.02ms. Time per element: 0.30ms
[21:16:14] # of elements fetched individually: 100. Total time: 28.57ms. Time per element: 0.29ms
[21:16:15] # of elements fetched individually: 100. Total time: 32.27ms. Time per element: 0.32ms
[21:16:15] # of elements fetched individually: 100. Total time: 34.20ms. Time per element: 0.34ms
[21:16:15] # of elements fetched individually: 100. Total time: 24.44ms. Time per element: 0.24ms
[21:16:15] # of elements fetched individually: 100. Total time: 33.24ms. Time per element: 0.33ms
[21:16:15] # of elements fetched individually: 100. Total time: 28.51ms. Time per element: 0.29ms
[21:16:15] # of elements fetched individually: 100. Total time: 26.99ms. Time per element: 0.27ms
Eager Load fetches
-------------------------
[21:16:15] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 60.20ms.
[21:16:15] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 58.92ms.
[21:16:15] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 59.07ms.
[21:16:15] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 58.11ms.
[21:16:15] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 56.82ms.
[21:16:16] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 68.87ms.
[21:16:16] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 74.00ms.
[21:16:16] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 73.48ms.
[21:16:16] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 79.75ms.
[21:16:16] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 88.01ms.
Async eager Load fetches
-------------------------
[21:16:16] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 69.28ms.
[21:16:16] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 85.31ms.
[21:16:17] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 80.82ms.
[21:16:17] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 87.76ms.
[21:16:17] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 82.83ms.
[21:16:17] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 71.06ms.
[21:16:17] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 84.84ms.
[21:16:17] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 76.83ms.
[21:16:18] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 79.69ms.
[21:16:18] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 86.94ms.
Set Inserts
-------------------------
[21:16:19] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 924.64ms.
[21:16:20] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 936.50ms.
[21:16:21] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 901.65ms.
[21:16:22] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 588.84ms.
[21:16:22] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 91.77ms.
[21:16:22] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 88.31ms.
[21:16:22] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 87.88ms.
[21:16:22] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 87.63ms.
[21:16:23] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 92.24ms.
[21:16:23] # of elements inserted as set: 1000 (batch size: 100). Set insert took: 91.51ms.
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco DTO graph. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:16:23] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 131.89ms.
[21:16:23] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 72.91ms.
Doing a GC collect...
Done.
Starting bench runs...
Eager Load fetches
-------------------------
[21:16:23] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 26.12ms.
[21:16:23] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 27.66ms.
[21:16:23] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 26.19ms.
[21:16:23] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 24.95ms.
[21:16:23] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 24.92ms.
[21:16:23] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 26.19ms.
[21:16:23] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 25.35ms.
[21:16:23] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 25.26ms.
[21:16:23] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 25.06ms.
[21:16:23] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 25.63ms.
Async eager Load fetches
-------------------------
[21:16:23] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 27.20ms.
[21:16:24] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 26.31ms.
[21:16:24] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 26.28ms.
[21:16:24] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 25.51ms.
[21:16:24] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 24.92ms.
[21:16:24] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 26.00ms.
[21:16:24] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 25.50ms.
[21:16:24] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 25.58ms.
[21:16:24] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 27.26ms.
[21:16:24] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 26.21ms.
Dapper v1.60.0.0. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:16:24] # of elements fetched: 31465. Fetch took: 177.45ms. Enumerating result took: 1.34ms.
[21:16:24] # of elements fetched individually: 100. Total time: 36.31ms. Time per element: 0.36ms
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:16:24] # of elements fetched: 31465. Fetch took: 147.69ms. Enumerating result took: 1.03ms.
[21:16:24] # of elements fetched: 31465. Fetch took: 148.51ms. Enumerating result took: 1.03ms.
[21:16:25] # of elements fetched: 31465. Fetch took: 146.12ms. Enumerating result took: 1.47ms.
[21:16:25] # of elements fetched: 31465. Fetch took: 148.86ms. Enumerating result took: 1.30ms.
[21:16:25] # of elements fetched: 31465. Fetch took: 149.01ms. Enumerating result took: 1.04ms.
[21:16:25] # of elements fetched: 31465. Fetch took: 149.61ms. Enumerating result took: 1.04ms.
[21:16:25] # of elements fetched: 31465. Fetch took: 148.76ms. Enumerating result took: 1.05ms.
[21:16:25] # of elements fetched: 31465. Fetch took: 147.48ms. Enumerating result took: 1.41ms.
[21:16:26] # of elements fetched: 31465. Fetch took: 146.80ms. Enumerating result took: 1.05ms.
[21:16:26] # of elements fetched: 31465. Fetch took: 148.03ms. Enumerating result took: 1.04ms.
Single element fetches
-------------------------
[21:16:26] # of elements fetched individually: 100. Total time: 26.64ms. Time per element: 0.27ms
[21:16:26] # of elements fetched individually: 100. Total time: 17.10ms. Time per element: 0.17ms
[21:16:26] # of elements fetched individually: 100. Total time: 27.13ms. Time per element: 0.27ms
[21:16:26] # of elements fetched individually: 100. Total time: 21.02ms. Time per element: 0.21ms
[21:16:26] # of elements fetched individually: 100. Total time: 16.61ms. Time per element: 0.17ms
[21:16:26] # of elements fetched individually: 100. Total time: 16.57ms. Time per element: 0.17ms
[21:16:26] # of elements fetched individually: 100. Total time: 16.43ms. Time per element: 0.16ms
[21:16:26] # of elements fetched individually: 100. Total time: 16.21ms. Time per element: 0.16ms
[21:16:26] # of elements fetched individually: 100. Total time: 17.54ms. Time per element: 0.18ms
[21:16:26] # of elements fetched individually: 100. Total time: 19.25ms. Time per element: 0.19ms
Tortuga Chain v2.1.0.0. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:16:27] # of elements fetched: 31465. Fetch took: 427.10ms. Enumerating result took: 1.14ms.
[21:16:27] # of elements fetched individually: 100. Total time: 41.69ms. Time per element: 0.42ms
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:16:27] # of elements fetched: 31465. Fetch took: 248.86ms. Enumerating result took: 1.14ms.
[21:16:27] # of elements fetched: 31465. Fetch took: 252.93ms. Enumerating result took: 1.08ms.
[21:16:27] # of elements fetched: 31465. Fetch took: 252.61ms. Enumerating result took: 1.04ms.
[21:16:28] # of elements fetched: 31465. Fetch took: 252.38ms. Enumerating result took: 1.23ms.
[21:16:28] # of elements fetched: 31465. Fetch took: 249.70ms. Enumerating result took: 1.31ms.
[21:16:28] # of elements fetched: 31465. Fetch took: 249.85ms. Enumerating result took: 1.13ms.
[21:16:29] # of elements fetched: 31465. Fetch took: 249.58ms. Enumerating result took: 1.07ms.
[21:16:29] # of elements fetched: 31465. Fetch took: 248.45ms. Enumerating result took: 1.03ms.
[21:16:29] # of elements fetched: 31465. Fetch took: 254.63ms. Enumerating result took: 1.21ms.
[21:16:29] # of elements fetched: 31465. Fetch took: 255.57ms. Enumerating result took: 1.05ms.
Single element fetches
-------------------------
[21:16:29] # of elements fetched individually: 100. Total time: 27.47ms. Time per element: 0.27ms
[21:16:29] # of elements fetched individually: 100. Total time: 29.18ms. Time per element: 0.29ms
[21:16:30] # of elements fetched individually: 100. Total time: 28.32ms. Time per element: 0.28ms
[21:16:30] # of elements fetched individually: 100. Total time: 28.43ms. Time per element: 0.28ms
[21:16:30] # of elements fetched individually: 100. Total time: 30.69ms. Time per element: 0.31ms
[21:16:30] # of elements fetched individually: 100. Total time: 25.77ms. Time per element: 0.26ms
[21:16:30] # of elements fetched individually: 100. Total time: 24.66ms. Time per element: 0.25ms
[21:16:30] # of elements fetched individually: 100. Total time: 26.00ms. Time per element: 0.26ms
[21:16:30] # of elements fetched individually: 100. Total time: 24.62ms. Time per element: 0.25ms
[21:16:30] # of elements fetched individually: 100. Total time: 23.09ms. Time per element: 0.23ms
ServiceStack OrmLite v5.0.0.0 (v5.5.0.0). Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:16:30] # of elements fetched: 31465. Fetch took: 219.52ms. Enumerating result took: 1.43ms.
[21:16:30] # of elements fetched individually: 100. Total time: 38.26ms. Time per element: 0.38ms
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:16:30] # of elements fetched: 31465. Fetch took: 159.30ms. Enumerating result took: 1.25ms.
[21:16:30] # of elements fetched: 31465. Fetch took: 162.13ms. Enumerating result took: 1.46ms.
[21:16:31] # of elements fetched: 31465. Fetch took: 163.87ms. Enumerating result took: 1.23ms.
[21:16:31] # of elements fetched: 31465. Fetch took: 162.54ms. Enumerating result took: 1.17ms.
[21:16:31] # of elements fetched: 31465. Fetch took: 162.41ms. Enumerating result took: 2.10ms.
[21:16:31] # of elements fetched: 31465. Fetch took: 161.04ms. Enumerating result took: 1.18ms.
[21:16:31] # of elements fetched: 31465. Fetch took: 162.43ms. Enumerating result took: 1.18ms.
[21:16:32] # of elements fetched: 31465. Fetch took: 161.72ms. Enumerating result took: 1.23ms.
[21:16:32] # of elements fetched: 31465. Fetch took: 159.85ms. Enumerating result took: 1.18ms.
[21:16:32] # of elements fetched: 31465. Fetch took: 161.06ms. Enumerating result took: 1.19ms.
Single element fetches
-------------------------
[21:16:32] # of elements fetched individually: 100. Total time: 26.48ms. Time per element: 0.26ms
[21:16:32] # of elements fetched individually: 100. Total time: 18.18ms. Time per element: 0.18ms
[21:16:32] # of elements fetched individually: 100. Total time: 25.60ms. Time per element: 0.26ms
[21:16:32] # of elements fetched individually: 100. Total time: 29.06ms. Time per element: 0.29ms
[21:16:32] # of elements fetched individually: 100. Total time: 19.73ms. Time per element: 0.20ms
[21:16:32] # of elements fetched individually: 100. Total time: 18.48ms. Time per element: 0.18ms
[21:16:32] # of elements fetched individually: 100. Total time: 20.62ms. Time per element: 0.21ms
[21:16:32] # of elements fetched individually: 100. Total time: 20.32ms. Time per element: 0.20ms
[21:16:32] # of elements fetched individually: 100. Total time: 19.40ms. Time per element: 0.19ms
[21:16:32] # of elements fetched individually: 100. Total time: 18.84ms. Time per element: 0.19ms
DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:16:33] # of elements fetched: 31465. Fetch took: 202.43ms. Enumerating result took: 36.07ms.
[21:16:33] # of elements fetched individually: 100. Total time: 28.52ms. Time per element: 0.29ms
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:16:33] # of elements fetched: 31465. Fetch took: 201.15ms. Enumerating result took: 36.34ms.
[21:16:33] # of elements fetched: 31465. Fetch took: 205.53ms. Enumerating result took: 35.93ms.
[21:16:33] # of elements fetched: 31465. Fetch took: 201.46ms. Enumerating result took: 35.98ms.
[21:16:34] # of elements fetched: 31465. Fetch took: 203.17ms. Enumerating result took: 36.10ms.
[21:16:34] # of elements fetched: 31465. Fetch took: 206.95ms. Enumerating result took: 36.47ms.
[21:16:34] # of elements fetched: 31465. Fetch took: 201.91ms. Enumerating result took: 36.66ms.
[21:16:34] # of elements fetched: 31465. Fetch took: 205.79ms. Enumerating result took: 35.21ms.
[21:16:35] # of elements fetched: 31465. Fetch took: 201.43ms. Enumerating result took: 36.10ms.
[21:16:35] # of elements fetched: 31465. Fetch took: 203.00ms. Enumerating result took: 35.07ms.
[21:16:35] # of elements fetched: 31465. Fetch took: 201.96ms. Enumerating result took: 36.07ms.
Single element fetches
-------------------------
[21:16:35] # of elements fetched individually: 100. Total time: 24.80ms. Time per element: 0.25ms
[21:16:35] # of elements fetched individually: 100. Total time: 27.83ms. Time per element: 0.28ms
[21:16:35] # of elements fetched individually: 100. Total time: 31.84ms. Time per element: 0.32ms
[21:16:35] # of elements fetched individually: 100. Total time: 24.52ms. Time per element: 0.25ms
[21:16:35] # of elements fetched individually: 100. Total time: 23.13ms. Time per element: 0.23ms
[21:16:35] # of elements fetched individually: 100. Total time: 25.85ms. Time per element: 0.26ms
[21:16:35] # of elements fetched individually: 100. Total time: 24.25ms. Time per element: 0.24ms
[21:16:36] # of elements fetched individually: 100. Total time: 23.86ms. Time per element: 0.24ms
[21:16:36] # of elements fetched individually: 100. Total time: 25.10ms. Time per element: 0.25ms
[21:16:36] # of elements fetched individually: 100. Total time: 25.84ms. Time per element: 0.26ms
Tortuga Chain, Compiled v2.1.0.0. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
First one warm-up run of each bench type to initialize constructs. Results will not be collected.
[21:16:38] # of elements fetched: 31465. Fetch took: 2,784.99ms. Enumerating result took: 1.33ms.
[21:16:39] # of elements fetched individually: 100. Total time: 211.06ms. Time per element: 2.11ms
Doing a GC collect...
Done.
Starting bench runs...
Set fetches
-------------------------
[21:16:39] # of elements fetched: 31465. Fetch took: 144.88ms. Enumerating result took: 1.09ms.
[21:16:39] # of elements fetched: 31465. Fetch took: 148.08ms. Enumerating result took: 1.58ms.
[21:16:39] # of elements fetched: 31465. Fetch took: 134.22ms. Enumerating result took: 1.10ms.
[21:16:39] # of elements fetched: 31465. Fetch took: 148.20ms. Enumerating result took: 1.13ms.
[21:16:39] # of elements fetched: 31465. Fetch took: 137.89ms. Enumerating result took: 1.37ms.
[21:16:40] # of elements fetched: 31465. Fetch took: 148.27ms. Enumerating result took: 1.21ms.
[21:16:40] # of elements fetched: 31465. Fetch took: 140.85ms. Enumerating result took: 1.26ms.
[21:16:40] # of elements fetched: 31465. Fetch took: 139.78ms. Enumerating result took: 1.21ms.
[21:16:40] # of elements fetched: 31465. Fetch took: 133.94ms. Enumerating result took: 1.13ms.
[21:16:40] # of elements fetched: 31465. Fetch took: 135.29ms. Enumerating result took: 1.13ms.
Single element fetches
-------------------------
[21:16:40] # of elements fetched individually: 100. Total time: 24.67ms. Time per element: 0.25ms
[21:16:40] # of elements fetched individually: 100. Total time: 26.80ms. Time per element: 0.27ms
[21:16:40] # of elements fetched individually: 100. Total time: 22.73ms. Time per element: 0.23ms
[21:16:40] # of elements fetched individually: 100. Total time: 24.88ms. Time per element: 0.25ms
[21:16:41] # of elements fetched individually: 100. Total time: 23.52ms. Time per element: 0.24ms
[21:16:41] # of elements fetched individually: 100. Total time: 24.75ms. Time per element: 0.25ms
[21:16:41] # of elements fetched individually: 100. Total time: 22.93ms. Time per element: 0.23ms
[21:16:41] # of elements fetched individually: 100. Total time: 22.89ms. Time per element: 0.23ms
[21:16:41] # of elements fetched individually: 100. Total time: 22.60ms. Time per element: 0.23ms
[21:16:41] # of elements fetched individually: 100. Total time: 24.24ms. Time per element: 0.24ms
Performing memory measurement runs.
====================================================================
Handcoded materializer using DbDataReader. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:41] # of elements fetched: 31465. Fetch took: 126.19ms. Allocated bytes: 12761264.
Single element fetches
-------------------------
[21:16:41] # of elements fetched individually: 100. Total time: 16.91ms. Allocated bytes per element: 11976.
Handcoded materializer using DbDataReader and GetFieldValue<T>. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:41] # of elements fetched: 31465. Fetch took: 163.76ms. Allocated bytes: 17691848.
Single element fetches
-------------------------
[21:16:41] # of elements fetched individually: 100. Total time: 20.32ms. Allocated bytes per element: 12144.
RepoDb (RawSql) v1.9.5.0. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:41] # of elements fetched: 31465. Fetch took: 123.51ms. Allocated bytes: 12764232.
Single element fetches
-------------------------
[21:16:41] # of elements fetched individually: 100. Total time: 22.11ms. Allocated bytes per element: 15488.
RepoDb (Poco) v1.9.5.0. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:41] # of elements fetched: 31465. Fetch took: 125.60ms. Allocated bytes: 12772352.
Single element fetches
-------------------------
[21:16:42] # of elements fetched individually: 100. Total time: 26.75ms. Allocated bytes per element: 25176.
Handcoded materializer using DbDataReader (GetValues(array), boxing). Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:42] # of elements fetched: 31465. Fetch took: 137.64ms. Allocated bytes: 28012600.
Single element fetches
-------------------------
[21:16:42] # of elements fetched individually: 100. Total time: 15.37ms. Allocated bytes per element: 12704.
Handcoded materializer using DbDataReader (GetValue(Ordinal), boxing). Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:42] # of elements fetched: 31465. Fetch took: 143.23ms. Allocated bytes: 28012368.
Single element fetches
-------------------------
[21:16:42] # of elements fetched individually: 100. Total time: 18.30ms. Allocated bytes per element: 12472.
Raw DbDataReader materializer using object arrays. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:42] # of elements fetched: 31465. Fetch took: 140.80ms. Allocated bytes: 28231912.
Single element fetches
-------------------------
[21:16:42] # of elements fetched individually: 100. Total time: 24.65ms. Allocated bytes per element: 260648.
Entity Framework Core v2.2.6.0 (v2.2.6.19169). Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:42] # of elements fetched: 31465. Fetch took: 138.12ms. Allocated bytes: 17831232.
Single element fetches
-------------------------
[21:16:42] # of elements fetched individually: 100. Total time: 43.74ms. Allocated bytes per element: 55864.
Entity Framework Core v2.2.6.0 (v2.2.6.19169). Change tracking: True. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:43] # of elements fetched: 31465. Fetch took: 380.91ms. Allocated bytes: 81561480.
Single element fetches
-------------------------
[21:16:43] # of elements fetched individually: 100. Total time: 38.94ms. Allocated bytes per element: 55536.
Eager Load fetches
-------------------------
[21:16:43] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 16,611,664.00ms. Allocated bytes: 16611664.
Async eager Load fetches
-------------------------
[21:16:43] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 440.00ms. Allocated bytes: 440.
Set inserts
-------------------------
[21:16:43] # of elements inserted as set: 1000. Set insert took: 148.97ms. Allocated bytes: 17037168.
Entity Framework Core v2.2.6.0 (v2.2.6.19169) Poco DTO Graph. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Eager Load fetches
-------------------------
[21:16:43] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 5,814,448.00ms. Allocated bytes: 5814448.
Async eager Load fetches
-------------------------
[21:16:44] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 440.00ms. Allocated bytes: 440.
NPoco v4.0.1.0 (v4.0.1.0). Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:44] # of elements fetched: 31465. Fetch took: 177.88ms. Allocated bytes: 38454600.
Single element fetches
-------------------------
[21:16:44] # of elements fetched individually: 100. Total time: 81.70ms. Allocated bytes per element: 138032.
LINQ to DB v2.7.4.0 (v2.7.4) (compiled). Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:44] # of elements fetched: 31465. Fetch took: 157.71ms. Allocated bytes: 14021176.
Single element fetches
-------------------------
[21:16:44] # of elements fetched individually: 100. Total time: 27.97ms. Allocated bytes per element: 12064.
Eager Load fetches
-------------------------
[21:16:44] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 9,429,432.00ms. Allocated bytes: 9429432.
Async eager Load fetches
-------------------------
[21:16:45] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 440.00ms. Allocated bytes: 440.
Set inserts
-------------------------
[21:16:45] # of elements inserted as set: 0. Set insert took: 42.46ms. Allocated bytes: 840424.
LINQ to DB v2.7.4.0 (v2.7.4) (normal). Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:45] # of elements fetched: 31465. Fetch took: 138.57ms. Allocated bytes: 14021592.
Single element fetches
-------------------------
[21:16:45] # of elements fetched individually: 100. Total time: 22.64ms. Allocated bytes per element: 18256.
Eager Load fetches
-------------------------
[21:16:45] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 9,441,472.00ms. Allocated bytes: 9441472.
Async eager Load fetches
-------------------------
[21:16:45] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 440.00ms. Allocated bytes: 440.
Set inserts
-------------------------
[21:16:45] # of elements inserted as set: 0. Set insert took: 22.27ms. Allocated bytes: 840424.
Jerrycurl v1.0.0.0. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:45] # of elements fetched: 31465. Fetch took: 129.21ms. Allocated bytes: 12817232.
Single element fetches
-------------------------
[21:16:46] # of elements fetched individually: 100. Total time: 35.73ms. Allocated bytes per element: 74736.
Eager Load fetches
-------------------------
[21:16:46] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 2,026,200.00ms. Allocated bytes: 2026200.
Async eager Load fetches
-------------------------
[21:16:46] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 440.00ms. Allocated bytes: 440.
Set inserts
-------------------------
[21:16:47] # of elements inserted as set: 0. Set insert took: 775.03ms. Allocated bytes: 15128216.
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco with Raw SQL. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:47] # of elements fetched: 31465. Fetch took: 130.42ms. Allocated bytes: 12765344.
Single element fetches
-------------------------
[21:16:47] # of elements fetched individually: 100. Total time: 27.76ms. Allocated bytes per element: 17224.
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco typed view with QuerySpec. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:47] # of elements fetched: 31465. Fetch took: 148.17ms. Allocated bytes: 29064792.
Single element fetches
-------------------------
[21:16:47] # of elements fetched individually: 100. Total time: 38.26ms. Allocated bytes per element: 63640.
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco typed view with Linq. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:47] # of elements fetched: 31465. Fetch took: 156.72ms. Allocated bytes: 29688968.
Single element fetches
-------------------------
[21:16:47] # of elements fetched individually: 100. Total time: 84.24ms. Allocated bytes per element: 248728.
LLBLGen Pro v5.6.0.0 (v5.6.0), DataTable based TypedView. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:47] # of elements fetched: 31465. Fetch took: 241.19ms. Allocated bytes: 54127208.
Single element fetches
-------------------------
[21:16:48] # of elements fetched individually: 100. Total time: 54.35ms. Allocated bytes per element: 143096.
LLBLGen Pro v5.6.0.0 (v5.6.0). Change tracking: True. Caching: True.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:48] # of elements fetched: 31465. Fetch took: 296.23ms. Allocated bytes: 73580104.
Single element fetches
-------------------------
[21:16:48] # of elements fetched individually: 100. Total time: 53.74ms. Allocated bytes per element: 107664.
LLBLGen Pro v5.6.0.0 (v5.6.0). Change tracking: True. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:48] # of elements fetched: 31465. Fetch took: 226.34ms. Allocated bytes: 50452384.
Single element fetches
-------------------------
[21:16:48] # of elements fetched individually: 100. Total time: 30.69ms. Allocated bytes per element: 50896.
Eager Load fetches
-------------------------
[21:16:49] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 18,966,240.00ms. Allocated bytes: 18966240.
Async eager Load fetches
-------------------------
[21:16:49] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 440.00ms. Allocated bytes: 440.
Set inserts
-------------------------
[21:16:49] # of elements inserted as set: 1000. Set insert took: 89.42ms. Allocated bytes: 11955040.
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco DTO graph. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Eager Load fetches
-------------------------
[21:16:49] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 8,068,984.00ms. Allocated bytes: 8068984.
Async eager Load fetches
-------------------------
[21:16:49] # of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 440.00ms. Allocated bytes: 440.
Dapper v1.60.0.0. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:49] # of elements fetched: 31465. Fetch took: 151.38ms. Allocated bytes: 28012704.
Single element fetches
-------------------------
[21:16:49] # of elements fetched individually: 100. Total time: 21.75ms. Allocated bytes per element: 12552.
Tortuga Chain v2.1.0.0. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:50] # of elements fetched: 31465. Fetch took: 255.32ms. Allocated bytes: 41172616.
Single element fetches
-------------------------
[21:16:50] # of elements fetched individually: 100. Total time: 30.67ms. Allocated bytes per element: 28072.
ServiceStack OrmLite v5.0.0.0 (v5.5.0.0). Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:50] # of elements fetched: 31465. Fetch took: 160.14ms. Allocated bytes: 31033808.
Single element fetches
-------------------------
[21:16:50] # of elements fetched individually: 100. Total time: 29.85ms. Allocated bytes per element: 14040.
DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:50] # of elements fetched: 31465. Fetch took: 203.56ms. Allocated bytes: 37178576.
Single element fetches
-------------------------
[21:16:50] # of elements fetched individually: 100. Total time: 32.02ms. Allocated bytes per element: 58224.
Tortuga Chain, Compiled v2.1.0.0. Change tracking: False. Caching: False.
--------------------------------------------------------------------------------------------
Starting bench runs...
Set fetches
-------------------------
[21:16:51] # of elements fetched: 31465. Fetch took: 160.96ms. Allocated bytes: 14788232.
Single element fetches
-------------------------
[21:16:51] # of elements fetched individually: 100. Total time: 21.53ms. Allocated bytes per element: 24768.
Results per framework. Values are given as: 'mean (standard deviation)'
==============================================================================
Non-change tracking fetches, set fetches (10 runs), no caching
------------------------------------------------------------------------------
Handcoded materializer using DbDataReader : 114.99ms (1.61ms) Enum: 0.98ms (0.10ms)
RepoDb (RawSql) v1.9.5.0 : 120.66ms (5.50ms) Enum: 0.96ms (0.06ms)
RepoDb (Poco) v1.9.5.0 : 124.33ms (2.29ms) Enum: 0.97ms (0.10ms)
LINQ to DB v2.7.4.0 (v2.7.4) (compiled) : 126.35ms (5.60ms) Enum: 0.89ms (0.09ms)
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco with Raw SQL : 128.08ms (1.99ms) Enum: 1.01ms (0.06ms)
Jerrycurl v1.0.0.0 : 128.74ms (1.89ms) Enum: 1.09ms (0.09ms)
Handcoded materializer using DbDataReader (GetValues(array), boxing) : 131.29ms (2.11ms) Enum: 1.17ms (0.09ms)
LINQ to DB v2.7.4.0 (v2.7.4) (normal) : 132.49ms (9.85ms) Enum: 0.88ms (0.09ms)
Entity Framework Core v2.2.6.0 (v2.2.6.19169) : 136.47ms (10.37ms) Enum: 1.00ms (0.13ms)
Tortuga Chain, Compiled v2.1.0.0 : 141.14ms (5.56ms) Enum: 1.22ms (0.14ms)
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco typed view with QuerySpec : 147.69ms (2.87ms) Enum: 1.13ms (0.16ms)
Dapper v1.60.0.0 : 148.09ms (1.02ms) Enum: 1.15ms (0.17ms)
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco typed view with Linq : 149.52ms (2.39ms) Enum: 1.06ms (0.11ms)
Handcoded materializer using DbDataReader (GetValue(Ordinal), boxing) : 150.94ms (5.64ms) Enum: 1.37ms (0.24ms)
Handcoded materializer using DbDataReader and GetFieldValue<T> : 160.67ms (1.57ms) Enum: 1.08ms (0.05ms)
Raw DbDataReader materializer using object arrays : 161.04ms (25.02ms) Enum: 2.28ms (0.63ms)
ServiceStack OrmLite v5.0.0.0 (v5.5.0.0) : 161.64ms (1.29ms) Enum: 1.32ms (0.27ms)
NPoco v4.0.1.0 (v4.0.1.0) : 168.85ms (3.37ms) Enum: 1.21ms (0.29ms)
LLBLGen Pro v5.6.0.0 (v5.6.0), DataTable based TypedView : 244.83ms (4.16ms) Enum: 3.52ms (0.25ms)
Tortuga Chain v2.1.0.0 : 251.46ms (2.37ms) Enum: 1.13ms (0.09ms)
Memory usage, per iteration
------------------------------------------------------------------------------
Handcoded materializer using DbDataReader : 12,462 KB (12,761,264 bytes)
RepoDb (RawSql) v1.9.5.0 : 12,465 KB (12,764,232 bytes)
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco with Raw SQL : 12,466 KB (12,765,344 bytes)
RepoDb (Poco) v1.9.5.0 : 12,473 KB (12,772,352 bytes)
Jerrycurl v1.0.0.0 : 12,516 KB (12,817,232 bytes)
LINQ to DB v2.7.4.0 (v2.7.4) (compiled) : 13,692 KB (14,021,176 bytes)
LINQ to DB v2.7.4.0 (v2.7.4) (normal) : 13,692 KB (14,021,592 bytes)
Tortuga Chain, Compiled v2.1.0.0 : 14,441 KB (14,788,232 bytes)
Handcoded materializer using DbDataReader and GetFieldValue<T> : 17,277 KB (17,691,848 bytes)
Entity Framework Core v2.2.6.0 (v2.2.6.19169) : 17,413 KB (17,831,232 bytes)
Handcoded materializer using DbDataReader (GetValue(Ordinal), boxing) : 27,355 KB (28,012,368 bytes)
Handcoded materializer using DbDataReader (GetValues(array), boxing) : 27,356 KB (28,012,600 bytes)
Dapper v1.60.0.0 : 27,356 KB (28,012,704 bytes)
Raw DbDataReader materializer using object arrays : 27,570 KB (28,231,912 bytes)
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco typed view with QuerySpec : 28,383 KB (29,064,792 bytes)
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco typed view with Linq : 28,993 KB (29,688,968 bytes)
ServiceStack OrmLite v5.0.0.0 (v5.5.0.0) : 30,306 KB (31,033,808 bytes)
NPoco v4.0.1.0 (v4.0.1.0) : 37,553 KB (38,454,600 bytes)
Tortuga Chain v2.1.0.0 : 40,207 KB (41,172,616 bytes)
LLBLGen Pro v5.6.0.0 (v5.6.0), DataTable based TypedView : 52,858 KB (54,127,208 bytes)
Change tracking fetches, set fetches (10 runs), no caching
------------------------------------------------------------------------------
DataTable, using DbDataAdapter : 203.24ms (2.00ms) Enum: 35.99ms (0.48ms)
LLBLGen Pro v5.6.0.0 (v5.6.0) : 231.73ms (8.20ms) Enum: 5.68ms (0.21ms)
Entity Framework Core v2.2.6.0 (v2.2.6.19169) : 393.83ms (18.13ms) Enum: 1.66ms (0.43ms)
Memory usage, per iteration
------------------------------------------------------------------------------
DataTable, using DbDataAdapter : 36,307 KB (37,178,576 bytes)
LLBLGen Pro v5.6.0.0 (v5.6.0) : 49,269 KB (50,452,384 bytes)
Entity Framework Core v2.2.6.0 (v2.2.6.19169) : 79,649 KB (81,561,480 bytes)
Non-change tracking individual fetches (100 elements, 10 runs), no caching
------------------------------------------------------------------------------
Handcoded materializer using DbDataReader : 0.14ms (0.01ms) per individual fetch
Handcoded materializer using DbDataReader and GetFieldValue<T> : 0.14ms (0.01ms) per individual fetch
RepoDb (RawSql) v1.9.5.0 : 0.16ms (0.01ms) per individual fetch
LINQ to DB v2.7.4.0 (v2.7.4) (compiled) : 0.19ms (0.02ms) per individual fetch
Dapper v1.60.0.0 : 0.19ms (0.04ms) per individual fetch
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco with Raw SQL : 0.20ms (0.04ms) per individual fetch
RepoDb (Poco) v1.9.5.0 : 0.21ms (0.02ms) per individual fetch
ServiceStack OrmLite v5.0.0.0 (v5.5.0.0) : 0.22ms (0.04ms) per individual fetch
Handcoded materializer using DbDataReader (GetValues(array), boxing) : 0.22ms (0.11ms) per individual fetch
LINQ to DB v2.7.4.0 (v2.7.4) (normal) : 0.24ms (0.04ms) per individual fetch
Tortuga Chain, Compiled v2.1.0.0 : 0.24ms (0.01ms) per individual fetch
Handcoded materializer using DbDataReader (GetValue(Ordinal), boxing) : 0.26ms (0.13ms) per individual fetch
Tortuga Chain v2.1.0.0 : 0.27ms (0.02ms) per individual fetch
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco typed view with QuerySpec : 0.29ms (0.02ms) per individual fetch
Jerrycurl v1.0.0.0 : 0.31ms (0.02ms) per individual fetch
Entity Framework Core v2.2.6.0 (v2.2.6.19169) : 0.36ms (0.02ms) per individual fetch
Raw DbDataReader materializer using object arrays : 0.41ms (0.24ms) per individual fetch
LLBLGen Pro v5.6.0.0 (v5.6.0), DataTable based TypedView : 0.43ms (0.03ms) per individual fetch
NPoco v4.0.1.0 (v4.0.1.0) : 0.60ms (0.02ms) per individual fetch
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco typed view with Linq : 0.78ms (0.05ms) per individual fetch
Memory usage, per individual element
------------------------------------------------------------------------------
Handcoded materializer using DbDataReader : 11 KB (11,976 bytes)
LINQ to DB v2.7.4.0 (v2.7.4) (compiled) : 11 KB (12,064 bytes)
Handcoded materializer using DbDataReader and GetFieldValue<T> : 11 KB (12,144 bytes)
Handcoded materializer using DbDataReader (GetValue(Ordinal), boxing) : 12 KB (12,472 bytes)
Dapper v1.60.0.0 : 12 KB (12,552 bytes)
Handcoded materializer using DbDataReader (GetValues(array), boxing) : 12 KB (12,704 bytes)
ServiceStack OrmLite v5.0.0.0 (v5.5.0.0) : 13 KB (14,040 bytes)
RepoDb (RawSql) v1.9.5.0 : 15 KB (15,488 bytes)
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco with Raw SQL : 16 KB (17,224 bytes)
LINQ to DB v2.7.4.0 (v2.7.4) (normal) : 17 KB (18,256 bytes)
Tortuga Chain, Compiled v2.1.0.0 : 24 KB (24,768 bytes)
RepoDb (Poco) v1.9.5.0 : 24 KB (25,176 bytes)
Tortuga Chain v2.1.0.0 : 27 KB (28,072 bytes)
Entity Framework Core v2.2.6.0 (v2.2.6.19169) : 54 KB (55,864 bytes)
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco typed view with QuerySpec : 62 KB (63,640 bytes)
Jerrycurl v1.0.0.0 : 72 KB (74,736 bytes)
NPoco v4.0.1.0 (v4.0.1.0) : 134 KB (138,032 bytes)
LLBLGen Pro v5.6.0.0 (v5.6.0), DataTable based TypedView : 139 KB (143,096 bytes)
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco typed view with Linq : 242 KB (248,728 bytes)
Raw DbDataReader materializer using object arrays : 254 KB (260,648 bytes)
Change tracking individual fetches (100 elements, 10 runs), no caching
------------------------------------------------------------------------------
DataTable, using DbDataAdapter : 0.26ms (0.02ms) per individual fetch
LLBLGen Pro v5.6.0.0 (v5.6.0) : 0.30ms (0.03ms) per individual fetch
Entity Framework Core v2.2.6.0 (v2.2.6.19169) : 0.55ms (0.10ms) per individual fetch
Memory usage, per individual element
------------------------------------------------------------------------------
LLBLGen Pro v5.6.0.0 (v5.6.0) : 49 KB (50,896 bytes)
Entity Framework Core v2.2.6.0 (v2.2.6.19169) : 54 KB (55,536 bytes)
DataTable, using DbDataAdapter : 56 KB (58,224 bytes)
Non-change tracking fetches, eager load fetches, 3-node split graph, 1000 root elements (10 runs), no caching
------------------------------------------------------------------------------
Jerrycurl v1.0.0.0 : 17.15ms (0.48ms)
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco DTO graph : 25.73ms (0.80ms)
Entity Framework Core v2.2.6.0 (v2.2.6.19169) Poco DTO Graph : 33.19ms (0.65ms)
LINQ to DB v2.7.4.0 (v2.7.4) (normal) : 176.89ms (1.86ms)
LINQ to DB v2.7.4.0 (v2.7.4) (compiled) : 180.68ms (7.06ms)
Memory usage, per iteration
------------------------------------------------------------------------------
Jerrycurl v1.0.0.0 : 1,978 KB (2,026,200 bytes)
Entity Framework Core v2.2.6.0 (v2.2.6.19169) Poco DTO Graph : 5,678 KB (5,814,448 bytes)
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco DTO graph : 7,879 KB (8,068,984 bytes)
LINQ to DB v2.7.4.0 (v2.7.4) (compiled) : 9,208 KB (9,429,432 bytes)
LINQ to DB v2.7.4.0 (v2.7.4) (normal) : 9,220 KB (9,441,472 bytes)
Change tracking fetches, eager load fetches, 3-node split graph, 1000 root elements (10 runs), no caching
------------------------------------------------------------------------------
LLBLGen Pro v5.6.0.0 (v5.6.0) : 67.72ms (10.25ms)
Entity Framework Core v2.2.6.0 (v2.2.6.19169) : 96.72ms (5.07ms)
Memory usage, per iteration
------------------------------------------------------------------------------
Entity Framework Core v2.2.6.0 (v2.2.6.19169) : 16,222 KB (16,611,664 bytes)
LLBLGen Pro v5.6.0.0 (v5.6.0) : 18,521 KB (18,966,240 bytes)
Async change tracking fetches, eager load fetches, 3-node split graph, 1000 root elements (10 runs), no caching
------------------------------------------------------------------------------
LLBLGen Pro v5.6.0.0 (v5.6.0) : 80.54ms (6.09ms)
Entity Framework Core v2.2.6.0 (v2.2.6.19169) : 118.06ms (1.21ms)
Memory usage, per iteration
------------------------------------------------------------------------------
LLBLGen Pro v5.6.0.0 (v5.6.0) : 00 KB (440 bytes)
Entity Framework Core v2.2.6.0 (v2.2.6.19169) : 00 KB (440 bytes)
Async Non-change tracking fetches, eager load fetches, 3-node split graph, 1000 root elements (10 runs), no caching
------------------------------------------------------------------------------
Jerrycurl v1.0.0.0 : 24.54ms (0.64ms)
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco DTO graph : 26.08ms (0.71ms)
Entity Framework Core v2.2.6.0 (v2.2.6.19169) Poco DTO Graph : 51.21ms (0.70ms)
LINQ to DB v2.7.4.0 (v2.7.4) (normal) : 184.74ms (2.17ms)
LINQ to DB v2.7.4.0 (v2.7.4) (compiled) : 180.35ms (3.14ms)
Memory usage, per iteration
------------------------------------------------------------------------------
Jerrycurl v1.0.0.0 : 00 KB (440 bytes)
LLBLGen Pro v5.6.0.0 (v5.6.0), Poco DTO graph : 00 KB (440 bytes)
Entity Framework Core v2.2.6.0 (v2.2.6.19169) Poco DTO Graph : 00 KB (440 bytes)
LINQ to DB v2.7.4.0 (v2.7.4) (normal) : 00 KB (440 bytes)
LINQ to DB v2.7.4.0 (v2.7.4) (compiled) : 00 KB (440 bytes)
Change tracking fetches, set fetches (10 runs), caching
------------------------------------------------------------------------------
LLBLGen Pro v5.6.0.0 (v5.6.0) : 61.39ms (1.51ms) Enum: 4.47ms (0.21ms)
Memory usage, per iteration
------------------------------------------------------------------------------
LLBLGen Pro v5.6.0.0 (v5.6.0) : 71,855 KB (73,580,104 bytes)
Change tracking individual fetches (100 elements, 10 runs), caching
------------------------------------------------------------------------------
LLBLGen Pro v5.6.0.0 (v5.6.0) : 0.10ms (0.00ms) per individual fetch
Memory usage, per individual element
------------------------------------------------------------------------------
LLBLGen Pro v5.6.0.0 (v5.6.0) : 105 KB (107,664 bytes)
Set inserts of 1000 elements in one go (10 runs with batchsize 100)
------------------------------------------------------------------------------
LINQ to DB v2.7.4.0 (v2.7.4) (normal) : 25.07ms (1.20ms)
LINQ to DB v2.7.4.0 (v2.7.4) (compiled) : 25.30ms (0.70ms)
Jerrycurl v1.0.0.0 : 79.30ms (1.24ms)
Entity Framework Core v2.2.6.0 (v2.2.6.19169) : 134.62ms (31.22ms)
LLBLGen Pro v5.6.0.0 (v5.6.0) : 389.10ms (377.66ms)
Memory usage, per iteration
------------------------------------------------------------------------------
LINQ to DB v2.7.4.0 (v2.7.4) (normal) : 820 KB (840,424 bytes)
LINQ to DB v2.7.4.0 (v2.7.4) (compiled) : 820 KB (840,424 bytes)
LLBLGen Pro v5.6.0.0 (v5.6.0) : 11,674 KB (11,955,040 bytes)
Jerrycurl v1.0.0.0 : 14,773 KB (15,128,216 bytes)
Entity Framework Core v2.2.6.0 (v2.2.6.19169) : 16,637 KB (17,037,168 bytes)
Complete.
You can’t perform that action at this time.