API tools faq
paste
Advertisement
Guest User

Raw .NET Data Access / ORM Fetch benchmarks 17-May-2016

a guest
May 17th, 2016
565
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 85.93 KB | None | 0 0
raw download clone embed print report
  1. client HW: VMWare VM, Windows 8.1 64bit 8GB ram, on i7 3.6ghz with windows 8.1 64bit, 16GB ram
  2. server HW: i5, 8GB ram, Windows Server 2012 64bit,
  3. database: SQL Server 2014.
  4. Network: 1000BaseT / GB router
  5. regional settings: Dutch. ('1.0' in en-US is '1,0' here)
  6.  
  7. EF Core RC2.
  8.  
  9. +-------------------------------------------------------------------------------------------
  10. | Raw Data Access / ORM Benchmarks.
  11. | Code available at : https://github.com/FransBouma/RawDataAccessBencher
  12. | Benchmarks run on : dinsdag 17 mei 2016 16:42:01
  13. | Registered benchmarks :
  14. | Handcoded materializer using DbDataReader. Change tracking: False. Caching: False.
  15. | Handcoded materializer using DbDataReader (GetValues(array), boxing). Change tracking: False. Caching: False.
  16. | Raw DbDataReader materializer using object arrays. Change tracking: False. Caching: False.
  17. | Dapper v1.50.0.0. Change tracking: False. Caching: False.
  18. | Entity Framework v1.0.0.0 (v1.0.0.20512). Change tracking: False. Caching: False.
  19. | Entity Framework v1.0.0.0 (v1.0.0.20512). Change tracking: True. Caching: False.
  20. | Linq to Sql v4.0.0.0 (v4.6.1055.0). Change tracking: False. Caching: False.
  21. | LLBLGen Pro v5.0.0.0 (v5.0.2), Poco typed view with QuerySpec. Change tracking: False. Caching: False.
  22. | LLBLGen Pro v5.0.0.0 (v5.0.2), Poco typed view with Linq. Change tracking: False. Caching: False.
  23. | LLBLGen Pro v5.0.0.0 (v5.0.2), DataTable based TypedView. Change tracking: False. Caching: False.
  24. | LLBLGen Pro v5.0.0.0 (v5.0.2). Change tracking: True. Caching: True.
  25. | NHibernate v4.0.0.4000 (v4.0.4.4000). Change tracking: True. Caching: False.
  26. | LLBLGen Pro v5.0.0.0 (v5.0.2). Change tracking: True. Caching: False.
  27. | Linq to Sql v4.0.0.0 (v4.6.1055.0). Change tracking: True. Caching: False.
  28. | LINQ to DB v1.0.7.3 (v1.0.7.3) (normal). Change tracking: False. Caching: False.
  29. | LINQ to DB v1.0.7.3 (v1.0.7.3) (compiled). Change tracking: False. Caching: False.
  30. | PetaPoco v4.0.3. Change tracking: False. Caching: False.
  31. | PetaPoco Fast v4.0.3. Change tracking: False. Caching: False.
  32. | Entity Framework v6.0.0.0 (v6.1.40302.0). Change tracking: False. Caching: False.
  33. | Entity Framework v6.0.0.0 (v6.1.40302.0). Change tracking: True. Caching: False.
  34. | Oak.DynamicDb using dynamic Dto class. Change tracking: False. Caching: False.
  35. | Oak.DynamicDb using typed dynamic class. Change tracking: True. Caching: False.
  36. | DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
  37. | Massive using dynamic class. Change tracking: False. Caching: False.
  38. | ServiceStack OrmLite v4.0.56.0 (v4.0.56.0). Change tracking: False. Caching: False.
  39. | Run set benchmarks : True
  40. | Run individual fetch benchmarks: True
  41. | Number of set fetches : 10
  42. | Number of individual keys : 100
  43. | Release build : True
  44. | Client OS : Microsoft Windows NT 6.2.9200.0 (64bit)
  45. | Bencher runs as 64bit : True
  46. | CLR version : 4.0.30319.42000
  47. | Number of CPUs : 4
  48. | Server used : nerd.sd.local
  49. | Catalog used : AdventureWorks
  50. | SQL Server version used : 11.00.5058
  51. +-------------------------------------------------------------------------------------------
  52.  
  53. Results per framework. Values are given as: 'mean (standard deviation)'
  54. ==============================================================================
  55. Non-change tracking fetches, set fetches (10 runs), no caching
  56. ------------------------------------------------------------------------------
  57. Handcoded materializer using DbDataReader : 145,92ms (7,57ms) Enum: 1,22ms (0,05ms)
  58. LINQ to DB v1.0.7.3 (v1.0.7.3) (compiled) : 163,15ms (5,78ms) Enum: 1,10ms (0,03ms)
  59. Handcoded materializer using DbDataReader (GetValues(array), boxing) : 164,40ms (7,17ms) Enum: 1,34ms (0,08ms)
  60. LINQ to DB v1.0.7.3 (v1.0.7.3) (normal) : 165,71ms (5,60ms) Enum: 1,49ms (0,39ms)
  61. LLBLGen Pro v5.0.0.0 (v5.0.2), Poco typed view with QuerySpec : 172,82ms (7,24ms) Enum: 1,48ms (0,16ms)
  62. Raw DbDataReader materializer using object arrays : 174,68ms (13,36ms) Enum: 3,09ms (0,34ms)
  63. LLBLGen Pro v5.0.0.0 (v5.0.2), Poco typed view with Linq : 177,36ms (6,89ms) Enum: 1,34ms (0,22ms)
  64. PetaPoco Fast v4.0.3 : 183,81ms (9,60ms) Enum: 1,24ms (0,03ms)
  65. ServiceStack OrmLite v4.0.56.0 (v4.0.56.0) : 185,79ms (8,42ms) Enum: 1,19ms (0,38ms)
  66. PetaPoco v4.0.3 : 196,42ms (14,65ms) Enum: 1,44ms (0,30ms)
  67. Linq to Sql v4.0.0.0 (v4.6.1055.0) : 202,03ms (4,18ms) Enum: 1,78ms (0,04ms)
  68. Dapper v1.50.0.0 : 202,40ms (9,64ms) Enum: 1,53ms (0,22ms)
  69. Entity Framework v1.0.0.0 (v1.0.0.20512) : 215,81ms (11,22ms) Enum: 1,64ms (0,23ms)
  70. Entity Framework v6.0.0.0 (v6.1.40302.0) : 235,96ms (10,80ms) Enum: 1,85ms (0,49ms)
  71. LLBLGen Pro v5.0.0.0 (v5.0.2), DataTable based TypedView : 300,52ms (9,32ms) Enum: 2,92ms (0,33ms)
  72. Massive using dynamic class : 517,14ms (12,10ms) Enum: 21,32ms (1,71ms)
  73. Oak.DynamicDb using dynamic Dto class : 597,84ms (38,00ms) Enum: 129,54ms (34,93m
  74.  
  75.  
  76. Change tracking fetches, set fetches (10 runs), no caching
  77. ------------------------------------------------------------------------------
  78. DataTable, using DbDataAdapter : 238,46ms (7,85ms) Enum: 30,58ms (1,01ms)
  79. Linq to Sql v4.0.0.0 (v4.6.1055.0) : 296,49ms (8,04ms) Enum: 1,85ms (0,09ms)
  80. LLBLGen Pro v5.0.0.0 (v5.0.2) : 301,55ms (14,87ms) Enum: 7,80ms (0,41ms)
  81. Entity Framework v1.0.0.0 (v1.0.0.20512) : 368,87ms (30,27ms) Enum: 2,38ms (0,12ms)
  82. Oak.DynamicDb using typed dynamic class : 586,39ms (29,39ms) Enum: 734,44ms (43,24m
  83.  
  84. NHibernate v4.0.0.4000 (v4.0.4.4000) : 2.191,88ms (62,55ms) Enum: 2,13ms (0,42ms)
  85. Entity Framework v6.0.0.0 (v6.1.40302.0) : 2.547,89ms (118,26ms) Enum: 3,01ms (0,28ms)
  86.  
  87. Non-change tracking individual fetches (100 elements, 10 runs), no caching
  88. ------------------------------------------------------------------------------
  89. Handcoded materializer using DbDataReader (GetValues(array), boxing) : 0,54ms (0,04ms) per individual fetch
  90. Handcoded materializer using DbDataReader : 0,55ms (0,08ms) per individual fetch
  91. Massive using dynamic class : 0,56ms (0,01ms) per individual fetch
  92. LINQ to DB v1.0.7.3 (v1.0.7.3) (compiled) : 0,60ms (0,02ms) per individual fetch
  93. Oak.DynamicDb using dynamic Dto class : 0,61ms (0,02ms) per individual fetch
  94. ServiceStack OrmLite v4.0.56.0 (v4.0.56.0) : 0,63ms (0,02ms) per individual fetch
  95. LINQ to DB v1.0.7.3 (v1.0.7.3) (normal) : 0,63ms (0,02ms) per individual fetch
  96. LLBLGen Pro v5.0.0.0 (v5.0.2), Poco typed view with QuerySpec : 0,67ms (0,04ms) per individual fetch
  97. PetaPoco Fast v4.0.3 : 0,72ms (0,02ms) per individual fetch
  98. LLBLGen Pro v5.0.0.0 (v5.0.2), DataTable based TypedView : 0,78ms (0,01ms) per individual fetch
  99. Entity Framework v1.0.0.0 (v1.0.0.20512) : 0,78ms (0,02ms) per individual fetch
  100. Entity Framework v6.0.0.0 (v6.1.40302.0) : 0,91ms (0,01ms) per individual fetch
  101. Dapper v1.50.0.0 : 1,07ms (0,05ms) per individual fetch
  102. Raw DbDataReader materializer using object arrays : 1,10ms (0,05ms) per individual fetch
  103. LLBLGen Pro v5.0.0.0 (v5.0.2), Poco typed view with Linq : 1,34ms (0,03ms) per individual fetch
  104. Linq to Sql v4.0.0.0 (v4.6.1055.0) : 1,73ms (0,09ms) per individual fetch
  105. PetaPoco v4.0.3 : 3,74ms (0,14ms) per individual fetch
  106.  
  107. Change tracking individual fetches (100 elements, 10 runs), no caching
  108. ------------------------------------------------------------------------------
  109. DataTable, using DbDataAdapter : 0,60ms (0,02ms) per individual fetch
  110. Oak.DynamicDb using typed dynamic class : 0,61ms (0,02ms) per individual fetch
  111. LLBLGen Pro v5.0.0.0 (v5.0.2) : 0,66ms (0,05ms) per individual fetch
  112. NHibernate v4.0.0.4000 (v4.0.4.4000) : 0,76ms (0,01ms) per individual fetch
  113. Entity Framework v1.0.0.0 (v1.0.0.20512) : 0,79ms (0,02ms) per individual fetch
  114. Entity Framework v6.0.0.0 (v6.1.40302.0) : 0,99ms (0,02ms) per individual fetch
  115. Linq to Sql v4.0.0.0 (v4.6.1055.0) : 1,74ms (0,02ms) per individual fetch
  116.  
  117. Change tracking fetches, eager load fetches, 3-node split graph, 1000 root elements (10 runs), no caching
  118. ------------------------------------------------------------------------------
  119. Linq to Sql v4.0.0.0 (v4.6.1055.0) : 65,24ms (4,47ms)
  120. LLBLGen Pro v5.0.0.0 (v5.0.2) : 66,90ms (0,74ms)
  121. Entity Framework v1.0.0.0 (v1.0.0.20512) : 79,18ms (5,36ms)
  122. NHibernate v4.0.0.4000 (v4.0.4.4000) : 325,34ms (9,97ms)
  123. Entity Framework v6.0.0.0 (v6.1.40302.0) : 381,34ms (9,19ms)
  124.  
  125. Change tracking fetches, set fetches (10 runs), caching
  126. ------------------------------------------------------------------------------
  127. LLBLGen Pro v5.0.0.0 (v5.0.2) : 64,81ms (6,83ms) Enum: 7,26ms (0,75ms)
  128.  
  129. Change tracking individual fetches (100 elements, 10 runs), caching
  130. ------------------------------------------------------------------------------
  131. LLBLGen Pro v5.0.0.0 (v5.0.2) : 0,14ms (0,00ms) per individual fetch
  132.  
  133. Raw results:
  134. Warming up DB, DB client code and CLR
  135. ====================================================================
  136.  
  137. DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
  138. --------------------------------------------------------------------------------------------
  139. [16:42:01] Number of elements fetched: 31465. Fetch took: 265,12ms. Enumerating result took: 33,09ms
  140. [16:42:01] Number of elements fetched: 31465. Fetch took: 275,98ms. Enumerating result took: 31,37ms
  141. [16:42:02] Number of elements fetched: 31465. Fetch took: 233,30ms. Enumerating result took: 30,02ms
  142. [16:42:02] Number of elements fetched: 31465. Fetch took: 252,95ms. Enumerating result took: 30,57ms
  143. [16:42:02] Number of elements fetched: 31465. Fetch took: 244,52ms. Enumerating result took: 30,77ms
  144. [16:42:03] Number of elements fetched: 31465. Fetch took: 242,80ms. Enumerating result took: 31,18ms
  145. [16:42:03] Number of elements fetched: 31465. Fetch took: 227,92ms. Enumerating result took: 30,36ms
  146. [16:42:03] Number of elements fetched: 31465. Fetch took: 245,82ms. Enumerating result took: 30,28ms
  147. [16:42:03] Number of elements fetched: 31465. Fetch took: 234,08ms. Enumerating result took: 31,68ms
  148. [16:42:04] Number of elements fetched: 31465. Fetch took: 238,36ms. Enumerating result took: 32,39ms
  149.  
  150. Starting benchmarks.
  151. ====================================================================
  152.  
  153. Handcoded materializer using DbDataReader. Change tracking: False. Caching: False.
  154. --------------------------------------------------------------------------------------------
  155. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  156. [16:42:04] Number of elements fetched: 31465. Fetch took: 159,86ms. Enumerating result took: 1,63ms
  157. [16:42:04] Number of elements fetched individually: 100. Total time: 54,51ms. Time per element: 0,55ms
  158.  
  159. Starting bench runs...
  160. Set fetches
  161. -------------------------
  162. [16:42:04] Number of elements fetched: 31465. Fetch took: 161,85ms. Enumerating result took: 1,19ms
  163. [16:42:04] Number of elements fetched: 31465. Fetch took: 153,60ms. Enumerating result took: 1,20ms
  164. [16:42:04] Number of elements fetched: 31465. Fetch took: 142,58ms. Enumerating result took: 1,22ms
  165. [16:42:04] Number of elements fetched: 31465. Fetch took: 140,10ms. Enumerating result took: 1,21ms
  166. [16:42:05] Number of elements fetched: 31465. Fetch took: 139,50ms. Enumerating result took: 1,20ms
  167. [16:42:05] Number of elements fetched: 31465. Fetch took: 138,95ms. Enumerating result took: 1,22ms
  168. [16:42:05] Number of elements fetched: 31465. Fetch took: 149,83ms. Enumerating result took: 1,38ms
  169. [16:42:05] Number of elements fetched: 31465. Fetch took: 140,36ms. Enumerating result took: 1,19ms
  170. [16:42:05] Number of elements fetched: 31465. Fetch took: 152,53ms. Enumerating result took: 1,20ms
  171. [16:42:05] Number of elements fetched: 31465. Fetch took: 139,95ms. Enumerating result took: 1,23ms
  172.  
  173. Single element fetches
  174. -------------------------
  175. [16:42:05] Number of elements fetched individually: 100. Total time: 78,11ms. Time per element: 0,78ms
  176. [16:42:06] Number of elements fetched individually: 100. Total time: 54,26ms. Time per element: 0,54ms
  177. [16:42:06] Number of elements fetched individually: 100. Total time: 52,54ms. Time per element: 0,53ms
  178. [16:42:06] Number of elements fetched individually: 100. Total time: 54,25ms. Time per element: 0,54ms
  179. [16:42:06] Number of elements fetched individually: 100. Total time: 52,71ms. Time per element: 0,53ms
  180. [16:42:06] Number of elements fetched individually: 100. Total time: 51,48ms. Time per element: 0,51ms
  181. [16:42:06] Number of elements fetched individually: 100. Total time: 51,53ms. Time per element: 0,52ms
  182. [16:42:06] Number of elements fetched individually: 100. Total time: 51,71ms. Time per element: 0,52ms
  183. [16:42:06] Number of elements fetched individually: 100. Total time: 53,40ms. Time per element: 0,53ms
  184. [16:42:06] Number of elements fetched individually: 100. Total time: 53,74ms. Time per element: 0,54ms
  185.  
  186. Handcoded materializer using DbDataReader (GetValues(array), boxing). Change tracking: False. Caching: False.
  187. --------------------------------------------------------------------------------------------
  188. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  189. [16:42:06] Number of elements fetched: 31465. Fetch took: 161,82ms. Enumerating result took: 1,47ms
  190. [16:42:06] Number of elements fetched individually: 100. Total time: 66,35ms. Time per element: 0,66ms
  191.  
  192. Starting bench runs...
  193. Set fetches
  194. -------------------------
  195. [16:42:06] Number of elements fetched: 31465. Fetch took: 172,71ms. Enumerating result took: 1,53ms
  196. [16:42:07] Number of elements fetched: 31465. Fetch took: 166,81ms. Enumerating result took: 1,33ms
  197. [16:42:07] Number of elements fetched: 31465. Fetch took: 171,68ms. Enumerating result took: 1,23ms
  198. [16:42:07] Number of elements fetched: 31465. Fetch took: 157,00ms. Enumerating result took: 1,30ms
  199. [16:42:07] Number of elements fetched: 31465. Fetch took: 156,01ms. Enumerating result took: 1,33ms
  200. [16:42:07] Number of elements fetched: 31465. Fetch took: 160,91ms. Enumerating result took: 1,33ms
  201. [16:42:07] Number of elements fetched: 31465. Fetch took: 156,94ms. Enumerating result took: 1,42ms
  202. [16:42:08] Number of elements fetched: 31465. Fetch took: 156,78ms. Enumerating result took: 1,24ms
  203. [16:42:08] Number of elements fetched: 31465. Fetch took: 173,15ms. Enumerating result took: 1,36ms
  204. [16:42:08] Number of elements fetched: 31465. Fetch took: 172,04ms. Enumerating result took: 1,29ms
  205.  
  206. Single element fetches
  207. -------------------------
  208. [16:42:08] Number of elements fetched individually: 100. Total time: 61,25ms. Time per element: 0,61ms
  209. [16:42:08] Number of elements fetched individually: 100. Total time: 51,27ms. Time per element: 0,51ms
  210. [16:42:08] Number of elements fetched individually: 100. Total time: 51,84ms. Time per element: 0,52ms
  211. [16:42:08] Number of elements fetched individually: 100. Total time: 50,22ms. Time per element: 0,50ms
  212. [16:42:08] Number of elements fetched individually: 100. Total time: 50,23ms. Time per element: 0,50ms
  213. [16:42:08] Number of elements fetched individually: 100. Total time: 60,94ms. Time per element: 0,61ms
  214. [16:42:08] Number of elements fetched individually: 100. Total time: 55,25ms. Time per element: 0,55ms
  215. [16:42:08] Number of elements fetched individually: 100. Total time: 52,36ms. Time per element: 0,52ms
  216. [16:42:08] Number of elements fetched individually: 100. Total time: 54,16ms. Time per element: 0,54ms
  217. [16:42:08] Number of elements fetched individually: 100. Total time: 55,49ms. Time per element: 0,55ms
  218.  
  219. Raw DbDataReader materializer using object arrays. Change tracking: False. Caching: False.
  220. --------------------------------------------------------------------------------------------
  221. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  222. [16:42:09] Number of elements fetched: 31465. Fetch took: 171,71ms. Enumerating result took: 4,33ms
  223. [16:42:09] Number of elements fetched individually: 100. Total time: 118,20ms. Time per element: 1,18ms
  224.  
  225. Starting bench runs...
  226. Set fetches
  227. -------------------------
  228. [16:42:09] Number of elements fetched: 31465. Fetch took: 169,57ms. Enumerating result took: 3,06ms
  229. [16:42:09] Number of elements fetched: 31465. Fetch took: 145,70ms. Enumerating result took: 3,41ms
  230. [16:42:09] Number of elements fetched: 31465. Fetch took: 180,55ms. Enumerating result took: 3,09ms
  231. [16:42:10] Number of elements fetched: 31465. Fetch took: 181,65ms. Enumerating result took: 2,77ms
  232. [16:42:10] Number of elements fetched: 31465. Fetch took: 182,57ms. Enumerating result took: 3,01ms
  233. [16:42:10] Number of elements fetched: 31465. Fetch took: 162,73ms. Enumerating result took: 3,86ms
  234. [16:42:10] Number of elements fetched: 31465. Fetch took: 198,38ms. Enumerating result took: 2,80ms
  235. [16:42:10] Number of elements fetched: 31465. Fetch took: 178,57ms. Enumerating result took: 2,85ms
  236. [16:42:10] Number of elements fetched: 31465. Fetch took: 178,68ms. Enumerating result took: 2,73ms
  237. [16:42:11] Number of elements fetched: 31465. Fetch took: 168,41ms. Enumerating result took: 3,30ms
  238.  
  239. Single element fetches
  240. -------------------------
  241. [16:42:11] Number of elements fetched individually: 100. Total time: 105,91ms. Time per element: 1,06ms
  242. [16:42:11] Number of elements fetched individually: 100. Total time: 108,67ms. Time per element: 1,09ms
  243. [16:42:11] Number of elements fetched individually: 100. Total time: 106,00ms. Time per element: 1,06ms
  244. [16:42:11] Number of elements fetched individually: 100. Total time: 121,32ms. Time per element: 1,21ms
  245. [16:42:11] Number of elements fetched individually: 100. Total time: 110,21ms. Time per element: 1,10ms
  246. [16:42:11] Number of elements fetched individually: 100. Total time: 105,65ms. Time per element: 1,06ms
  247. [16:42:11] Number of elements fetched individually: 100. Total time: 115,58ms. Time per element: 1,16ms
  248. [16:42:12] Number of elements fetched individually: 100. Total time: 103,26ms. Time per element: 1,03ms
  249. [16:42:12] Number of elements fetched individually: 100. Total time: 113,84ms. Time per element: 1,14ms
  250. [16:42:12] Number of elements fetched individually: 100. Total time: 112,21ms. Time per element: 1,12ms
  251.  
  252. Dapper v1.50.0.0. Change tracking: False. Caching: False.
  253. --------------------------------------------------------------------------------------------
  254. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  255. [16:42:12] Number of elements fetched: 31465. Fetch took: 240,78ms. Enumerating result took: 1,33ms
  256. [16:42:12] Number of elements fetched individually: 100. Total time: 118,00ms. Time per element: 1,18ms
  257.  
  258. Starting bench runs...
  259. Set fetches
  260. -------------------------
  261. [16:42:12] Number of elements fetched: 31465. Fetch took: 188,79ms. Enumerating result took: 1,58ms
  262. [16:42:13] Number of elements fetched: 31465. Fetch took: 216,52ms. Enumerating result took: 1,43ms
  263. [16:42:13] Number of elements fetched: 31465. Fetch took: 197,81ms. Enumerating result took: 1,45ms
  264. [16:42:13] Number of elements fetched: 31465. Fetch took: 198,51ms. Enumerating result took: 1,43ms
  265. [16:42:13] Number of elements fetched: 31465. Fetch took: 208,07ms. Enumerating result took: 1,51ms
  266. [16:42:13] Number of elements fetched: 31465. Fetch took: 215,73ms. Enumerating result took: 1,46ms
  267. [16:42:14] Number of elements fetched: 31465. Fetch took: 204,70ms. Enumerating result took: 1,50ms
  268. [16:42:14] Number of elements fetched: 31465. Fetch took: 204,85ms. Enumerating result took: 2,18ms
  269. [16:42:14] Number of elements fetched: 31465. Fetch took: 185,49ms. Enumerating result took: 1,43ms
  270. [16:42:14] Number of elements fetched: 31465. Fetch took: 203,57ms. Enumerating result took: 1,38ms
  271.  
  272. Single element fetches
  273. -------------------------
  274. [16:42:14] Number of elements fetched individually: 100. Total time: 103,16ms. Time per element: 1,03ms
  275. [16:42:14] Number of elements fetched individually: 100. Total time: 108,18ms. Time per element: 1,08ms
  276. [16:42:15] Number of elements fetched individually: 100. Total time: 97,63ms. Time per element: 0,98ms
  277. [16:42:15] Number of elements fetched individually: 100. Total time: 114,04ms. Time per element: 1,14ms
  278. [16:42:15] Number of elements fetched individually: 100. Total time: 114,71ms. Time per element: 1,15ms
  279. [16:42:15] Number of elements fetched individually: 100. Total time: 104,96ms. Time per element: 1,05ms
  280. [16:42:15] Number of elements fetched individually: 100. Total time: 103,88ms. Time per element: 1,04ms
  281. [16:42:15] Number of elements fetched individually: 100. Total time: 112,05ms. Time per element: 1,12ms
  282. [16:42:15] Number of elements fetched individually: 100. Total time: 105,28ms. Time per element: 1,05ms
  283. [16:42:15] Number of elements fetched individually: 100. Total time: 107,11ms. Time per element: 1,07ms
  284.  
  285. Entity Framework v1.0.0.0 (v1.0.0.20512). Change tracking: False. Caching: False.
  286. --------------------------------------------------------------------------------------------
  287. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  288. [16:42:17] Number of elements fetched: 31465. Fetch took: 1.798,65ms. Enumerating result took: 1,55ms
  289. [16:42:17] Number of elements fetched individually: 100. Total time: 236,43ms. Time per element: 2,36ms
  290.  
  291. Starting bench runs...
  292. Set fetches
  293. -------------------------
  294. [16:42:18] Number of elements fetched: 31465. Fetch took: 231,61ms. Enumerating result took: 1,73ms
  295. [16:42:18] Number of elements fetched: 31465. Fetch took: 209,64ms. Enumerating result took: 1,53ms
  296. [16:42:18] Number of elements fetched: 31465. Fetch took: 217,34ms. Enumerating result took: 1,45ms
  297. [16:42:18] Number of elements fetched: 31465. Fetch took: 211,94ms. Enumerating result took: 1,64ms
  298. [16:42:19] Number of elements fetched: 31465. Fetch took: 233,51ms. Enumerating result took: 2,21ms
  299. [16:42:19] Number of elements fetched: 31465. Fetch took: 230,16ms. Enumerating result took: 1,49ms
  300. [16:42:19] Number of elements fetched: 31465. Fetch took: 204,41ms. Enumerating result took: 1,55ms
  301. [16:42:19] Number of elements fetched: 31465. Fetch took: 206,07ms. Enumerating result took: 1,50ms
  302. [16:42:19] Number of elements fetched: 31465. Fetch took: 201,95ms. Enumerating result took: 1,46ms
  303. [16:42:20] Number of elements fetched: 31465. Fetch took: 211,50ms. Enumerating result took: 1,86ms
  304.  
  305. Single element fetches
  306. -------------------------
  307. [16:42:20] Number of elements fetched individually: 100. Total time: 81,26ms. Time per element: 0,81ms
  308. [16:42:20] Number of elements fetched individually: 100. Total time: 79,02ms. Time per element: 0,79ms
  309. [16:42:20] Number of elements fetched individually: 100. Total time: 78,22ms. Time per element: 0,78ms
  310. [16:42:20] Number of elements fetched individually: 100. Total time: 75,80ms. Time per element: 0,76ms
  311. [16:42:20] Number of elements fetched individually: 100. Total time: 79,29ms. Time per element: 0,79ms
  312. [16:42:20] Number of elements fetched individually: 100. Total time: 75,33ms. Time per element: 0,75ms
  313. [16:42:20] Number of elements fetched individually: 100. Total time: 80,16ms. Time per element: 0,80ms
  314. [16:42:20] Number of elements fetched individually: 100. Total time: 78,31ms. Time per element: 0,78ms
  315. [16:42:20] Number of elements fetched individually: 100. Total time: 77,97ms. Time per element: 0,78ms
  316. [16:42:21] Number of elements fetched individually: 100. Total time: 79,10ms. Time per element: 0,79ms
  317.  
  318. Entity Framework v1.0.0.0 (v1.0.0.20512). Change tracking: True. Caching: False.
  319. --------------------------------------------------------------------------------------------
  320. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  321. [16:42:21] Number of elements fetched: 31465. Fetch took: 428,55ms. Enumerating result took: 2,37ms
  322. [16:42:21] Number of elements fetched: 6768. Fetch took: 249,34ms. Enumerating result took: 0,00ms
  323. [16:42:21] Number of elements fetched individually: 100. Total time: 97,03ms. Time per element: 0,97ms
  324.  
  325. Starting bench runs...
  326. Set fetches
  327. -------------------------
  328. [16:42:22] Number of elements fetched: 31465. Fetch took: 446,39ms. Enumerating result took: 2,27ms
  329. [16:42:22] Number of elements fetched: 31465. Fetch took: 350,54ms. Enumerating result took: 2,32ms
  330. [16:42:23] Number of elements fetched: 31465. Fetch took: 344,50ms. Enumerating result took: 2,35ms
  331. [16:42:23] Number of elements fetched: 31465. Fetch took: 366,80ms. Enumerating result took: 2,28ms
  332. [16:42:24] Number of elements fetched: 31465. Fetch took: 357,30ms. Enumerating result took: 2,46ms
  333. [16:42:24] Number of elements fetched: 31465. Fetch took: 342,00ms. Enumerating result took: 2,38ms
  334. [16:42:25] Number of elements fetched: 31465. Fetch took: 348,07ms. Enumerating result took: 2,24ms
  335. [16:42:25] Number of elements fetched: 31465. Fetch took: 386,75ms. Enumerating result took: 2,61ms
  336. [16:42:26] Number of elements fetched: 31465. Fetch took: 356,23ms. Enumerating result took: 2,56ms
  337. [16:42:26] Number of elements fetched: 31465. Fetch took: 390,11ms. Enumerating result took: 2,37ms
  338.  
  339. Single element fetches
  340. -------------------------
  341. [16:42:26] Number of elements fetched individually: 100. Total time: 82,99ms. Time per element: 0,83ms
  342. [16:42:26] Number of elements fetched individually: 100. Total time: 77,90ms. Time per element: 0,78ms
  343. [16:42:27] Number of elements fetched individually: 100. Total time: 79,62ms. Time per element: 0,80ms
  344. [16:42:27] Number of elements fetched individually: 100. Total time: 78,43ms. Time per element: 0,78ms
  345. [16:42:27] Number of elements fetched individually: 100. Total time: 79,31ms. Time per element: 0,79ms
  346. [16:42:27] Number of elements fetched individually: 100. Total time: 77,78ms. Time per element: 0,78ms
  347. [16:42:27] Number of elements fetched individually: 100. Total time: 76,95ms. Time per element: 0,77ms
  348. [16:42:27] Number of elements fetched individually: 100. Total time: 79,28ms. Time per element: 0,79ms
  349. [16:42:27] Number of elements fetched individually: 100. Total time: 77,97ms. Time per element: 0,78ms
  350. [16:42:28] Number of elements fetched individually: 100. Total time: 79,59ms. Time per element: 0,80ms
  351.  
  352. Eager Load fetches
  353. -------------------------
  354. [16:42:28] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 76,32ms.
  355. [16:42:28] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 86,33ms.
  356. [16:42:28] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 72,47ms.
  357. [16:42:28] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 83,99ms.
  358. [16:42:28] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 72,29ms.
  359. [16:42:29] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 85,34ms.
  360. [16:42:29] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 73,35ms.
  361. [16:42:29] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 81,80ms.
  362. [16:42:29] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 75,92ms.
  363. [16:42:29] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 83,95ms.
  364.  
  365. Linq to Sql v4.0.0.0 (v4.6.1055.0). Change tracking: False. Caching: False.
  366. --------------------------------------------------------------------------------------------
  367. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  368. [16:42:30] Number of elements fetched: 31465. Fetch took: 226,51ms. Enumerating result took: 2,01ms
  369. [16:42:30] Number of elements fetched individually: 100. Total time: 190,27ms. Time per element: 1,90ms
  370.  
  371. Starting bench runs...
  372. Set fetches
  373. -------------------------
  374. [16:42:30] Number of elements fetched: 31465. Fetch took: 201,29ms. Enumerating result took: 1,76ms
  375. [16:42:30] Number of elements fetched: 31465. Fetch took: 208,19ms. Enumerating result took: 1,77ms
  376. [16:42:31] Number of elements fetched: 31465. Fetch took: 204,63ms. Enumerating result took: 1,78ms
  377. [16:42:31] Number of elements fetched: 31465. Fetch took: 203,41ms. Enumerating result took: 1,80ms
  378. [16:42:31] Number of elements fetched: 31465. Fetch took: 201,73ms. Enumerating result took: 1,75ms
  379. [16:42:32] Number of elements fetched: 31465. Fetch took: 205,54ms. Enumerating result took: 1,76ms
  380. [16:42:32] Number of elements fetched: 31465. Fetch took: 193,55ms. Enumerating result took: 1,73ms
  381. [16:42:32] Number of elements fetched: 31465. Fetch took: 196,11ms. Enumerating result took: 1,78ms
  382. [16:42:32] Number of elements fetched: 31465. Fetch took: 204,75ms. Enumerating result took: 1,81ms
  383. [16:42:33] Number of elements fetched: 31465. Fetch took: 201,14ms. Enumerating result took: 1,87ms
  384.  
  385. Single element fetches
  386. -------------------------
  387. [16:42:33] Number of elements fetched individually: 100. Total time: 169,11ms. Time per element: 1,69ms
  388. [16:42:33] Number of elements fetched individually: 100. Total time: 169,26ms. Time per element: 1,69ms
  389. [16:42:33] Number of elements fetched individually: 100. Total time: 193,11ms. Time per element: 1,93ms
  390. [16:42:34] Number of elements fetched individually: 100. Total time: 188,57ms. Time per element: 1,89ms
  391. [16:42:34] Number of elements fetched individually: 100. Total time: 168,96ms. Time per element: 1,69ms
  392. [16:42:34] Number of elements fetched individually: 100. Total time: 166,47ms. Time per element: 1,66ms
  393. [16:42:34] Number of elements fetched individually: 100. Total time: 167,61ms. Time per element: 1,68ms
  394. [16:42:35] Number of elements fetched individually: 100. Total time: 168,90ms. Time per element: 1,69ms
  395. [16:42:35] Number of elements fetched individually: 100. Total time: 167,69ms. Time per element: 1,68ms
  396. [16:42:35] Number of elements fetched individually: 100. Total time: 168,54ms. Time per element: 1,69ms
  397.  
  398. LLBLGen Pro v5.0.0.0 (v5.0.2), Poco typed view with QuerySpec. Change tracking: False. Caching: False.
  399. --------------------------------------------------------------------------------------------
  400. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  401. [16:42:36] Number of elements fetched: 31465. Fetch took: 430,27ms. Enumerating result took: 1,68ms
  402. [16:42:36] Number of elements fetched individually: 100. Total time: 95,58ms. Time per element: 0,96ms
  403.  
  404. Starting bench runs...
  405. Set fetches
  406. -------------------------
  407. [16:42:36] Number of elements fetched: 31465. Fetch took: 170,95ms. Enumerating result took: 1,45ms
  408. [16:42:36] Number of elements fetched: 31465. Fetch took: 180,52ms. Enumerating result took: 1,31ms
  409. [16:42:36] Number of elements fetched: 31465. Fetch took: 162,84ms. Enumerating result took: 1,32ms
  410. [16:42:37] Number of elements fetched: 31465. Fetch took: 162,53ms. Enumerating result took: 1,42ms
  411. [16:42:37] Number of elements fetched: 31465. Fetch took: 171,85ms. Enumerating result took: 1,56ms
  412. [16:42:37] Number of elements fetched: 31465. Fetch took: 174,93ms. Enumerating result took: 1,35ms
  413. [16:42:38] Number of elements fetched: 31465. Fetch took: 181,37ms. Enumerating result took: 1,47ms
  414. [16:42:38] Number of elements fetched: 31465. Fetch took: 183,62ms. Enumerating result took: 1,64ms
  415. [16:42:38] Number of elements fetched: 31465. Fetch took: 174,45ms. Enumerating result took: 1,38ms
  416. [16:42:38] Number of elements fetched: 31465. Fetch took: 165,20ms. Enumerating result took: 1,86ms
  417.  
  418. Single element fetches
  419. -------------------------
  420. [16:42:39] Number of elements fetched individually: 100. Total time: 76,22ms. Time per element: 0,76ms
  421. [16:42:39] Number of elements fetched individually: 100. Total time: 66,03ms. Time per element: 0,66ms
  422. [16:42:39] Number of elements fetched individually: 100. Total time: 64,96ms. Time per element: 0,65ms
  423. [16:42:39] Number of elements fetched individually: 100. Total time: 65,39ms. Time per element: 0,65ms
  424. [16:42:39] Number of elements fetched individually: 100. Total time: 71,25ms. Time per element: 0,71ms
  425. [16:42:39] Number of elements fetched individually: 100. Total time: 68,05ms. Time per element: 0,68ms
  426. [16:42:39] Number of elements fetched individually: 100. Total time: 64,24ms. Time per element: 0,64ms
  427. [16:42:40] Number of elements fetched individually: 100. Total time: 63,29ms. Time per element: 0,63ms
  428. [16:42:40] Number of elements fetched individually: 100. Total time: 67,77ms. Time per element: 0,68ms
  429. [16:42:40] Number of elements fetched individually: 100. Total time: 67,65ms. Time per element: 0,68ms
  430.  
  431. LLBLGen Pro v5.0.0.0 (v5.0.2), Poco typed view with Linq. Change tracking: False. Caching: False.
  432. --------------------------------------------------------------------------------------------
  433. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  434. [16:42:40] Number of elements fetched: 31465. Fetch took: 294,80ms. Enumerating result took: 1,46ms
  435. [16:42:40] Number of elements fetched individually: 100. Total time: 215,45ms. Time per element: 2,15ms
  436.  
  437. Starting bench runs...
  438. Set fetches
  439. -------------------------
  440. [16:42:41] Number of elements fetched: 31465. Fetch took: 183,95ms. Enumerating result took: 0,98ms
  441. [16:42:41] Number of elements fetched: 31465. Fetch took: 183,45ms. Enumerating result took: 1,30ms
  442. [16:42:41] Number of elements fetched: 31465. Fetch took: 186,96ms. Enumerating result took: 1,90ms
  443. [16:42:41] Number of elements fetched: 31465. Fetch took: 168,47ms. Enumerating result took: 1,26ms
  444. [16:42:42] Number of elements fetched: 31465. Fetch took: 172,27ms. Enumerating result took: 1,39ms
  445. [16:42:42] Number of elements fetched: 31465. Fetch took: 177,76ms. Enumerating result took: 1,38ms
  446. [16:42:42] Number of elements fetched: 31465. Fetch took: 175,36ms. Enumerating result took: 1,29ms
  447. [16:42:43] Number of elements fetched: 31465. Fetch took: 183,54ms. Enumerating result took: 1,36ms
  448. [16:42:43] Number of elements fetched: 31465. Fetch took: 176,88ms. Enumerating result took: 1,30ms
  449. [16:42:43] Number of elements fetched: 31465. Fetch took: 164,92ms. Enumerating result took: 1,24ms
  450.  
  451. Single element fetches
  452. -------------------------
  453. [16:42:43] Number of elements fetched individually: 100. Total time: 134,43ms. Time per element: 1,34ms
  454. [16:42:44] Number of elements fetched individually: 100. Total time: 137,17ms. Time per element: 1,37ms
  455. [16:42:44] Number of elements fetched individually: 100. Total time: 126,69ms. Time per element: 1,27ms
  456. [16:42:44] Number of elements fetched individually: 100. Total time: 135,12ms. Time per element: 1,35ms
  457. [16:42:44] Number of elements fetched individually: 100. Total time: 132,25ms. Time per element: 1,32ms
  458. [16:42:44] Number of elements fetched individually: 100. Total time: 136,27ms. Time per element: 1,36ms
  459. [16:42:45] Number of elements fetched individually: 100. Total time: 136,77ms. Time per element: 1,37ms
  460. [16:42:45] Number of elements fetched individually: 100. Total time: 136,02ms. Time per element: 1,36ms
  461. [16:42:45] Number of elements fetched individually: 100. Total time: 132,38ms. Time per element: 1,32ms
  462. [16:42:45] Number of elements fetched individually: 100. Total time: 131,70ms. Time per element: 1,32ms
  463.  
  464. LLBLGen Pro v5.0.0.0 (v5.0.2), DataTable based TypedView. Change tracking: False. Caching: False.
  465. --------------------------------------------------------------------------------------------
  466. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  467. [16:42:46] Number of elements fetched: 31465. Fetch took: 327,12ms. Enumerating result took: 4,76ms
  468. [16:42:46] Number of elements fetched individually: 100. Total time: 83,01ms. Time per element: 0,83ms
  469.  
  470. Starting bench runs...
  471. Set fetches
  472. -------------------------
  473. [16:42:46] Number of elements fetched: 31465. Fetch took: 288,13ms. Enumerating result took: 2,82ms
  474. [16:42:46] Number of elements fetched: 31465. Fetch took: 287,63ms. Enumerating result took: 2,61ms
  475. [16:42:47] Number of elements fetched: 31465. Fetch took: 298,60ms. Enumerating result took: 3,04ms
  476. [16:42:47] Number of elements fetched: 31465. Fetch took: 311,26ms. Enumerating result took: 2,69ms
  477. [16:42:47] Number of elements fetched: 31465. Fetch took: 307,25ms. Enumerating result took: 3,58ms
  478. [16:42:48] Number of elements fetched: 31465. Fetch took: 300,31ms. Enumerating result took: 2,58ms
  479. [16:42:48] Number of elements fetched: 31465. Fetch took: 305,56ms. Enumerating result took: 3,18ms
  480. [16:42:49] Number of elements fetched: 31465. Fetch took: 317,45ms. Enumerating result took: 2,84ms
  481. [16:42:49] Number of elements fetched: 31465. Fetch took: 294,76ms. Enumerating result took: 3,32ms
  482. [16:42:49] Number of elements fetched: 31465. Fetch took: 294,23ms. Enumerating result took: 2,59ms
  483.  
  484. Single element fetches
  485. -------------------------
  486. [16:42:50] Number of elements fetched individually: 100. Total time: 79,41ms. Time per element: 0,79ms
  487. [16:42:50] Number of elements fetched individually: 100. Total time: 76,78ms. Time per element: 0,77ms
  488. [16:42:50] Number of elements fetched individually: 100. Total time: 78,29ms. Time per element: 0,78ms
  489. [16:42:50] Number of elements fetched individually: 100. Total time: 77,93ms. Time per element: 0,78ms
  490. [16:42:50] Number of elements fetched individually: 100. Total time: 75,19ms. Time per element: 0,75ms
  491. [16:42:50] Number of elements fetched individually: 100. Total time: 77,63ms. Time per element: 0,78ms
  492. [16:42:51] Number of elements fetched individually: 100. Total time: 76,01ms. Time per element: 0,76ms
  493. [16:42:51] Number of elements fetched individually: 100. Total time: 79,44ms. Time per element: 0,79ms
  494. [16:42:51] Number of elements fetched individually: 100. Total time: 77,97ms. Time per element: 0,78ms
  495. [16:42:51] Number of elements fetched individually: 100. Total time: 78,18ms. Time per element: 0,78ms
  496.  
  497. LLBLGen Pro v5.0.0.0 (v5.0.2). Change tracking: True. Caching: True.
  498. --------------------------------------------------------------------------------------------
  499. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  500. [16:42:51] Number of elements fetched: 31465. Fetch took: 369,02ms. Enumerating result took: 12,54ms
  501. [16:42:52] Number of elements fetched individually: 100. Total time: 257,27ms. Time per element: 2,57ms
  502.  
  503. Starting bench runs...
  504. Set fetches
  505. -------------------------
  506. [16:42:52] Number of elements fetched: 31465. Fetch took: 77,74ms. Enumerating result took: 8,50ms
  507. [16:42:52] Number of elements fetched: 31465. Fetch took: 56,15ms. Enumerating result took: 7,00ms
  508. [16:42:52] Number of elements fetched: 31465. Fetch took: 71,40ms. Enumerating result took: 6,68ms
  509. [16:42:52] Number of elements fetched: 31465. Fetch took: 60,84ms. Enumerating result took: 8,85ms
  510. [16:42:53] Number of elements fetched: 31465. Fetch took: 71,12ms. Enumerating result took: 7,53ms
  511. [16:42:53] Number of elements fetched: 31465. Fetch took: 60,21ms. Enumerating result took: 6,59ms
  512. [16:42:53] Number of elements fetched: 31465. Fetch took: 66,59ms. Enumerating result took: 6,67ms
  513. [16:42:53] Number of elements fetched: 31465. Fetch took: 57,88ms. Enumerating result took: 7,03ms
  514. [16:42:54] Number of elements fetched: 31465. Fetch took: 67,98ms. Enumerating result took: 6,97ms
  515. [16:42:54] Number of elements fetched: 31465. Fetch took: 58,20ms. Enumerating result took: 6,82ms
  516.  
  517. Single element fetches
  518. -------------------------
  519. [16:42:54] Number of elements fetched individually: 100. Total time: 14,58ms. Time per element: 0,15ms
  520. [16:42:54] Number of elements fetched individually: 100. Total time: 12,99ms. Time per element: 0,13ms
  521. [16:42:54] Number of elements fetched individually: 100. Total time: 13,61ms. Time per element: 0,14ms
  522. [16:42:54] Number of elements fetched individually: 100. Total time: 14,00ms. Time per element: 0,14ms
  523. [16:42:54] Number of elements fetched individually: 100. Total time: 13,94ms. Time per element: 0,14ms
  524. [16:42:55] Number of elements fetched individually: 100. Total time: 13,86ms. Time per element: 0,14ms
  525. [16:42:55] Number of elements fetched individually: 100. Total time: 14,47ms. Time per element: 0,14ms
  526. [16:42:55] Number of elements fetched individually: 100. Total time: 14,01ms. Time per element: 0,14ms
  527. [16:42:55] Number of elements fetched individually: 100. Total time: 14,38ms. Time per element: 0,14ms
  528. [16:42:55] Number of elements fetched individually: 100. Total time: 14,71ms. Time per element: 0,15ms
  529.  
  530. NHibernate v4.0.0.4000 (v4.0.4.4000). Change tracking: True. Caching: False.
  531. --------------------------------------------------------------------------------------------
  532. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  533. [16:42:59] Number of elements fetched: 31465. Fetch took: 3.749,87ms. Enumerating result took: 2,35ms
  534. [16:42:59] Number of elements fetched: 6768. Fetch took: 540,65ms. Enumerating result took: 0,00ms
  535. [16:43:00] Number of elements fetched individually: 100. Total time: 92,49ms. Time per element: 0,92ms
  536.  
  537. Starting bench runs...
  538. Set fetches
  539. -------------------------
  540. [16:43:02] Number of elements fetched: 31465. Fetch took: 2.323,44ms. Enumerating result took: 2,08ms
  541. [16:43:04] Number of elements fetched: 31465. Fetch took: 2.211,22ms. Enumerating result took: 2,14ms
  542. [16:43:07] Number of elements fetched: 31465. Fetch took: 2.142,80ms. Enumerating result took: 1,99ms
  543. [16:43:09] Number of elements fetched: 31465. Fetch took: 2.172,37ms. Enumerating result took: 2,15ms
  544. [16:43:11] Number of elements fetched: 31465. Fetch took: 2.285,52ms. Enumerating result took: 2,22ms
  545. [16:43:14] Number of elements fetched: 31465. Fetch took: 2.161,20ms. Enumerating result took: 2,21ms
  546. [16:43:16] Number of elements fetched: 31465. Fetch took: 2.149,17ms. Enumerating result took: 2,10ms
  547. [16:43:18] Number of elements fetched: 31465. Fetch took: 2.199,88ms. Enumerating result took: 2,83ms
  548. [16:43:21] Number of elements fetched: 31465. Fetch took: 2.114,92ms. Enumerating result took: 1,06ms
  549. [16:43:23] Number of elements fetched: 31465. Fetch took: 2.158,25ms. Enumerating result took: 2,48ms
  550.  
  551. Single element fetches
  552. -------------------------
  553. [16:43:23] Number of elements fetched individually: 100. Total time: 75,51ms. Time per element: 0,76ms
  554. [16:43:23] Number of elements fetched individually: 100. Total time: 74,01ms. Time per element: 0,74ms
  555. [16:43:23] Number of elements fetched individually: 100. Total time: 74,79ms. Time per element: 0,75ms
  556. [16:43:24] Number of elements fetched individually: 100. Total time: 75,78ms. Time per element: 0,76ms
  557. [16:43:24] Number of elements fetched individually: 100. Total time: 76,27ms. Time per element: 0,76ms
  558. [16:43:24] Number of elements fetched individually: 100. Total time: 78,13ms. Time per element: 0,78ms
  559. [16:43:24] Number of elements fetched individually: 100. Total time: 75,27ms. Time per element: 0,75ms
  560. [16:43:24] Number of elements fetched individually: 100. Total time: 74,47ms. Time per element: 0,74ms
  561. [16:43:24] Number of elements fetched individually: 100. Total time: 76,38ms. Time per element: 0,76ms
  562. [16:43:25] Number of elements fetched individually: 100. Total time: 75,67ms. Time per element: 0,76ms
  563.  
  564. Eager Load fetches
  565. -------------------------
  566. [16:43:25] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 337,84ms.
  567. [16:43:25] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 319,78ms.
  568. [16:43:26] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 320,89ms.
  569. [16:43:26] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 349,95ms.
  570. [16:43:27] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 318,37ms.
  571. [16:43:27] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 317,10ms.
  572. [16:43:28] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 320,27ms.
  573. [16:43:28] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 321,05ms.
  574. [16:43:28] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 327,01ms.
  575. [16:43:29] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 321,16ms.
  576.  
  577. LLBLGen Pro v5.0.0.0 (v5.0.2). Change tracking: True. Caching: False.
  578. --------------------------------------------------------------------------------------------
  579. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  580. [16:43:29] Number of elements fetched: 31465. Fetch took: 294,68ms. Enumerating result took: 7,80ms
  581. [16:43:29] Number of elements fetched: 6768. Fetch took: 163,77ms. Enumerating result took: 0,00ms
  582. [16:43:29] Number of elements fetched individually: 100. Total time: 99,55ms. Time per element: 1,00ms
  583.  
  584. Starting bench runs...
  585. Set fetches
  586. -------------------------
  587. [16:43:30] Number of elements fetched: 31465. Fetch took: 333,79ms. Enumerating result took: 8,00ms
  588. [16:43:30] Number of elements fetched: 31465. Fetch took: 300,59ms. Enumerating result took: 7,50ms
  589. [16:43:31] Number of elements fetched: 31465. Fetch took: 290,99ms. Enumerating result took: 7,36ms
  590. [16:43:31] Number of elements fetched: 31465. Fetch took: 280,50ms. Enumerating result took: 7,54ms
  591. [16:43:32] Number of elements fetched: 31465. Fetch took: 297,93ms. Enumerating result took: 7,75ms
  592. [16:43:32] Number of elements fetched: 31465. Fetch took: 290,98ms. Enumerating result took: 7,49ms
  593. [16:43:32] Number of elements fetched: 31465. Fetch took: 306,40ms. Enumerating result took: 8,86ms
  594. [16:43:33] Number of elements fetched: 31465. Fetch took: 301,17ms. Enumerating result took: 7,75ms
  595. [16:43:33] Number of elements fetched: 31465. Fetch took: 292,14ms. Enumerating result took: 7,81ms
  596. [16:43:34] Number of elements fetched: 31465. Fetch took: 321,04ms. Enumerating result took: 7,97ms
  597.  
  598. Single element fetches
  599. -------------------------
  600. [16:43:34] Number of elements fetched individually: 100. Total time: 63,84ms. Time per element: 0,64ms
  601. [16:43:34] Number of elements fetched individually: 100. Total time: 73,20ms. Time per element: 0,73ms
  602. [16:43:34] Number of elements fetched individually: 100. Total time: 75,42ms. Time per element: 0,75ms
  603. [16:43:34] Number of elements fetched individually: 100. Total time: 62,40ms. Time per element: 0,62ms
  604. [16:43:34] Number of elements fetched individually: 100. Total time: 63,31ms. Time per element: 0,63ms
  605. [16:43:35] Number of elements fetched individually: 100. Total time: 65,88ms. Time per element: 0,66ms
  606. [16:43:35] Number of elements fetched individually: 100. Total time: 61,51ms. Time per element: 0,62ms
  607. [16:43:35] Number of elements fetched individually: 100. Total time: 74,43ms. Time per element: 0,74ms
  608. [16:43:35] Number of elements fetched individually: 100. Total time: 60,97ms. Time per element: 0,61ms
  609. [16:43:35] Number of elements fetched individually: 100. Total time: 63,84ms. Time per element: 0,64ms
  610.  
  611. Eager Load fetches
  612. -------------------------
  613. [16:43:35] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 67,26ms.
  614. [16:43:36] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 67,78ms.
  615. [16:43:36] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 67,68ms.
  616. [16:43:36] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 66,02ms.
  617. [16:43:36] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 68,02ms.
  618. [16:43:36] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 66,23ms.
  619. [16:43:36] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 67,12ms.
  620. [16:43:37] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 66,74ms.
  621. [16:43:37] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 65,89ms.
  622. [16:43:37] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 66,27ms.
  623.  
  624. Linq to Sql v4.0.0.0 (v4.6.1055.0). Change tracking: True. Caching: False.
  625. --------------------------------------------------------------------------------------------
  626. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  627. [16:43:37] Number of elements fetched: 31465. Fetch took: 296,53ms. Enumerating result took: 2,10ms
  628. [16:43:37] Number of elements fetched: 6768. Fetch took: 137,36ms. Enumerating result took: 0,00ms
  629. [16:43:38] Number of elements fetched individually: 100. Total time: 193,35ms. Time per element: 1,93ms
  630.  
  631. Starting bench runs...
  632. Set fetches
  633. -------------------------
  634. [16:43:38] Number of elements fetched: 31465. Fetch took: 302,11ms. Enumerating result took: 2,05ms
  635. [16:43:38] Number of elements fetched: 31465. Fetch took: 299,00ms. Enumerating result took: 1,86ms
  636. [16:43:39] Number of elements fetched: 31465. Fetch took: 291,89ms. Enumerating result took: 1,72ms
  637. [16:43:39] Number of elements fetched: 31465. Fetch took: 290,81ms. Enumerating result took: 1,77ms
  638. [16:43:40] Number of elements fetched: 31465. Fetch took: 287,46ms. Enumerating result took: 1,78ms
  639. [16:43:40] Number of elements fetched: 31465. Fetch took: 315,05ms. Enumerating result took: 1,83ms
  640. [16:43:41] Number of elements fetched: 31465. Fetch took: 295,93ms. Enumerating result took: 1,87ms
  641. [16:43:41] Number of elements fetched: 31465. Fetch took: 289,08ms. Enumerating result took: 1,93ms
  642. [16:43:41] Number of elements fetched: 31465. Fetch took: 302,90ms. Enumerating result took: 1,78ms
  643. [16:43:42] Number of elements fetched: 31465. Fetch took: 290,70ms. Enumerating result took: 1,90ms
  644.  
  645. Single element fetches
  646. -------------------------
  647. [16:43:42] Number of elements fetched individually: 100. Total time: 176,71ms. Time per element: 1,77ms
  648. [16:43:42] Number of elements fetched individually: 100. Total time: 172,37ms. Time per element: 1,72ms
  649. [16:43:43] Number of elements fetched individually: 100. Total time: 173,40ms. Time per element: 1,73ms
  650. [16:43:43] Number of elements fetched individually: 100. Total time: 173,89ms. Time per element: 1,74ms
  651. [16:43:43] Number of elements fetched individually: 100. Total time: 171,92ms. Time per element: 1,72ms
  652. [16:43:43] Number of elements fetched individually: 100. Total time: 173,25ms. Time per element: 1,73ms
  653. [16:43:44] Number of elements fetched individually: 100. Total time: 174,30ms. Time per element: 1,74ms
  654. [16:43:44] Number of elements fetched individually: 100. Total time: 176,92ms. Time per element: 1,77ms
  655. [16:43:44] Number of elements fetched individually: 100. Total time: 177,04ms. Time per element: 1,77ms
  656. [16:43:44] Number of elements fetched individually: 100. Total time: 172,69ms. Time per element: 1,73ms
  657.  
  658. Eager Load fetches
  659. -------------------------
  660. [16:43:45] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 60,44ms.
  661. [16:43:45] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 70,15ms.
  662. [16:43:45] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 62,49ms.
  663. [16:43:45] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 64,32ms.
  664. [16:43:45] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 62,46ms.
  665. [16:43:45] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 66,13ms.
  666. [16:43:46] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 65,95ms.
  667. [16:43:46] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 62,93ms.
  668. [16:43:46] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 61,54ms.
  669. [16:43:46] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 76,04ms.
  670.  
  671. LINQ to DB v1.0.7.3 (v1.0.7.3) (normal). Change tracking: False. Caching: False.
  672. --------------------------------------------------------------------------------------------
  673. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  674. [16:43:47] Number of elements fetched: 31465. Fetch took: 617,61ms. Enumerating result took: 1,56ms
  675. [16:43:47] Number of elements fetched individually: 100. Total time: 204,11ms. Time per element: 2,04ms
  676.  
  677. Starting bench runs...
  678. Set fetches
  679. -------------------------
  680. [16:43:47] Number of elements fetched: 31465. Fetch took: 162,43ms. Enumerating result took: 1,33ms
  681. [16:43:47] Number of elements fetched: 31465. Fetch took: 162,76ms. Enumerating result took: 1,28ms
  682. [16:43:48] Number of elements fetched: 31465. Fetch took: 168,48ms. Enumerating result took: 1,50ms
  683. [16:43:48] Number of elements fetched: 31465. Fetch took: 169,54ms. Enumerating result took: 1,22ms
  684. [16:43:48] Number of elements fetched: 31465. Fetch took: 152,18ms. Enumerating result took: 1,23ms
  685. [16:43:48] Number of elements fetched: 31465. Fetch took: 171,38ms. Enumerating result took: 1,47ms
  686. [16:43:49] Number of elements fetched: 31465. Fetch took: 169,63ms. Enumerating result took: 2,55ms
  687. [16:43:49] Number of elements fetched: 31465. Fetch took: 165,19ms. Enumerating result took: 1,29ms
  688. [16:43:49] Number of elements fetched: 31465. Fetch took: 171,77ms. Enumerating result took: 1,24ms
  689. [16:43:49] Number of elements fetched: 31465. Fetch took: 163,77ms. Enumerating result took: 1,82ms
  690.  
  691. Single element fetches
  692. -------------------------
  693. [16:43:50] Number of elements fetched individually: 100. Total time: 64,62ms. Time per element: 0,65ms
  694. [16:43:50] Number of elements fetched individually: 100. Total time: 65,95ms. Time per element: 0,66ms
  695. [16:43:50] Number of elements fetched individually: 100. Total time: 63,53ms. Time per element: 0,64ms
  696. [16:43:50] Number of elements fetched individually: 100. Total time: 60,64ms. Time per element: 0,61ms
  697. [16:43:50] Number of elements fetched individually: 100. Total time: 58,00ms. Time per element: 0,58ms
  698. [16:43:50] Number of elements fetched individually: 100. Total time: 62,09ms. Time per element: 0,62ms
  699. [16:43:51] Number of elements fetched individually: 100. Total time: 66,36ms. Time per element: 0,66ms
  700. [16:43:51] Number of elements fetched individually: 100. Total time: 61,47ms. Time per element: 0,61ms
  701. [16:43:51] Number of elements fetched individually: 100. Total time: 62,34ms. Time per element: 0,62ms
  702. [16:43:51] Number of elements fetched individually: 100. Total time: 64,72ms. Time per element: 0,65ms
  703.  
  704. LINQ to DB v1.0.7.3 (v1.0.7.3) (compiled). Change tracking: False. Caching: False.
  705. --------------------------------------------------------------------------------------------
  706. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  707. [16:43:51] Number of elements fetched: 31465. Fetch took: 210,35ms. Enumerating result took: 1,23ms
  708. [16:43:51] Number of elements fetched individually: 100. Total time: 74,74ms. Time per element: 0,75ms
  709.  
  710. Starting bench runs...
  711. Set fetches
  712. -------------------------
  713. [16:43:52] Number of elements fetched: 31465. Fetch took: 173,78ms. Enumerating result took: 1,12ms
  714. [16:43:52] Number of elements fetched: 31465. Fetch took: 168,74ms. Enumerating result took: 1,05ms
  715. [16:43:52] Number of elements fetched: 31465. Fetch took: 166,34ms. Enumerating result took: 1,08ms
  716. [16:43:52] Number of elements fetched: 31465. Fetch took: 157,37ms. Enumerating result took: 1,13ms
  717. [16:43:53] Number of elements fetched: 31465. Fetch took: 156,63ms. Enumerating result took: 1,12ms
  718. [16:43:53] Number of elements fetched: 31465. Fetch took: 168,02ms. Enumerating result took: 1,09ms
  719. [16:43:53] Number of elements fetched: 31465. Fetch took: 159,82ms. Enumerating result took: 1,09ms
  720. [16:43:53] Number of elements fetched: 31465. Fetch took: 159,32ms. Enumerating result took: 1,06ms
  721. [16:43:54] Number of elements fetched: 31465. Fetch took: 165,38ms. Enumerating result took: 1,14ms
  722. [16:43:54] Number of elements fetched: 31465. Fetch took: 156,11ms. Enumerating result took: 1,10ms
  723.  
  724. Single element fetches
  725. -------------------------
  726. [16:43:54] Number of elements fetched individually: 100. Total time: 60,82ms. Time per element: 0,61ms
  727. [16:43:54] Number of elements fetched individually: 100. Total time: 60,15ms. Time per element: 0,60ms
  728. [16:43:54] Number of elements fetched individually: 100. Total time: 60,38ms. Time per element: 0,60ms
  729. [16:43:55] Number of elements fetched individually: 100. Total time: 59,66ms. Time per element: 0,60ms
  730. [16:43:55] Number of elements fetched individually: 100. Total time: 57,91ms. Time per element: 0,58ms
  731. [16:43:55] Number of elements fetched individually: 100. Total time: 56,59ms. Time per element: 0,57ms
  732. [16:43:55] Number of elements fetched individually: 100. Total time: 61,55ms. Time per element: 0,62ms
  733. [16:43:55] Number of elements fetched individually: 100. Total time: 65,16ms. Time per element: 0,65ms
  734. [16:43:55] Number of elements fetched individually: 100. Total time: 58,30ms. Time per element: 0,58ms
  735. [16:43:55] Number of elements fetched individually: 100. Total time: 60,42ms. Time per element: 0,60ms
  736.  
  737. PetaPoco v4.0.3. Change tracking: False. Caching: False.
  738. --------------------------------------------------------------------------------------------
  739. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  740. [16:43:56] Number of elements fetched: 31465. Fetch took: 206,29ms. Enumerating result took: 1,42ms
  741. [16:43:56] Number of elements fetched individually: 100. Total time: 429,81ms. Time per element: 4,30ms
  742.  
  743. Starting bench runs...
  744. Set fetches
  745. -------------------------
  746. [16:43:56] Number of elements fetched: 31465. Fetch took: 235,32ms. Enumerating result took: 1,72ms
  747. [16:43:57] Number of elements fetched: 31465. Fetch took: 185,75ms. Enumerating result took: 2,27ms
  748. [16:43:57] Number of elements fetched: 31465. Fetch took: 188,27ms. Enumerating result took: 1,35ms
  749. [16:43:57] Number of elements fetched: 31465. Fetch took: 198,07ms. Enumerating result took: 1,26ms
  750. [16:43:58] Number of elements fetched: 31465. Fetch took: 204,98ms. Enumerating result took: 1,27ms
  751. [16:43:58] Number of elements fetched: 31465. Fetch took: 195,27ms. Enumerating result took: 1,31ms
  752. [16:43:58] Number of elements fetched: 31465. Fetch took: 181,12ms. Enumerating result took: 1,31ms
  753. [16:43:58] Number of elements fetched: 31465. Fetch took: 190,03ms. Enumerating result took: 1,30ms
  754. [16:43:59] Number of elements fetched: 31465. Fetch took: 186,64ms. Enumerating result took: 1,32ms
  755. [16:43:59] Number of elements fetched: 31465. Fetch took: 198,77ms. Enumerating result took: 1,31ms
  756.  
  757. Single element fetches
  758. -------------------------
  759. [16:43:59] Number of elements fetched individually: 100. Total time: 366,64ms. Time per element: 3,67ms
  760. [16:44:00] Number of elements fetched individually: 100. Total time: 363,28ms. Time per element: 3,63ms
  761. [16:44:00] Number of elements fetched individually: 100. Total time: 367,13ms. Time per element: 3,67ms
  762. [16:44:01] Number of elements fetched individually: 100. Total time: 366,35ms. Time per element: 3,66ms
  763. [16:44:01] Number of elements fetched individually: 100. Total time: 369,57ms. Time per element: 3,70ms
  764. [16:44:02] Number of elements fetched individually: 100. Total time: 369,42ms. Time per element: 3,69ms
  765. [16:44:02] Number of elements fetched individually: 100. Total time: 366,06ms. Time per element: 3,66ms
  766. [16:44:03] Number of elements fetched individually: 100. Total time: 401,65ms. Time per element: 4,02ms
  767. [16:44:03] Number of elements fetched individually: 100. Total time: 367,27ms. Time per element: 3,67ms
  768. [16:44:04] Number of elements fetched individually: 100. Total time: 402,71ms. Time per element: 4,03ms
  769.  
  770. PetaPoco Fast v4.0.3. Change tracking: False. Caching: False.
  771. --------------------------------------------------------------------------------------------
  772. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  773. [16:44:04] Number of elements fetched: 31465. Fetch took: 174,33ms. Enumerating result took: 1,41ms
  774. [16:44:04] Number of elements fetched individually: 100. Total time: 91,61ms. Time per element: 0,92ms
  775.  
  776. Starting bench runs...
  777. Set fetches
  778. -------------------------
  779. [16:44:04] Number of elements fetched: 31465. Fetch took: 188,99ms. Enumerating result took: 1,23ms
  780. [16:44:05] Number of elements fetched: 31465. Fetch took: 189,47ms. Enumerating result took: 1,19ms
  781. [16:44:05] Number of elements fetched: 31465. Fetch took: 182,71ms. Enumerating result took: 1,23ms
  782. [16:44:05] Number of elements fetched: 31465. Fetch took: 171,42ms. Enumerating result took: 1,29ms
  783. [16:44:05] Number of elements fetched: 31465. Fetch took: 199,38ms. Enumerating result took: 1,27ms
  784. [16:44:06] Number of elements fetched: 31465. Fetch took: 174,61ms. Enumerating result took: 1,19ms
  785. [16:44:06] Number of elements fetched: 31465. Fetch took: 182,89ms. Enumerating result took: 1,26ms
  786. [16:44:06] Number of elements fetched: 31465. Fetch took: 176,69ms. Enumerating result took: 1,22ms
  787. [16:44:07] Number of elements fetched: 31465. Fetch took: 198,63ms. Enumerating result took: 1,25ms
  788. [16:44:07] Number of elements fetched: 31465. Fetch took: 173,32ms. Enumerating result took: 1,26ms
  789.  
  790. Single element fetches
  791. -------------------------
  792. [16:44:07] Number of elements fetched individually: 100. Total time: 72,43ms. Time per element: 0,72ms
  793. [16:44:07] Number of elements fetched individually: 100. Total time: 70,40ms. Time per element: 0,70ms
  794. [16:44:07] Number of elements fetched individually: 100. Total time: 72,11ms. Time per element: 0,72ms
  795. [16:44:07] Number of elements fetched individually: 100. Total time: 67,47ms. Time per element: 0,67ms
  796. [16:44:08] Number of elements fetched individually: 100. Total time: 70,13ms. Time per element: 0,70ms
  797. [16:44:08] Number of elements fetched individually: 100. Total time: 75,75ms. Time per element: 0,76ms
  798. [16:44:08] Number of elements fetched individually: 100. Total time: 73,18ms. Time per element: 0,73ms
  799. [16:44:08] Number of elements fetched individually: 100. Total time: 72,82ms. Time per element: 0,73ms
  800. [16:44:08] Number of elements fetched individually: 100. Total time: 68,16ms. Time per element: 0,68ms
  801. [16:44:08] Number of elements fetched individually: 100. Total time: 73,92ms. Time per element: 0,74ms
  802.  
  803. Entity Framework v6.0.0.0 (v6.1.40302.0). Change tracking: False. Caching: False.
  804. --------------------------------------------------------------------------------------------
  805. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  806. [16:44:09] Number of elements fetched: 31465. Fetch took: 583,89ms. Enumerating result took: 1,95ms
  807. [16:44:09] Number of elements fetched individually: 100. Total time: 118,74ms. Time per element: 1,19ms
  808.  
  809. Starting bench runs...
  810. Set fetches
  811. -------------------------
  812. [16:44:09] Number of elements fetched: 31465. Fetch took: 221,32ms. Enumerating result took: 2,83ms
  813. [16:44:10] Number of elements fetched: 31465. Fetch took: 237,38ms. Enumerating result took: 1,68ms
  814. [16:44:10] Number of elements fetched: 31465. Fetch took: 251,38ms. Enumerating result took: 2,76ms
  815. [16:44:10] Number of elements fetched: 31465. Fetch took: 240,43ms. Enumerating result took: 1,22ms
  816. [16:44:11] Number of elements fetched: 31465. Fetch took: 232,33ms. Enumerating result took: 1,64ms
  817. [16:44:11] Number of elements fetched: 31465. Fetch took: 257,85ms. Enumerating result took: 1,76ms
  818. [16:44:12] Number of elements fetched: 31465. Fetch took: 226,31ms. Enumerating result took: 1,79ms
  819. [16:44:12] Number of elements fetched: 31465. Fetch took: 230,90ms. Enumerating result took: 1,69ms
  820. [16:44:12] Number of elements fetched: 31465. Fetch took: 227,03ms. Enumerating result took: 1,59ms
  821. [16:44:13] Number of elements fetched: 31465. Fetch took: 234,64ms. Enumerating result took: 1,60ms
  822.  
  823. Single element fetches
  824. -------------------------
  825. [16:44:13] Number of elements fetched individually: 100. Total time: 91,35ms. Time per element: 0,91ms
  826. [16:44:13] Number of elements fetched individually: 100. Total time: 91,58ms. Time per element: 0,92ms
  827. [16:44:13] Number of elements fetched individually: 100. Total time: 92,36ms. Time per element: 0,92ms
  828. [16:44:13] Number of elements fetched individually: 100. Total time: 89,45ms. Time per element: 0,89ms
  829. [16:44:14] Number of elements fetched individually: 100. Total time: 92,77ms. Time per element: 0,93ms
  830. [16:44:14] Number of elements fetched individually: 100. Total time: 90,08ms. Time per element: 0,90ms
  831. [16:44:14] Number of elements fetched individually: 100. Total time: 93,07ms. Time per element: 0,93ms
  832. [16:44:14] Number of elements fetched individually: 100. Total time: 91,53ms. Time per element: 0,92ms
  833. [16:44:14] Number of elements fetched individually: 100. Total time: 89,53ms. Time per element: 0,90ms
  834. [16:44:15] Number of elements fetched individually: 100. Total time: 92,89ms. Time per element: 0,93ms
  835.  
  836. Entity Framework v6.0.0.0 (v6.1.40302.0). Change tracking: True. Caching: False.
  837. --------------------------------------------------------------------------------------------
  838. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  839. [16:44:17] Number of elements fetched: 31465. Fetch took: 2.488,98ms. Enumerating result took: 3,01ms
  840. [16:44:18] Number of elements fetched: 6768. Fetch took: 523,26ms. Enumerating result took: 0,00ms
  841. [16:44:18] Number of elements fetched individually: 100. Total time: 136,11ms. Time per element: 1,36ms
  842.  
  843. Starting bench runs...
  844. Set fetches
  845. -------------------------
  846. [16:44:21] Number of elements fetched: 31465. Fetch took: 2.801,62ms. Enumerating result took: 2,96ms
  847. [16:44:23] Number of elements fetched: 31465. Fetch took: 2.518,41ms. Enumerating result took: 2,83ms
  848. [16:44:26] Number of elements fetched: 31465. Fetch took: 2.628,89ms. Enumerating result took: 2,93ms
  849. [16:44:29] Number of elements fetched: 31465. Fetch took: 2.437,53ms. Enumerating result took: 3,04ms
  850. [16:44:31] Number of elements fetched: 31465. Fetch took: 2.554,86ms. Enumerating result took: 2,87ms
  851. [16:44:34] Number of elements fetched: 31465. Fetch took: 2.497,76ms. Enumerating result took: 3,80ms
  852. [16:44:37] Number of elements fetched: 31465. Fetch took: 2.575,81ms. Enumerating result took: 2,90ms
  853. [16:44:39] Number of elements fetched: 31465. Fetch took: 2.398,37ms. Enumerating result took: 2,77ms
  854. [16:44:42] Number of elements fetched: 31465. Fetch took: 2.654,69ms. Enumerating result took: 3,14ms
  855. [16:44:45] Number of elements fetched: 31465. Fetch took: 2.410,91ms. Enumerating result took: 2,85ms
  856.  
  857. Single element fetches
  858. -------------------------
  859. [16:44:45] Number of elements fetched individually: 100. Total time: 102,43ms. Time per element: 1,02ms
  860. [16:44:45] Number of elements fetched individually: 100. Total time: 100,01ms. Time per element: 1,00ms
  861. [16:44:45] Number of elements fetched individually: 100. Total time: 98,84ms. Time per element: 0,99ms
  862. [16:44:46] Number of elements fetched individually: 100. Total time: 97,60ms. Time per element: 0,98ms
  863. [16:44:46] Number of elements fetched individually: 100. Total time: 100,68ms. Time per element: 1,01ms
  864. [16:44:46] Number of elements fetched individually: 100. Total time: 99,00ms. Time per element: 0,99ms
  865. [16:44:46] Number of elements fetched individually: 100. Total time: 98,61ms. Time per element: 0,99ms
  866. [16:44:46] Number of elements fetched individually: 100. Total time: 96,97ms. Time per element: 0,97ms
  867. [16:44:47] Number of elements fetched individually: 100. Total time: 100,63ms. Time per element: 1,01ms
  868. [16:44:47] Number of elements fetched individually: 100. Total time: 98,99ms. Time per element: 0,99ms
  869.  
  870. Eager Load fetches
  871. -------------------------
  872. [16:44:47] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 372,56ms.
  873. [16:44:48] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 384,40ms.
  874. [16:44:48] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 380,62ms.
  875. [16:44:49] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 405,34ms.
  876. [16:44:49] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 387,18ms.
  877. [16:44:50] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 380,00ms.
  878. [16:44:50] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 374,92ms.
  879. [16:44:51] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 372,40ms.
  880. [16:44:51] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 376,89ms.
  881. [16:44:52] Number of elements fetched: 6768 (4768 + 1000 + 1000). Fetch took: 379,05ms.
  882.  
  883. Oak.DynamicDb using dynamic Dto class. Change tracking: False. Caching: False.
  884. --------------------------------------------------------------------------------------------
  885. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  886. [16:44:53] Number of elements fetched: 31465. Fetch took: 624,27ms. Enumerating result took: 119,63ms
  887. [16:44:53] Number of elements fetched individually: 100. Total time: 66,14ms. Time per element: 0,66ms
  888.  
  889. Starting bench runs...
  890. Set fetches
  891. -------------------------
  892. [16:44:54] Number of elements fetched: 31465. Fetch took: 698,48ms. Enumerating result took: 120,30ms
  893. [16:44:55] Number of elements fetched: 31465. Fetch took: 590,48ms. Enumerating result took: 95,42ms
  894. [16:44:55] Number of elements fetched: 31465. Fetch took: 612,57ms. Enumerating result took: 143,99ms
  895. [16:44:56] Number of elements fetched: 31465. Fetch took: 623,96ms. Enumerating result took: 176,83ms
  896. [16:44:57] Number of elements fetched: 31465. Fetch took: 563,35ms. Enumerating result took: 100,07ms
  897. [16:44:58] Number of elements fetched: 31465. Fetch took: 566,13ms. Enumerating result took: 101,19ms
  898. [16:44:59] Number of elements fetched: 31465. Fetch took: 580,43ms. Enumerating result took: 169,86ms
  899. [16:45:00] Number of elements fetched: 31465. Fetch took: 581,08ms. Enumerating result took: 99,33ms
  900. [16:45:01] Number of elements fetched: 31465. Fetch took: 583,04ms. Enumerating result took: 100,27ms
  901. [16:45:02] Number of elements fetched: 31465. Fetch took: 578,86ms. Enumerating result took: 188,17ms
  902.  
  903. Single element fetches
  904. -------------------------
  905. [16:45:02] Number of elements fetched individually: 100. Total time: 56,14ms. Time per element: 0,56ms
  906. [16:45:02] Number of elements fetched individually: 100. Total time: 58,06ms. Time per element: 0,58ms
  907. [16:45:02] Number of elements fetched individually: 100. Total time: 61,00ms. Time per element: 0,61ms
  908. [16:45:02] Number of elements fetched individually: 100. Total time: 61,78ms. Time per element: 0,62ms
  909. [16:45:03] Number of elements fetched individually: 100. Total time: 62,78ms. Time per element: 0,63ms
  910. [16:45:03] Number of elements fetched individually: 100. Total time: 63,24ms. Time per element: 0,63ms
  911. [16:45:03] Number of elements fetched individually: 100. Total time: 58,90ms. Time per element: 0,59ms
  912. [16:45:03] Number of elements fetched individually: 100. Total time: 60,66ms. Time per element: 0,61ms
  913. [16:45:03] Number of elements fetched individually: 100. Total time: 60,24ms. Time per element: 0,60ms
  914. [16:45:03] Number of elements fetched individually: 100. Total time: 63,18ms. Time per element: 0,63ms
  915.  
  916. Oak.DynamicDb using typed dynamic class. Change tracking: True. Caching: False.
  917. --------------------------------------------------------------------------------------------
  918. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  919. [16:45:05] Number of elements fetched: 31465. Fetch took: 602,76ms. Enumerating result took: 806,57ms
  920. [16:45:05] Number of elements fetched individually: 100. Total time: 63,95ms. Time per element: 0,64ms
  921.  
  922. Starting bench runs...
  923. Set fetches
  924. -------------------------
  925. [16:45:06] Number of elements fetched: 31465. Fetch took: 569,28ms. Enumerating result took: 811,33ms
  926. [16:45:08] Number of elements fetched: 31465. Fetch took: 569,94ms. Enumerating result took: 736,59ms
  927. [16:45:09] Number of elements fetched: 31465. Fetch took: 557,91ms. Enumerating result took: 768,19ms
  928. [16:45:11] Number of elements fetched: 31465. Fetch took: 604,92ms. Enumerating result took: 686,85ms
  929. [16:45:12] Number of elements fetched: 31465. Fetch took: 649,01ms. Enumerating result took: 674,27ms
  930. [16:45:14] Number of elements fetched: 31465. Fetch took: 568,63ms. Enumerating result took: 729,33ms
  931. [16:45:15] Number of elements fetched: 31465. Fetch took: 561,10ms. Enumerating result took: 765,47ms
  932. [16:45:17] Number of elements fetched: 31465. Fetch took: 564,88ms. Enumerating result took: 669,71ms
  933. [16:45:18] Number of elements fetched: 31465. Fetch took: 592,57ms. Enumerating result took: 750,40ms
  934. [16:45:20] Number of elements fetched: 31465. Fetch took: 625,68ms. Enumerating result took: 752,29ms
  935.  
  936. Single element fetches
  937. -------------------------
  938. [16:45:20] Number of elements fetched individually: 100. Total time: 65,71ms. Time per element: 0,66ms
  939. [16:45:20] Number of elements fetched individually: 100. Total time: 59,98ms. Time per element: 0,60ms
  940. [16:45:20] Number of elements fetched individually: 100. Total time: 59,07ms. Time per element: 0,59ms
  941. [16:45:20] Number of elements fetched individually: 100. Total time: 60,74ms. Time per element: 0,61ms
  942. [16:45:21] Number of elements fetched individually: 100. Total time: 59,86ms. Time per element: 0,60ms
  943. [16:45:21] Number of elements fetched individually: 100. Total time: 59,95ms. Time per element: 0,60ms
  944. [16:45:21] Number of elements fetched individually: 100. Total time: 64,10ms. Time per element: 0,64ms
  945. [16:45:21] Number of elements fetched individually: 100. Total time: 62,83ms. Time per element: 0,63ms
  946. [16:45:21] Number of elements fetched individually: 100. Total time: 60,65ms. Time per element: 0,61ms
  947. [16:45:21] Number of elements fetched individually: 100. Total time: 59,58ms. Time per element: 0,60ms
  948.  
  949. DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
  950. --------------------------------------------------------------------------------------------
  951. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  952. [16:45:22] Number of elements fetched: 31465. Fetch took: 224,21ms. Enumerating result took: 31,11ms
  953. [16:45:22] Number of elements fetched individually: 100. Total time: 60,76ms. Time per element: 0,61ms
  954.  
  955. Starting bench runs...
  956. Set fetches
  957. -------------------------
  958. [16:45:22] Number of elements fetched: 31465. Fetch took: 236,30ms. Enumerating result took: 29,49ms
  959. [16:45:22] Number of elements fetched: 31465. Fetch took: 235,24ms. Enumerating result took: 29,59ms
  960. [16:45:23] Number of elements fetched: 31465. Fetch took: 229,89ms. Enumerating result took: 30,80ms
  961. [16:45:23] Number of elements fetched: 31465. Fetch took: 236,72ms. Enumerating result took: 30,24ms
  962. [16:45:24] Number of elements fetched: 31465. Fetch took: 238,21ms. Enumerating result took: 30,61ms
  963. [16:45:24] Number of elements fetched: 31465. Fetch took: 231,05ms. Enumerating result took: 30,12ms
  964. [16:45:24] Number of elements fetched: 31465. Fetch took: 245,05ms. Enumerating result took: 31,91ms
  965. [16:45:25] Number of elements fetched: 31465. Fetch took: 238,85ms. Enumerating result took: 29,68ms
  966. [16:45:25] Number of elements fetched: 31465. Fetch took: 258,73ms. Enumerating result took: 32,83ms
  967. [16:45:25] Number of elements fetched: 31465. Fetch took: 234,56ms. Enumerating result took: 30,55ms
  968.  
  969. Single element fetches
  970. -------------------------
  971. [16:45:26] Number of elements fetched individually: 100. Total time: 59,60ms. Time per element: 0,60ms
  972. [16:45:26] Number of elements fetched individually: 100. Total time: 56,22ms. Time per element: 0,56ms
  973. [16:45:26] Number of elements fetched individually: 100. Total time: 61,80ms. Time per element: 0,62ms
  974. [16:45:26] Number of elements fetched individually: 100. Total time: 64,73ms. Time per element: 0,65ms
  975. [16:45:26] Number of elements fetched individually: 100. Total time: 59,58ms. Time per element: 0,60ms
  976. [16:45:26] Number of elements fetched individually: 100. Total time: 59,47ms. Time per element: 0,59ms
  977. [16:45:27] Number of elements fetched individually: 100. Total time: 59,40ms. Time per element: 0,59ms
  978. [16:45:27] Number of elements fetched individually: 100. Total time: 59,15ms. Time per element: 0,59ms
  979. [16:45:27] Number of elements fetched individually: 100. Total time: 59,71ms. Time per element: 0,60ms
  980. [16:45:27] Number of elements fetched individually: 100. Total time: 58,59ms. Time per element: 0,59ms
  981.  
  982. Massive using dynamic class. Change tracking: False. Caching: False.
  983. --------------------------------------------------------------------------------------------
  984. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  985. [16:45:28] Number of elements fetched: 31465. Fetch took: 514,19ms. Enumerating result took: 21,47ms
  986. [16:45:28] Number of elements fetched individually: 100. Total time: 59,40ms. Time per element: 0,59ms
  987.  
  988. Starting bench runs...
  989. Set fetches
  990. -------------------------
  991. [16:45:28] Number of elements fetched: 31465. Fetch took: 524,70ms. Enumerating result took: 21,51ms
  992. [16:45:29] Number of elements fetched: 31465. Fetch took: 520,74ms. Enumerating result took: 20,86ms
  993. [16:45:30] Number of elements fetched: 31465. Fetch took: 509,48ms. Enumerating result took: 19,55ms
  994. [16:45:30] Number of elements fetched: 31465. Fetch took: 496,77ms. Enumerating result took: 20,70ms
  995. [16:45:31] Number of elements fetched: 31465. Fetch took: 515,93ms. Enumerating result took: 19,34ms
  996. [16:45:32] Number of elements fetched: 31465. Fetch took: 525,61ms. Enumerating result took: 24,72ms
  997. [16:45:33] Number of elements fetched: 31465. Fetch took: 521,58ms. Enumerating result took: 24,21ms
  998. [16:45:33] Number of elements fetched: 31465. Fetch took: 508,08ms. Enumerating result took: 20,30ms
  999. [16:45:34] Number of elements fetched: 31465. Fetch took: 542,21ms. Enumerating result took: 20,57ms
  1000. [16:45:35] Number of elements fetched: 31465. Fetch took: 506,30ms. Enumerating result took: 21,46ms
  1001.  
  1002. Single element fetches
  1003. -------------------------
  1004. [16:45:35] Number of elements fetched individually: 100. Total time: 54,02ms. Time per element: 0,54ms
  1005. [16:45:35] Number of elements fetched individually: 100. Total time: 52,74ms. Time per element: 0,53ms
  1006. [16:45:35] Number of elements fetched individually: 100. Total time: 56,26ms. Time per element: 0,56ms
  1007. [16:45:35] Number of elements fetched individually: 100. Total time: 56,85ms. Time per element: 0,57ms
  1008. [16:45:35] Number of elements fetched individually: 100. Total time: 56,11ms. Time per element: 0,56ms
  1009. [16:45:36] Number of elements fetched individually: 100. Total time: 57,12ms. Time per element: 0,57ms
  1010. [16:45:36] Number of elements fetched individually: 100. Total time: 55,30ms. Time per element: 0,55ms
  1011. [16:45:36] Number of elements fetched individually: 100. Total time: 55,92ms. Time per element: 0,56ms
  1012. [16:45:36] Number of elements fetched individually: 100. Total time: 56,54ms. Time per element: 0,57ms
  1013. [16:45:36] Number of elements fetched individually: 100. Total time: 55,13ms. Time per element: 0,55ms
  1014.  
  1015. ServiceStack OrmLite v4.0.56.0 (v4.0.56.0). Change tracking: False. Caching: False.
  1016. --------------------------------------------------------------------------------------------
  1017. First one warm-up run of each bench type to initialize constructs. Results will not be collected.
  1018. [16:45:37] Number of elements fetched: 31465. Fetch took: 258,00ms. Enumerating result took: 1,36ms
  1019. [16:45:37] Number of elements fetched individually: 100. Total time: 82,57ms. Time per element: 0,83ms
  1020.  
  1021. Starting bench runs...
  1022. Set fetches
  1023. -------------------------
  1024. [16:45:37] Number of elements fetched: 31465. Fetch took: 197,95ms. Enumerating result took: 1,30ms
  1025. [16:45:37] Number of elements fetched: 31465. Fetch took: 197,87ms. Enumerating result took: 1,22ms
  1026. [16:45:38] Number of elements fetched: 31465. Fetch took: 181,75ms. Enumerating result took: 1,39ms
  1027. [16:45:38] Number of elements fetched: 31465. Fetch took: 176,04ms. Enumerating result took: 1,44ms
  1028. [16:45:38] Number of elements fetched: 31465. Fetch took: 194,60ms. Enumerating result took: 1,23ms
  1029. [16:45:38] Number of elements fetched: 31465. Fetch took: 178,20ms. Enumerating result took: 1,24ms
  1030. [16:45:39] Number of elements fetched: 31465. Fetch took: 190,10ms. Enumerating result took: 0,07ms
  1031. [16:45:39] Number of elements fetched: 31465. Fetch took: 177,05ms. Enumerating result took: 1,41ms
  1032. [16:45:39] Number of elements fetched: 31465. Fetch took: 187,05ms. Enumerating result took: 1,29ms
  1033. [16:45:40] Number of elements fetched: 31465. Fetch took: 177,30ms. Enumerating result took: 1,31ms
  1034.  
  1035. Single element fetches
  1036. -------------------------
  1037. [16:45:40] Number of elements fetched individually: 100. Total time: 60,59ms. Time per element: 0,61ms
  1038. [16:45:40] Number of elements fetched individually: 100. Total time: 64,90ms. Time per element: 0,65ms
  1039. [16:45:40] Number of elements fetched individually: 100. Total time: 64,72ms. Time per element: 0,65ms
  1040. [16:45:40] Number of elements fetched individually: 100. Total time: 60,94ms. Time per element: 0,61ms
  1041. [16:45:40] Number of elements fetched individually: 100. Total time: 59,28ms. Time per element: 0,59ms
  1042. [16:45:41] Number of elements fetched individually: 100. Total time: 61,61ms. Time per element: 0,62ms
  1043. [16:45:41] Number of elements fetched individually: 100. Total time: 63,26ms. Time per element: 0,63ms
  1044. [16:45:41] Number of elements fetched individually: 100. Total time: 66,34ms. Time per element: 0,66ms
  1045. [16:45:41] Number of elements fetched individually: 100. Total time: 61,86ms. Time per element: 0,62ms
  1046. [16:45:41] Number of elements fetched individually: 100. Total time: 63,70ms. Time per element: 0,64ms
  1047.  
  1048. Complete. Press enter to exit.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!