API tools faq
paste
Guest User

Raw .NET Data Access / ORM Fetch benchmarks 05-nov-2015

a guest
Nov 5th, 2015
707
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 104.73 KB | None | 0 0
raw download clone embed print report
  1. client HW: VMWare VM, Windows 8.1 32bit 4GB 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. +-------------------------------------------------------------------------------------------
  8. | Raw Data Access / ORM Benchmarks.
  9. | Code available at : https://github.com/FransBouma/RawDataAccessBencher
  10. | Benchmarks run on : donderdag 5 november 2015 12:43:34
  11. | Registered benchmarks :
  12. | Massive using dynamic class. Change tracking: False. Caching: False.
  13. | Handcoded materializer using DbDataReader. Change tracking: False. Caching: False.
  14. | Handcoded materializer using DbDataReader (GetValues(array), boxing). Change tracking: False. Caching: False.
  15. | Dapper 1.40.0.0. Change tracking: False. Caching: False.
  16. | Linq to Sql v4.0.0.0 (v4.6.81.0). Change tracking: False. Caching: False.
  17. | Entity Framework v6.0.0.0 (v6.1.40302.0). Change tracking: False. Caching: False.
  18. | ServiceStack OrmLite v4.0.46.0 (v4.0.46.0). Change tracking: False. Caching: False.
  19. | PetaPoco v4.0.3. Change tracking: False. Caching: False.
  20. | PetaPoco Fast v4.0.3. Change tracking: False. Caching: False.
  21. | DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
  22. | Linq to Sql v4.0.0.0 (v4.6.81.0). Change tracking: True. Caching: False.
  23. | LLBLGen Pro v4.2.0.0 (v4.2.15.1015), Poco typed view with Linq. Change tracking: False. Caching: False.
  24. | LLBLGen Pro v4.2.0.0 (v4.2.15.1015), Poco typed view with QuerySpec. Change tracking: False. Caching: False.
  25. | LLBLGen Pro v4.2.0.0 (v4.2.15.1015), typed view. Change tracking: False. Caching: False.
  26. | LLBLGen Pro v4.2.0.0 (v4.2.15.1015). Change tracking: True. Caching: True.
  27. | LLBLGen Pro v4.2.0.0 (v4.2.15.1015). Change tracking: True. Caching: False.
  28. | Entity Framework v6.0.0.0 (v6.1.40302.0). Change tracking: True. Caching: False.
  29. | Oak.DynamicDb using dynamic Dto class. Change tracking: False. Caching: False.
  30. | Oak.DynamicDb using typed dynamic class. Change tracking: True. Caching: False.
  31. | NHibernate v4.0.0.4000 (v4.0.4.4000). Change tracking: True. Caching: False.
  32. | Run set benchmarks : True
  33. | Run individual fetch benchmarks: True
  34. | Number of set fetches : 25
  35. | Number of individual keys : 100
  36. | Release build : True
  37. | Client OS : Microsoft Windows NT 6.2.9200.0 (32bit)
  38. | Bencher runs as 64bit : False
  39. | CLR version : 4.0.30319.42000
  40. | Number of CPUs : 4
  41. | Server used : nerd.sd.local
  42. | Catalog used : AdventureWorks
  43. | SQL Server version used : 11.00.5058
  44. +-------------------------------------------------------------------------------------------
  45. Results per framework. Values are given as: 'mean (standard deviation)'
  46. ==============================================================================
  47. Non-change tracking fetches, set fetches (25 runs), no caching
  48. ------------------------------------------------------------------------------
  49. Handcoded materializer using DbDataReader : 121,28ms (6,96ms) Enum: 0,88ms (0,32ms)
  50. Handcoded materializer using DbDataReader (GetValues(array), boxing) : 129,80ms (6,30ms) Enum: 1,00ms (0,00ms)
  51. PetaPoco Fast v4.0.3 : 140,68ms (5,70ms) Enum: 1,00ms (0,00ms)
  52. PetaPoco v4.0.3 : 153,20ms (6,47ms) Enum: 1,04ms (0,20ms)
  53. Dapper 1.40.0.0 : 175,48ms (5,58ms) Enum: 1,00ms (0,00ms)
  54. Entity Framework v6.0.0.0 (v6.1.40302.0) : 179,84ms (10,36ms) Enum: 1,00ms (0,00ms)
  55. Linq to Sql v4.0.0.0 (v4.6.81.0) : 197,16ms (10,69ms) Enum: 1,00ms (0,00ms)
  56. LLBLGen Pro v4.2.0.0 (v4.2.15.1015), Poco typed view with QuerySpec : 239,28ms (9,05ms) Enum: 0,60ms (0,49ms)
  57. LLBLGen Pro v4.2.0.0 (v4.2.15.1015), Poco typed view with Linq : 270,44ms (10,61ms) Enum: 0,32ms (0,47ms)
  58. ServiceStack OrmLite v4.0.46.0 (v4.0.46.0) : 313,92ms (9,29ms) Enum: 1,04ms (0,20ms)
  59. LLBLGen Pro v4.2.0.0 (v4.2.15.1015), typed view : 317,92ms (13,32ms) Enum: 2,72ms (1,66ms)
  60. Massive using dynamic class : 462,20ms (18,32ms) Enum: 11,92ms (4,84ms)
  61. Oak.DynamicDb using dynamic Dto class : 539,36ms (16,47ms) Enum: 84,72ms (3,68ms)
  62.  
  63. Change tracking fetches, set fetches (25 runs), no caching
  64. ------------------------------------------------------------------------------
  65. DataTable, using DbDataAdapter : 196,32ms (8,49ms) Enum: 27,12ms (0,52ms)
  66. Linq to Sql v4.0.0.0 (v4.6.81.0) : 249,60ms (8,09ms) Enum: 1,04ms (0,20ms)
  67. LLBLGen Pro v4.2.0.0 (v4.2.15.1015) : 285,68ms (18,90ms) Enum: 3,04ms (0,20ms)
  68. Oak.DynamicDb using typed dynamic class : 528,20ms (26,71ms) Enum: 622,52ms (16,44ms)
  69. NHibernate v4.0.0.4000 (v4.0.4.4000) : 1.831,04ms (26,89ms) Enum: 1,00ms (0,00ms)
  70. Entity Framework v6.0.0.0 (v6.1.40302.0) : 1.966,56ms (62,71ms) Enum: 2,00ms (0,00ms)
  71.  
  72. Non-change tracking individual fetches (100 elements, 25 runs), no caching
  73. ------------------------------------------------------------------------------
  74. Handcoded materializer using DbDataReader (GetValues(array), boxing) : 0,51ms (0,03ms) per individual fetch
  75. Handcoded materializer using DbDataReader : 0,52ms (0,01ms) per individual fetch
  76. Massive using dynamic class : 0,53ms (0,02ms) per individual fetch
  77. Oak.DynamicDb using dynamic Dto class : 0,56ms (0,02ms) per individual fetch
  78. ServiceStack OrmLite v4.0.46.0 (v4.0.46.0) : 0,59ms (0,03ms) per individual fetch
  79. LLBLGen Pro v4.2.0.0 (v4.2.15.1015), Poco typed view with QuerySpec : 0,68ms (0,04ms) per individual fetch
  80. PetaPoco Fast v4.0.3 : 0,70ms (0,02ms) per individual fetch
  81. LLBLGen Pro v4.2.0.0 (v4.2.15.1015), typed view : 0,73ms (0,02ms) per individual fetch
  82. Entity Framework v6.0.0.0 (v6.1.40302.0) : 0,82ms (0,07ms) per individual fetch
  83. Dapper 1.40.0.0 : 1,07ms (0,07ms) per individual fetch
  84. LLBLGen Pro v4.2.0.0 (v4.2.15.1015), Poco typed view with Linq : 1,40ms (0,07ms) per individual fetch
  85. Linq to Sql v4.0.0.0 (v4.6.81.0) : 1,45ms (0,04ms) per individual fetch
  86. PetaPoco v4.0.3 : 2,06ms (0,04ms) per individual fetch
  87.  
  88. Change tracking individual fetches (100 elements, 25 runs), no caching
  89. ------------------------------------------------------------------------------
  90. DataTable, using DbDataAdapter : 0,57ms (0,02ms) per individual fetch
  91. Oak.DynamicDb using typed dynamic class : 0,57ms (0,02ms) per individual fetch
  92. LLBLGen Pro v4.2.0.0 (v4.2.15.1015) : 0,61ms (0,05ms) per individual fetch
  93. NHibernate v4.0.0.4000 (v4.0.4.4000) : 0,65ms (0,03ms) per individual fetch
  94. Entity Framework v6.0.0.0 (v6.1.40302.0) : 0,88ms (0,02ms) per individual fetch
  95. Linq to Sql v4.0.0.0 (v4.6.81.0) : 1,49ms (0,02ms) per individual fetch
  96.  
  97. Change tracking fetches, set fetches (25 runs), caching
  98. ------------------------------------------------------------------------------
  99. LLBLGen Pro v4.2.0.0 (v4.2.15.1015) : 80,60ms (12,95ms) Enum: 3,52ms (2,35ms)
  100.  
  101. Change tracking individual fetches (100 elements, 25 runs), caching
  102. ------------------------------------------------------------------------------
  103. LLBLGen Pro v4.2.0.0 (v4.2.15.1015) : 0,15ms (0,14ms) per individual fetch
  104.  
  105.  
  106. Raw results:
  107.  
  108.  
  109. Warming up DB, DB client code and CLR
  110. ====================================================================
  111.  
  112. DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
  113. --------------------------------------------------------------------------------------------
  114. Number of elements fetched: 31465. Fetch took: 498ms. Enumerating result took: 27ms
  115. Number of elements fetched: 31465. Fetch took: 197ms. Enumerating result took: 26ms
  116. Number of elements fetched: 31465. Fetch took: 221ms. Enumerating result took: 27ms
  117. Number of elements fetched: 31465. Fetch took: 220ms. Enumerating result took: 26ms
  118. Number of elements fetched: 31465. Fetch took: 197ms. Enumerating result took: 34ms
  119. Number of elements fetched: 31465. Fetch took: 212ms. Enumerating result took: 26ms
  120. Number of elements fetched: 31465. Fetch took: 207ms. Enumerating result took: 26ms
  121. Number of elements fetched: 31465. Fetch took: 197ms. Enumerating result took: 26ms
  122. Number of elements fetched: 31465. Fetch took: 217ms. Enumerating result took: 27ms
  123. Number of elements fetched: 31465. Fetch took: 206ms. Enumerating result took: 26ms
  124. Number of elements fetched: 31465. Fetch took: 203ms. Enumerating result took: 26ms
  125. Number of elements fetched: 31465. Fetch took: 189ms. Enumerating result took: 26ms
  126. Number of elements fetched: 31465. Fetch took: 230ms. Enumerating result took: 26ms
  127. Number of elements fetched: 31465. Fetch took: 192ms. Enumerating result took: 27ms
  128. Number of elements fetched: 31465. Fetch took: 206ms. Enumerating result took: 26ms
  129. Number of elements fetched: 31465. Fetch took: 191ms. Enumerating result took: 27ms
  130. Number of elements fetched: 31465. Fetch took: 212ms. Enumerating result took: 26ms
  131. Number of elements fetched: 31465. Fetch took: 194ms. Enumerating result took: 27ms
  132. Number of elements fetched: 31465. Fetch took: 238ms. Enumerating result took: 26ms
  133. Number of elements fetched: 31465. Fetch took: 216ms. Enumerating result took: 27ms
  134. Number of elements fetched: 31465. Fetch took: 224ms. Enumerating result took: 26ms
  135. Number of elements fetched: 31465. Fetch took: 189ms. Enumerating result took: 12ms
  136. Number of elements fetched: 31465. Fetch took: 195ms. Enumerating result took: 27ms
  137. Number of elements fetched: 31465. Fetch took: 197ms. Enumerating result took: 27ms
  138. Number of elements fetched: 31465. Fetch took: 228ms. Enumerating result took: 27ms
  139.  
  140. Starting benchmarks.
  141. ====================================================================
  142.  
  143. Massive using dynamic class. Change tracking: False. Caching: False.
  144. --------------------------------------------------------------------------------------------
  145. First one warm-up run to initialize constructs. Results will not be collected.
  146. Number of elements fetched: 31465. Fetch took: 478ms. Enumerating result took: 17ms
  147. Starting bench runs...
  148. Set fetches
  149. -------------------------
  150. Number of elements fetched: 31465. Fetch took: 486ms. Enumerating result took: 9ms
  151. Number of elements fetched: 31465. Fetch took: 454ms. Enumerating result took: 7ms
  152. Number of elements fetched: 31465. Fetch took: 444ms. Enumerating result took: 9ms
  153. Number of elements fetched: 31465. Fetch took: 452ms. Enumerating result took: 19ms
  154. Number of elements fetched: 31465. Fetch took: 439ms. Enumerating result took: 17ms
  155. Number of elements fetched: 31465. Fetch took: 462ms. Enumerating result took: 9ms
  156. Number of elements fetched: 31465. Fetch took: 460ms. Enumerating result took: 19ms
  157. Number of elements fetched: 31465. Fetch took: 451ms. Enumerating result took: 19ms
  158. Number of elements fetched: 31465. Fetch took: 477ms. Enumerating result took: 9ms
  159. Number of elements fetched: 31465. Fetch took: 510ms. Enumerating result took: 10ms
  160. Number of elements fetched: 31465. Fetch took: 502ms. Enumerating result took: 8ms
  161. Number of elements fetched: 31465. Fetch took: 468ms. Enumerating result took: 20ms
  162. Number of elements fetched: 31465. Fetch took: 448ms. Enumerating result took: 9ms
  163. Number of elements fetched: 31465. Fetch took: 481ms. Enumerating result took: 9ms
  164. Number of elements fetched: 31465. Fetch took: 468ms. Enumerating result took: 20ms
  165. Number of elements fetched: 31465. Fetch took: 455ms. Enumerating result took: 9ms
  166. Number of elements fetched: 31465. Fetch took: 455ms. Enumerating result took: 10ms
  167. Number of elements fetched: 31465. Fetch took: 470ms. Enumerating result took: 8ms
  168. Number of elements fetched: 31465. Fetch took: 478ms. Enumerating result took: 19ms
  169. Number of elements fetched: 31465. Fetch took: 451ms. Enumerating result took: 8ms
  170. Number of elements fetched: 31465. Fetch took: 445ms. Enumerating result took: 8ms
  171. Number of elements fetched: 31465. Fetch took: 465ms. Enumerating result took: 8ms
  172. Number of elements fetched: 31465. Fetch took: 435ms. Enumerating result took: 18ms
  173. Number of elements fetched: 31465. Fetch took: 454ms. Enumerating result took: 8ms
  174. Number of elements fetched: 31465. Fetch took: 445ms. Enumerating result took: 9ms
  175. Single element fetches
  176. -------------------------
  177. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  178. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  179. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  180. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  181. Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
  182. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  183. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  184. Number of elements fetched individually: 100. Total time: 52ms. Time per element: 0,52ms
  185. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  186. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  187. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  188. Number of elements fetched individually: 100. Total time: 51ms. Time per element: 0,51ms
  189. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  190. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  191. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  192. Number of elements fetched individually: 100. Total time: 52ms. Time per element: 0,52ms
  193. Number of elements fetched individually: 100. Total time: 50ms. Time per element: 0,5ms
  194. Number of elements fetched individually: 100. Total time: 51ms. Time per element: 0,51ms
  195. Number of elements fetched individually: 100. Total time: 51ms. Time per element: 0,51ms
  196. Number of elements fetched individually: 100. Total time: 50ms. Time per element: 0,5ms
  197. Number of elements fetched individually: 100. Total time: 51ms. Time per element: 0,51ms
  198. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  199. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  200. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  201. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  202.  
  203. Handcoded materializer using DbDataReader. Change tracking: False. Caching: False.
  204. --------------------------------------------------------------------------------------------
  205. First one warm-up run to initialize constructs. Results will not be collected.
  206. Number of elements fetched: 31465. Fetch took: 126ms. Enumerating result took: 1ms
  207. Starting bench runs...
  208. Set fetches
  209. -------------------------
  210. Number of elements fetched: 31465. Fetch took: 137ms. Enumerating result took: 0ms
  211. Number of elements fetched: 31465. Fetch took: 113ms. Enumerating result took: 1ms
  212. Number of elements fetched: 31465. Fetch took: 126ms. Enumerating result took: 1ms
  213. Number of elements fetched: 31465. Fetch took: 137ms. Enumerating result took: 1ms
  214. Number of elements fetched: 31465. Fetch took: 130ms. Enumerating result took: 1ms
  215. Number of elements fetched: 31465. Fetch took: 125ms. Enumerating result took: 1ms
  216. Number of elements fetched: 31465. Fetch took: 113ms. Enumerating result took: 1ms
  217. Number of elements fetched: 31465. Fetch took: 121ms. Enumerating result took: 1ms
  218. Number of elements fetched: 31465. Fetch took: 115ms. Enumerating result took: 1ms
  219. Number of elements fetched: 31465. Fetch took: 122ms. Enumerating result took: 1ms
  220. Number of elements fetched: 31465. Fetch took: 113ms. Enumerating result took: 1ms
  221. Number of elements fetched: 31465. Fetch took: 123ms. Enumerating result took: 1ms
  222. Number of elements fetched: 31465. Fetch took: 112ms. Enumerating result took: 1ms
  223. Number of elements fetched: 31465. Fetch took: 122ms. Enumerating result took: 1ms
  224. Number of elements fetched: 31465. Fetch took: 114ms. Enumerating result took: 1ms
  225. Number of elements fetched: 31465. Fetch took: 120ms. Enumerating result took: 1ms
  226. Number of elements fetched: 31465. Fetch took: 122ms. Enumerating result took: 0ms
  227. Number of elements fetched: 31465. Fetch took: 113ms. Enumerating result took: 1ms
  228. Number of elements fetched: 31465. Fetch took: 120ms. Enumerating result took: 0ms
  229. Number of elements fetched: 31465. Fetch took: 130ms. Enumerating result took: 1ms
  230. Number of elements fetched: 31465. Fetch took: 121ms. Enumerating result took: 1ms
  231. Number of elements fetched: 31465. Fetch took: 114ms. Enumerating result took: 1ms
  232. Number of elements fetched: 31465. Fetch took: 124ms. Enumerating result took: 1ms
  233. Number of elements fetched: 31465. Fetch took: 121ms. Enumerating result took: 1ms
  234. Number of elements fetched: 31465. Fetch took: 124ms. Enumerating result took: 1ms
  235. Single element fetches
  236. -------------------------
  237. Number of elements fetched individually: 100. Total time: 51ms. Time per element: 0,51ms
  238. Number of elements fetched individually: 100. Total time: 51ms. Time per element: 0,51ms
  239. Number of elements fetched individually: 100. Total time: 50ms. Time per element: 0,5ms
  240. Number of elements fetched individually: 100. Total time: 52ms. Time per element: 0,52ms
  241. Number of elements fetched individually: 100. Total time: 51ms. Time per element: 0,51ms
  242. Number of elements fetched individually: 100. Total time: 50ms. Time per element: 0,5ms
  243. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  244. Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
  245. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  246. Number of elements fetched individually: 100. Total time: 52ms. Time per element: 0,52ms
  247. Number of elements fetched individually: 100. Total time: 52ms. Time per element: 0,52ms
  248. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  249. Number of elements fetched individually: 100. Total time: 52ms. Time per element: 0,52ms
  250. Number of elements fetched individually: 100. Total time: 51ms. Time per element: 0,51ms
  251. Number of elements fetched individually: 100. Total time: 51ms. Time per element: 0,51ms
  252. Number of elements fetched individually: 100. Total time: 51ms. Time per element: 0,51ms
  253. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  254. Number of elements fetched individually: 100. Total time: 51ms. Time per element: 0,51ms
  255. Number of elements fetched individually: 100. Total time: 49ms. Time per element: 0,49ms
  256. Number of elements fetched individually: 100. Total time: 50ms. Time per element: 0,5ms
  257. Number of elements fetched individually: 100. Total time: 52ms. Time per element: 0,52ms
  258. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  259. Number of elements fetched individually: 100. Total time: 52ms. Time per element: 0,52ms
  260. Number of elements fetched individually: 100. Total time: 50ms. Time per element: 0,5ms
  261. Number of elements fetched individually: 100. Total time: 51ms. Time per element: 0,51ms
  262.  
  263. Handcoded materializer using DbDataReader (GetValues(array), boxing). Change tracking: False. Caching: False.
  264. --------------------------------------------------------------------------------------------
  265. First one warm-up run to initialize constructs. Results will not be collected.
  266. Number of elements fetched: 31465. Fetch took: 129ms. Enumerating result took: 1ms
  267. Starting bench runs...
  268. Set fetches
  269. -------------------------
  270. Number of elements fetched: 31465. Fetch took: 153ms. Enumerating result took: 1ms
  271. Number of elements fetched: 31465. Fetch took: 125ms. Enumerating result took: 1ms
  272. Number of elements fetched: 31465. Fetch took: 138ms. Enumerating result took: 1ms
  273. Number of elements fetched: 31465. Fetch took: 129ms. Enumerating result took: 1ms
  274. Number of elements fetched: 31465. Fetch took: 125ms. Enumerating result took: 1ms
  275. Number of elements fetched: 31465. Fetch took: 124ms. Enumerating result took: 1ms
  276. Number of elements fetched: 31465. Fetch took: 133ms. Enumerating result took: 1ms
  277. Number of elements fetched: 31465. Fetch took: 128ms. Enumerating result took: 1ms
  278. Number of elements fetched: 31465. Fetch took: 125ms. Enumerating result took: 1ms
  279. Number of elements fetched: 31465. Fetch took: 128ms. Enumerating result took: 1ms
  280. Number of elements fetched: 31465. Fetch took: 126ms. Enumerating result took: 1ms
  281. Number of elements fetched: 31465. Fetch took: 126ms. Enumerating result took: 1ms
  282. Number of elements fetched: 31465. Fetch took: 127ms. Enumerating result took: 1ms
  283. Number of elements fetched: 31465. Fetch took: 130ms. Enumerating result took: 1ms
  284. Number of elements fetched: 31465. Fetch took: 124ms. Enumerating result took: 1ms
  285. Number of elements fetched: 31465. Fetch took: 126ms. Enumerating result took: 1ms
  286. Number of elements fetched: 31465. Fetch took: 126ms. Enumerating result took: 1ms
  287. Number of elements fetched: 31465. Fetch took: 129ms. Enumerating result took: 1ms
  288. Number of elements fetched: 31465. Fetch took: 128ms. Enumerating result took: 1ms
  289. Number of elements fetched: 31465. Fetch took: 139ms. Enumerating result took: 1ms
  290. Number of elements fetched: 31465. Fetch took: 131ms. Enumerating result took: 1ms
  291. Number of elements fetched: 31465. Fetch took: 138ms. Enumerating result took: 1ms
  292. Number of elements fetched: 31465. Fetch took: 129ms. Enumerating result took: 1ms
  293. Number of elements fetched: 31465. Fetch took: 131ms. Enumerating result took: 1ms
  294. Number of elements fetched: 31465. Fetch took: 127ms. Enumerating result took: 1ms
  295. Single element fetches
  296. -------------------------
  297. Number of elements fetched individually: 100. Total time: 51ms. Time per element: 0,51ms
  298. Number of elements fetched individually: 100. Total time: 49ms. Time per element: 0,49ms
  299. Number of elements fetched individually: 100. Total time: 48ms. Time per element: 0,48ms
  300. Number of elements fetched individually: 100. Total time: 63ms. Time per element: 0,63ms
  301. Number of elements fetched individually: 100. Total time: 49ms. Time per element: 0,49ms
  302. Number of elements fetched individually: 100. Total time: 49ms. Time per element: 0,49ms
  303. Number of elements fetched individually: 100. Total time: 52ms. Time per element: 0,52ms
  304. Number of elements fetched individually: 100. Total time: 51ms. Time per element: 0,51ms
  305. Number of elements fetched individually: 100. Total time: 52ms. Time per element: 0,52ms
  306. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  307. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  308. Number of elements fetched individually: 100. Total time: 52ms. Time per element: 0,52ms
  309. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  310. Number of elements fetched individually: 100. Total time: 50ms. Time per element: 0,5ms
  311. Number of elements fetched individually: 100. Total time: 50ms. Time per element: 0,5ms
  312. Number of elements fetched individually: 100. Total time: 50ms. Time per element: 0,5ms
  313. Number of elements fetched individually: 100. Total time: 50ms. Time per element: 0,5ms
  314. Number of elements fetched individually: 100. Total time: 50ms. Time per element: 0,5ms
  315. Number of elements fetched individually: 100. Total time: 52ms. Time per element: 0,52ms
  316. Number of elements fetched individually: 100. Total time: 52ms. Time per element: 0,52ms
  317. Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
  318. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  319. Number of elements fetched individually: 100. Total time: 50ms. Time per element: 0,5ms
  320. Number of elements fetched individually: 100. Total time: 48ms. Time per element: 0,48ms
  321. Number of elements fetched individually: 100. Total time: 49ms. Time per element: 0,49ms
  322.  
  323. Dapper 1.40.0.0. Change tracking: False. Caching: False.
  324. --------------------------------------------------------------------------------------------
  325. First one warm-up run to initialize constructs. Results will not be collected.
  326. Number of elements fetched: 31465. Fetch took: 204ms. Enumerating result took: 1ms
  327. Starting bench runs...
  328. Set fetches
  329. -------------------------
  330. Number of elements fetched: 31465. Fetch took: 200ms. Enumerating result took: 1ms
  331. Number of elements fetched: 31465. Fetch took: 171ms. Enumerating result took: 1ms
  332. Number of elements fetched: 31465. Fetch took: 172ms. Enumerating result took: 1ms
  333. Number of elements fetched: 31465. Fetch took: 172ms. Enumerating result took: 1ms
  334. Number of elements fetched: 31465. Fetch took: 180ms. Enumerating result took: 1ms
  335. Number of elements fetched: 31465. Fetch took: 175ms. Enumerating result took: 1ms
  336. Number of elements fetched: 31465. Fetch took: 175ms. Enumerating result took: 1ms
  337. Number of elements fetched: 31465. Fetch took: 174ms. Enumerating result took: 1ms
  338. Number of elements fetched: 31465. Fetch took: 177ms. Enumerating result took: 1ms
  339. Number of elements fetched: 31465. Fetch took: 176ms. Enumerating result took: 1ms
  340. Number of elements fetched: 31465. Fetch took: 176ms. Enumerating result took: 1ms
  341. Number of elements fetched: 31465. Fetch took: 171ms. Enumerating result took: 1ms
  342. Number of elements fetched: 31465. Fetch took: 176ms. Enumerating result took: 1ms
  343. Number of elements fetched: 31465. Fetch took: 175ms. Enumerating result took: 1ms
  344. Number of elements fetched: 31465. Fetch took: 178ms. Enumerating result took: 1ms
  345. Number of elements fetched: 31465. Fetch took: 176ms. Enumerating result took: 1ms
  346. Number of elements fetched: 31465. Fetch took: 178ms. Enumerating result took: 1ms
  347. Number of elements fetched: 31465. Fetch took: 173ms. Enumerating result took: 1ms
  348. Number of elements fetched: 31465. Fetch took: 172ms. Enumerating result took: 1ms
  349. Number of elements fetched: 31465. Fetch took: 173ms. Enumerating result took: 1ms
  350. Number of elements fetched: 31465. Fetch took: 177ms. Enumerating result took: 1ms
  351. Number of elements fetched: 31465. Fetch took: 174ms. Enumerating result took: 1ms
  352. Number of elements fetched: 31465. Fetch took: 170ms. Enumerating result took: 1ms
  353. Number of elements fetched: 31465. Fetch took: 174ms. Enumerating result took: 1ms
  354. Number of elements fetched: 31465. Fetch took: 172ms. Enumerating result took: 1ms
  355. Single element fetches
  356. -------------------------
  357. Number of elements fetched individually: 100. Total time: 107ms. Time per element: 1,07ms
  358. Number of elements fetched individually: 100. Total time: 111ms. Time per element: 1,11ms
  359. Number of elements fetched individually: 100. Total time: 103ms. Time per element: 1,03ms
  360. Number of elements fetched individually: 100. Total time: 118ms. Time per element: 1,18ms
  361. Number of elements fetched individually: 100. Total time: 113ms. Time per element: 1,13ms
  362. Number of elements fetched individually: 100. Total time: 98ms. Time per element: 0,98ms
  363. Number of elements fetched individually: 100. Total time: 107ms. Time per element: 1,07ms
  364. Number of elements fetched individually: 100. Total time: 106ms. Time per element: 1,06ms
  365. Number of elements fetched individually: 100. Total time: 108ms. Time per element: 1,08ms
  366. Number of elements fetched individually: 100. Total time: 118ms. Time per element: 1,18ms
  367. Number of elements fetched individually: 100. Total time: 97ms. Time per element: 0,97ms
  368. Number of elements fetched individually: 100. Total time: 109ms. Time per element: 1,09ms
  369. Number of elements fetched individually: 100. Total time: 117ms. Time per element: 1,17ms
  370. Number of elements fetched individually: 100. Total time: 100ms. Time per element: 1ms
  371. Number of elements fetched individually: 100. Total time: 113ms. Time per element: 1,13ms
  372. Number of elements fetched individually: 100. Total time: 101ms. Time per element: 1,01ms
  373. Number of elements fetched individually: 100. Total time: 112ms. Time per element: 1,12ms
  374. Number of elements fetched individually: 100. Total time: 102ms. Time per element: 1,02ms
  375. Number of elements fetched individually: 100. Total time: 115ms. Time per element: 1,15ms
  376. Number of elements fetched individually: 100. Total time: 100ms. Time per element: 1ms
  377. Number of elements fetched individually: 100. Total time: 111ms. Time per element: 1,11ms
  378. Number of elements fetched individually: 100. Total time: 108ms. Time per element: 1,08ms
  379. Number of elements fetched individually: 100. Total time: 96ms. Time per element: 0,96ms
  380. Number of elements fetched individually: 100. Total time: 114ms. Time per element: 1,14ms
  381. Number of elements fetched individually: 100. Total time: 98ms. Time per element: 0,98ms
  382.  
  383. Linq to Sql v4.0.0.0 (v4.6.81.0). Change tracking: False. Caching: False.
  384. --------------------------------------------------------------------------------------------
  385. First one warm-up run to initialize constructs. Results will not be collected.
  386. Number of elements fetched: 31465. Fetch took: 203ms. Enumerating result took: 1ms
  387. Starting bench runs...
  388. Set fetches
  389. -------------------------
  390. Number of elements fetched: 31465. Fetch took: 182ms. Enumerating result took: 1ms
  391. Number of elements fetched: 31465. Fetch took: 190ms. Enumerating result took: 1ms
  392. Number of elements fetched: 31465. Fetch took: 193ms. Enumerating result took: 1ms
  393. Number of elements fetched: 31465. Fetch took: 192ms. Enumerating result took: 1ms
  394. Number of elements fetched: 31465. Fetch took: 191ms. Enumerating result took: 1ms
  395. Number of elements fetched: 31465. Fetch took: 192ms. Enumerating result took: 1ms
  396. Number of elements fetched: 31465. Fetch took: 193ms. Enumerating result took: 1ms
  397. Number of elements fetched: 31465. Fetch took: 191ms. Enumerating result took: 1ms
  398. Number of elements fetched: 31465. Fetch took: 195ms. Enumerating result took: 1ms
  399. Number of elements fetched: 31465. Fetch took: 206ms. Enumerating result took: 1ms
  400. Number of elements fetched: 31465. Fetch took: 193ms. Enumerating result took: 1ms
  401. Number of elements fetched: 31465. Fetch took: 207ms. Enumerating result took: 1ms
  402. Number of elements fetched: 31465. Fetch took: 192ms. Enumerating result took: 1ms
  403. Number of elements fetched: 31465. Fetch took: 193ms. Enumerating result took: 1ms
  404. Number of elements fetched: 31465. Fetch took: 191ms. Enumerating result took: 1ms
  405. Number of elements fetched: 31465. Fetch took: 196ms. Enumerating result took: 1ms
  406. Number of elements fetched: 31465. Fetch took: 206ms. Enumerating result took: 1ms
  407. Number of elements fetched: 31465. Fetch took: 184ms. Enumerating result took: 1ms
  408. Number of elements fetched: 31465. Fetch took: 218ms. Enumerating result took: 1ms
  409. Number of elements fetched: 31465. Fetch took: 205ms. Enumerating result took: 1ms
  410. Number of elements fetched: 31465. Fetch took: 188ms. Enumerating result took: 1ms
  411. Number of elements fetched: 31465. Fetch took: 227ms. Enumerating result took: 1ms
  412. Number of elements fetched: 31465. Fetch took: 186ms. Enumerating result took: 1ms
  413. Number of elements fetched: 31465. Fetch took: 211ms. Enumerating result took: 1ms
  414. Number of elements fetched: 31465. Fetch took: 207ms. Enumerating result took: 1ms
  415. Single element fetches
  416. -------------------------
  417. Number of elements fetched individually: 100. Total time: 149ms. Time per element: 1,49ms
  418. Number of elements fetched individually: 100. Total time: 138ms. Time per element: 1,38ms
  419. Number of elements fetched individually: 100. Total time: 146ms. Time per element: 1,46ms
  420. Number of elements fetched individually: 100. Total time: 144ms. Time per element: 1,44ms
  421. Number of elements fetched individually: 100. Total time: 148ms. Time per element: 1,48ms
  422. Number of elements fetched individually: 100. Total time: 145ms. Time per element: 1,45ms
  423. Number of elements fetched individually: 100. Total time: 139ms. Time per element: 1,39ms
  424. Number of elements fetched individually: 100. Total time: 146ms. Time per element: 1,46ms
  425. Number of elements fetched individually: 100. Total time: 137ms. Time per element: 1,37ms
  426. Number of elements fetched individually: 100. Total time: 144ms. Time per element: 1,44ms
  427. Number of elements fetched individually: 100. Total time: 144ms. Time per element: 1,44ms
  428. Number of elements fetched individually: 100. Total time: 143ms. Time per element: 1,43ms
  429. Number of elements fetched individually: 100. Total time: 145ms. Time per element: 1,45ms
  430. Number of elements fetched individually: 100. Total time: 145ms. Time per element: 1,45ms
  431. Number of elements fetched individually: 100. Total time: 145ms. Time per element: 1,45ms
  432. Number of elements fetched individually: 100. Total time: 147ms. Time per element: 1,47ms
  433. Number of elements fetched individually: 100. Total time: 145ms. Time per element: 1,45ms
  434. Number of elements fetched individually: 100. Total time: 143ms. Time per element: 1,43ms
  435. Number of elements fetched individually: 100. Total time: 145ms. Time per element: 1,45ms
  436. Number of elements fetched individually: 100. Total time: 143ms. Time per element: 1,43ms
  437. Number of elements fetched individually: 100. Total time: 146ms. Time per element: 1,46ms
  438. Number of elements fetched individually: 100. Total time: 151ms. Time per element: 1,51ms
  439. Number of elements fetched individually: 100. Total time: 154ms. Time per element: 1,54ms
  440. Number of elements fetched individually: 100. Total time: 143ms. Time per element: 1,43ms
  441. Number of elements fetched individually: 100. Total time: 144ms. Time per element: 1,44ms
  442.  
  443. Entity Framework v6.0.0.0 (v6.1.40302.0). Change tracking: False. Caching: False.
  444. --------------------------------------------------------------------------------------------
  445. First one warm-up run to initialize constructs. Results will not be collected.
  446. Number of elements fetched: 31465. Fetch took: 454ms. Enumerating result took: 1ms
  447. Starting bench runs...
  448. Set fetches
  449. -------------------------
  450. Number of elements fetched: 31465. Fetch took: 222ms. Enumerating result took: 1ms
  451. Number of elements fetched: 31465. Fetch took: 172ms. Enumerating result took: 1ms
  452. Number of elements fetched: 31465. Fetch took: 169ms. Enumerating result took: 1ms
  453. Number of elements fetched: 31465. Fetch took: 176ms. Enumerating result took: 1ms
  454. Number of elements fetched: 31465. Fetch took: 178ms. Enumerating result took: 1ms
  455. Number of elements fetched: 31465. Fetch took: 178ms. Enumerating result took: 1ms
  456. Number of elements fetched: 31465. Fetch took: 169ms. Enumerating result took: 1ms
  457. Number of elements fetched: 31465. Fetch took: 179ms. Enumerating result took: 1ms
  458. Number of elements fetched: 31465. Fetch took: 192ms. Enumerating result took: 1ms
  459. Number of elements fetched: 31465. Fetch took: 178ms. Enumerating result took: 1ms
  460. Number of elements fetched: 31465. Fetch took: 178ms. Enumerating result took: 1ms
  461. Number of elements fetched: 31465. Fetch took: 177ms. Enumerating result took: 1ms
  462. Number of elements fetched: 31465. Fetch took: 192ms. Enumerating result took: 1ms
  463. Number of elements fetched: 31465. Fetch took: 186ms. Enumerating result took: 1ms
  464. Number of elements fetched: 31465. Fetch took: 177ms. Enumerating result took: 1ms
  465. Number of elements fetched: 31465. Fetch took: 168ms. Enumerating result took: 1ms
  466. Number of elements fetched: 31465. Fetch took: 174ms. Enumerating result took: 1ms
  467. Number of elements fetched: 31465. Fetch took: 177ms. Enumerating result took: 1ms
  468. Number of elements fetched: 31465. Fetch took: 185ms. Enumerating result took: 1ms
  469. Number of elements fetched: 31465. Fetch took: 177ms. Enumerating result took: 1ms
  470. Number of elements fetched: 31465. Fetch took: 178ms. Enumerating result took: 1ms
  471. Number of elements fetched: 31465. Fetch took: 178ms. Enumerating result took: 1ms
  472. Number of elements fetched: 31465. Fetch took: 178ms. Enumerating result took: 1ms
  473. Number of elements fetched: 31465. Fetch took: 179ms. Enumerating result took: 1ms
  474. Number of elements fetched: 31465. Fetch took: 179ms. Enumerating result took: 1ms
  475. Single element fetches
  476. -------------------------
  477. Number of elements fetched individually: 100. Total time: 113ms. Time per element: 1,13ms
  478. Number of elements fetched individually: 100. Total time: 83ms. Time per element: 0,83ms
  479. Number of elements fetched individually: 100. Total time: 82ms. Time per element: 0,82ms
  480. Number of elements fetched individually: 100. Total time: 78ms. Time per element: 0,78ms
  481. Number of elements fetched individually: 100. Total time: 80ms. Time per element: 0,8ms
  482. Number of elements fetched individually: 100. Total time: 82ms. Time per element: 0,82ms
  483. Number of elements fetched individually: 100. Total time: 78ms. Time per element: 0,78ms
  484. Number of elements fetched individually: 100. Total time: 82ms. Time per element: 0,82ms
  485. Number of elements fetched individually: 100. Total time: 81ms. Time per element: 0,81ms
  486. Number of elements fetched individually: 100. Total time: 81ms. Time per element: 0,81ms
  487. Number of elements fetched individually: 100. Total time: 78ms. Time per element: 0,78ms
  488. Number of elements fetched individually: 100. Total time: 81ms. Time per element: 0,81ms
  489. Number of elements fetched individually: 100. Total time: 80ms. Time per element: 0,8ms
  490. Number of elements fetched individually: 100. Total time: 79ms. Time per element: 0,79ms
  491. Number of elements fetched individually: 100. Total time: 80ms. Time per element: 0,8ms
  492. Number of elements fetched individually: 100. Total time: 80ms. Time per element: 0,8ms
  493. Number of elements fetched individually: 100. Total time: 81ms. Time per element: 0,81ms
  494. Number of elements fetched individually: 100. Total time: 79ms. Time per element: 0,79ms
  495. Number of elements fetched individually: 100. Total time: 80ms. Time per element: 0,8ms
  496. Number of elements fetched individually: 100. Total time: 80ms. Time per element: 0,8ms
  497. Number of elements fetched individually: 100. Total time: 79ms. Time per element: 0,79ms
  498. Number of elements fetched individually: 100. Total time: 82ms. Time per element: 0,82ms
  499. Number of elements fetched individually: 100. Total time: 81ms. Time per element: 0,81ms
  500. Number of elements fetched individually: 100. Total time: 82ms. Time per element: 0,82ms
  501. Number of elements fetched individually: 100. Total time: 85ms. Time per element: 0,85ms
  502.  
  503. ServiceStack OrmLite v4.0.46.0 (v4.0.46.0). Change tracking: False. Caching: False.
  504. --------------------------------------------------------------------------------------------
  505. First one warm-up run to initialize constructs. Results will not be collected.
  506. Number of elements fetched: 31465. Fetch took: 362ms. Enumerating result took: 1ms
  507. Starting bench runs...
  508. Set fetches
  509. -------------------------
  510. Number of elements fetched: 31465. Fetch took: 341ms. Enumerating result took: 1ms
  511. Number of elements fetched: 31465. Fetch took: 306ms. Enumerating result took: 1ms
  512. Number of elements fetched: 31465. Fetch took: 327ms. Enumerating result took: 1ms
  513. Number of elements fetched: 31465. Fetch took: 306ms. Enumerating result took: 2ms
  514. Number of elements fetched: 31465. Fetch took: 312ms. Enumerating result took: 1ms
  515. Number of elements fetched: 31465. Fetch took: 334ms. Enumerating result took: 1ms
  516. Number of elements fetched: 31465. Fetch took: 326ms. Enumerating result took: 1ms
  517. Number of elements fetched: 31465. Fetch took: 320ms. Enumerating result took: 1ms
  518. Number of elements fetched: 31465. Fetch took: 304ms. Enumerating result took: 1ms
  519. Number of elements fetched: 31465. Fetch took: 309ms. Enumerating result took: 1ms
  520. Number of elements fetched: 31465. Fetch took: 314ms. Enumerating result took: 1ms
  521. Number of elements fetched: 31465. Fetch took: 305ms. Enumerating result took: 1ms
  522. Number of elements fetched: 31465. Fetch took: 304ms. Enumerating result took: 1ms
  523. Number of elements fetched: 31465. Fetch took: 313ms. Enumerating result took: 1ms
  524. Number of elements fetched: 31465. Fetch took: 317ms. Enumerating result took: 1ms
  525. Number of elements fetched: 31465. Fetch took: 317ms. Enumerating result took: 1ms
  526. Number of elements fetched: 31465. Fetch took: 308ms. Enumerating result took: 1ms
  527. Number of elements fetched: 31465. Fetch took: 311ms. Enumerating result took: 1ms
  528. Number of elements fetched: 31465. Fetch took: 306ms. Enumerating result took: 1ms
  529. Number of elements fetched: 31465. Fetch took: 310ms. Enumerating result took: 1ms
  530. Number of elements fetched: 31465. Fetch took: 307ms. Enumerating result took: 1ms
  531. Number of elements fetched: 31465. Fetch took: 317ms. Enumerating result took: 1ms
  532. Number of elements fetched: 31465. Fetch took: 309ms. Enumerating result took: 1ms
  533. Number of elements fetched: 31465. Fetch took: 310ms. Enumerating result took: 1ms
  534. Number of elements fetched: 31465. Fetch took: 315ms. Enumerating result took: 1ms
  535. Single element fetches
  536. -------------------------
  537. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  538. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  539. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  540. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  541. Number of elements fetched individually: 100. Total time: 61ms. Time per element: 0,61ms
  542. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  543. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  544. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  545. Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
  546. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  547. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  548. Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
  549. Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
  550. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  551. Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
  552. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  553. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  554. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  555. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  556. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  557. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  558. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  559. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  560. Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
  561. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  562.  
  563. PetaPoco v4.0.3. Change tracking: False. Caching: False.
  564. --------------------------------------------------------------------------------------------
  565. First one warm-up run to initialize constructs. Results will not be collected.
  566. Number of elements fetched: 31465. Fetch took: 168ms. Enumerating result took: 1ms
  567. Starting bench runs...
  568. Set fetches
  569. -------------------------
  570. Number of elements fetched: 31465. Fetch took: 179ms. Enumerating result took: 1ms
  571. Number of elements fetched: 31465. Fetch took: 158ms. Enumerating result took: 1ms
  572. Number of elements fetched: 31465. Fetch took: 149ms. Enumerating result took: 1ms
  573. Number of elements fetched: 31465. Fetch took: 148ms. Enumerating result took: 1ms
  574. Number of elements fetched: 31465. Fetch took: 152ms. Enumerating result took: 1ms
  575. Number of elements fetched: 31465. Fetch took: 152ms. Enumerating result took: 1ms
  576. Number of elements fetched: 31465. Fetch took: 166ms. Enumerating result took: 1ms
  577. Number of elements fetched: 31465. Fetch took: 150ms. Enumerating result took: 2ms
  578. Number of elements fetched: 31465. Fetch took: 149ms. Enumerating result took: 1ms
  579. Number of elements fetched: 31465. Fetch took: 152ms. Enumerating result took: 1ms
  580. Number of elements fetched: 31465. Fetch took: 150ms. Enumerating result took: 1ms
  581. Number of elements fetched: 31465. Fetch took: 153ms. Enumerating result took: 1ms
  582. Number of elements fetched: 31465. Fetch took: 151ms. Enumerating result took: 1ms
  583. Number of elements fetched: 31465. Fetch took: 151ms. Enumerating result took: 1ms
  584. Number of elements fetched: 31465. Fetch took: 151ms. Enumerating result took: 1ms
  585. Number of elements fetched: 31465. Fetch took: 152ms. Enumerating result took: 1ms
  586. Number of elements fetched: 31465. Fetch took: 150ms. Enumerating result took: 1ms
  587. Number of elements fetched: 31465. Fetch took: 152ms. Enumerating result took: 1ms
  588. Number of elements fetched: 31465. Fetch took: 159ms. Enumerating result took: 1ms
  589. Number of elements fetched: 31465. Fetch took: 151ms. Enumerating result took: 1ms
  590. Number of elements fetched: 31465. Fetch took: 153ms. Enumerating result took: 1ms
  591. Number of elements fetched: 31465. Fetch took: 153ms. Enumerating result took: 1ms
  592. Number of elements fetched: 31465. Fetch took: 148ms. Enumerating result took: 1ms
  593. Number of elements fetched: 31465. Fetch took: 151ms. Enumerating result took: 1ms
  594. Number of elements fetched: 31465. Fetch took: 150ms. Enumerating result took: 1ms
  595. Single element fetches
  596. -------------------------
  597. Number of elements fetched individually: 100. Total time: 220ms. Time per element: 2,2ms
  598. Number of elements fetched individually: 100. Total time: 206ms. Time per element: 2,06ms
  599. Number of elements fetched individually: 100. Total time: 202ms. Time per element: 2,02ms
  600. Number of elements fetched individually: 100. Total time: 207ms. Time per element: 2,07ms
  601. Number of elements fetched individually: 100. Total time: 214ms. Time per element: 2,14ms
  602. Number of elements fetched individually: 100. Total time: 208ms. Time per element: 2,08ms
  603. Number of elements fetched individually: 100. Total time: 202ms. Time per element: 2,02ms
  604. Number of elements fetched individually: 100. Total time: 205ms. Time per element: 2,05ms
  605. Number of elements fetched individually: 100. Total time: 206ms. Time per element: 2,06ms
  606. Number of elements fetched individually: 100. Total time: 203ms. Time per element: 2,03ms
  607. Number of elements fetched individually: 100. Total time: 202ms. Time per element: 2,02ms
  608. Number of elements fetched individually: 100. Total time: 203ms. Time per element: 2,03ms
  609. Number of elements fetched individually: 100. Total time: 204ms. Time per element: 2,04ms
  610. Number of elements fetched individually: 100. Total time: 203ms. Time per element: 2,03ms
  611. Number of elements fetched individually: 100. Total time: 204ms. Time per element: 2,04ms
  612. Number of elements fetched individually: 100. Total time: 205ms. Time per element: 2,05ms
  613. Number of elements fetched individually: 100. Total time: 205ms. Time per element: 2,05ms
  614. Number of elements fetched individually: 100. Total time: 206ms. Time per element: 2,06ms
  615. Number of elements fetched individually: 100. Total time: 217ms. Time per element: 2,17ms
  616. Number of elements fetched individually: 100. Total time: 203ms. Time per element: 2,03ms
  617. Number of elements fetched individually: 100. Total time: 204ms. Time per element: 2,04ms
  618. Number of elements fetched individually: 100. Total time: 207ms. Time per element: 2,07ms
  619. Number of elements fetched individually: 100. Total time: 204ms. Time per element: 2,04ms
  620. Number of elements fetched individually: 100. Total time: 203ms. Time per element: 2,03ms
  621. Number of elements fetched individually: 100. Total time: 205ms. Time per element: 2,05ms
  622.  
  623. PetaPoco Fast v4.0.3. Change tracking: False. Caching: False.
  624. --------------------------------------------------------------------------------------------
  625. First one warm-up run to initialize constructs. Results will not be collected.
  626. Number of elements fetched: 31465. Fetch took: 150ms. Enumerating result took: 1ms
  627. Starting bench runs...
  628. Set fetches
  629. -------------------------
  630. Number of elements fetched: 31465. Fetch took: 151ms. Enumerating result took: 1ms
  631. Number of elements fetched: 31465. Fetch took: 136ms. Enumerating result took: 1ms
  632. Number of elements fetched: 31465. Fetch took: 145ms. Enumerating result took: 1ms
  633. Number of elements fetched: 31465. Fetch took: 135ms. Enumerating result took: 1ms
  634. Number of elements fetched: 31465. Fetch took: 146ms. Enumerating result took: 1ms
  635. Number of elements fetched: 31465. Fetch took: 134ms. Enumerating result took: 1ms
  636. Number of elements fetched: 31465. Fetch took: 146ms. Enumerating result took: 1ms
  637. Number of elements fetched: 31465. Fetch took: 133ms. Enumerating result took: 1ms
  638. Number of elements fetched: 31465. Fetch took: 145ms. Enumerating result took: 1ms
  639. Number of elements fetched: 31465. Fetch took: 137ms. Enumerating result took: 1ms
  640. Number of elements fetched: 31465. Fetch took: 144ms. Enumerating result took: 1ms
  641. Number of elements fetched: 31465. Fetch took: 133ms. Enumerating result took: 1ms
  642. Number of elements fetched: 31465. Fetch took: 143ms. Enumerating result took: 1ms
  643. Number of elements fetched: 31465. Fetch took: 142ms. Enumerating result took: 1ms
  644. Number of elements fetched: 31465. Fetch took: 142ms. Enumerating result took: 1ms
  645. Number of elements fetched: 31465. Fetch took: 134ms. Enumerating result took: 1ms
  646. Number of elements fetched: 31465. Fetch took: 143ms. Enumerating result took: 1ms
  647. Number of elements fetched: 31465. Fetch took: 133ms. Enumerating result took: 1ms
  648. Number of elements fetched: 31465. Fetch took: 146ms. Enumerating result took: 1ms
  649. Number of elements fetched: 31465. Fetch took: 135ms. Enumerating result took: 1ms
  650. Number of elements fetched: 31465. Fetch took: 151ms. Enumerating result took: 1ms
  651. Number of elements fetched: 31465. Fetch took: 134ms. Enumerating result took: 1ms
  652. Number of elements fetched: 31465. Fetch took: 145ms. Enumerating result took: 1ms
  653. Number of elements fetched: 31465. Fetch took: 145ms. Enumerating result took: 1ms
  654. Number of elements fetched: 31465. Fetch took: 139ms. Enumerating result took: 1ms
  655. Single element fetches
  656. -------------------------
  657. Number of elements fetched individually: 100. Total time: 72ms. Time per element: 0,72ms
  658. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  659. Number of elements fetched individually: 100. Total time: 70ms. Time per element: 0,7ms
  660. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  661. Number of elements fetched individually: 100. Total time: 71ms. Time per element: 0,71ms
  662. Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
  663. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  664. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  665. Number of elements fetched individually: 100. Total time: 72ms. Time per element: 0,72ms
  666. Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
  667. Number of elements fetched individually: 100. Total time: 70ms. Time per element: 0,7ms
  668. Number of elements fetched individually: 100. Total time: 70ms. Time per element: 0,7ms
  669. Number of elements fetched individually: 100. Total time: 70ms. Time per element: 0,7ms
  670. Number of elements fetched individually: 100. Total time: 72ms. Time per element: 0,72ms
  671. Number of elements fetched individually: 100. Total time: 72ms. Time per element: 0,72ms
  672. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  673. Number of elements fetched individually: 100. Total time: 71ms. Time per element: 0,71ms
  674. Number of elements fetched individually: 100. Total time: 70ms. Time per element: 0,7ms
  675. Number of elements fetched individually: 100. Total time: 70ms. Time per element: 0,7ms
  676. Number of elements fetched individually: 100. Total time: 72ms. Time per element: 0,72ms
  677. Number of elements fetched individually: 100. Total time: 72ms. Time per element: 0,72ms
  678. Number of elements fetched individually: 100. Total time: 72ms. Time per element: 0,72ms
  679. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  680. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  681. Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
  682.  
  683. DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
  684. --------------------------------------------------------------------------------------------
  685. First one warm-up run to initialize constructs. Results will not be collected.
  686. Number of elements fetched: 31465. Fetch took: 194ms. Enumerating result took: 27ms
  687. Starting bench runs...
  688. Set fetches
  689. -------------------------
  690. Number of elements fetched: 31465. Fetch took: 228ms. Enumerating result took: 26ms
  691. Number of elements fetched: 31465. Fetch took: 195ms. Enumerating result took: 27ms
  692. Number of elements fetched: 31465. Fetch took: 199ms. Enumerating result took: 28ms
  693. Number of elements fetched: 31465. Fetch took: 195ms. Enumerating result took: 27ms
  694. Number of elements fetched: 31465. Fetch took: 184ms. Enumerating result took: 28ms
  695. Number of elements fetched: 31465. Fetch took: 197ms. Enumerating result took: 27ms
  696. Number of elements fetched: 31465. Fetch took: 185ms. Enumerating result took: 27ms
  697. Number of elements fetched: 31465. Fetch took: 197ms. Enumerating result took: 27ms
  698. Number of elements fetched: 31465. Fetch took: 200ms. Enumerating result took: 27ms
  699. Number of elements fetched: 31465. Fetch took: 197ms. Enumerating result took: 26ms
  700. Number of elements fetched: 31465. Fetch took: 185ms. Enumerating result took: 27ms
  701. Number of elements fetched: 31465. Fetch took: 201ms. Enumerating result took: 27ms
  702. Number of elements fetched: 31465. Fetch took: 195ms. Enumerating result took: 28ms
  703. Number of elements fetched: 31465. Fetch took: 199ms. Enumerating result took: 27ms
  704. Number of elements fetched: 31465. Fetch took: 197ms. Enumerating result took: 27ms
  705. Number of elements fetched: 31465. Fetch took: 198ms. Enumerating result took: 27ms
  706. Number of elements fetched: 31465. Fetch took: 201ms. Enumerating result took: 28ms
  707. Number of elements fetched: 31465. Fetch took: 194ms. Enumerating result took: 27ms
  708. Number of elements fetched: 31465. Fetch took: 198ms. Enumerating result took: 27ms
  709. Number of elements fetched: 31465. Fetch took: 201ms. Enumerating result took: 27ms
  710. Number of elements fetched: 31465. Fetch took: 202ms. Enumerating result took: 27ms
  711. Number of elements fetched: 31465. Fetch took: 190ms. Enumerating result took: 28ms
  712. Number of elements fetched: 31465. Fetch took: 196ms. Enumerating result took: 27ms
  713. Number of elements fetched: 31465. Fetch took: 183ms. Enumerating result took: 27ms
  714. Number of elements fetched: 31465. Fetch took: 191ms. Enumerating result took: 27ms
  715. Single element fetches
  716. -------------------------
  717. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  718. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  719. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  720. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  721. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  722. Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
  723. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  724. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  725. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  726. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  727. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  728. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  729. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  730. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  731. Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
  732. Number of elements fetched individually: 100. Total time: 61ms. Time per element: 0,61ms
  733. Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
  734. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  735. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  736. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  737. Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
  738. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  739. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  740. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  741. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  742.  
  743. Linq to Sql v4.0.0.0 (v4.6.81.0). Change tracking: True. Caching: False.
  744. --------------------------------------------------------------------------------------------
  745. First one warm-up run to initialize constructs. Results will not be collected.
  746. Number of elements fetched: 31465. Fetch took: 269ms. Enumerating result took: 1ms
  747. Starting bench runs...
  748. Set fetches
  749. -------------------------
  750. Number of elements fetched: 31465. Fetch took: 283ms. Enumerating result took: 1ms
  751. Number of elements fetched: 31465. Fetch took: 246ms. Enumerating result took: 1ms
  752. Number of elements fetched: 31465. Fetch took: 247ms. Enumerating result took: 1ms
  753. Number of elements fetched: 31465. Fetch took: 244ms. Enumerating result took: 1ms
  754. Number of elements fetched: 31465. Fetch took: 260ms. Enumerating result took: 1ms
  755. Number of elements fetched: 31465. Fetch took: 253ms. Enumerating result took: 1ms
  756. Number of elements fetched: 31465. Fetch took: 247ms. Enumerating result took: 1ms
  757. Number of elements fetched: 31465. Fetch took: 249ms. Enumerating result took: 1ms
  758. Number of elements fetched: 31465. Fetch took: 246ms. Enumerating result took: 2ms
  759. Number of elements fetched: 31465. Fetch took: 248ms. Enumerating result took: 1ms
  760. Number of elements fetched: 31465. Fetch took: 255ms. Enumerating result took: 1ms
  761. Number of elements fetched: 31465. Fetch took: 251ms. Enumerating result took: 1ms
  762. Number of elements fetched: 31465. Fetch took: 245ms. Enumerating result took: 1ms
  763. Number of elements fetched: 31465. Fetch took: 244ms. Enumerating result took: 1ms
  764. Number of elements fetched: 31465. Fetch took: 248ms. Enumerating result took: 1ms
  765. Number of elements fetched: 31465. Fetch took: 258ms. Enumerating result took: 1ms
  766. Number of elements fetched: 31465. Fetch took: 249ms. Enumerating result took: 1ms
  767. Number of elements fetched: 31465. Fetch took: 251ms. Enumerating result took: 1ms
  768. Number of elements fetched: 31465. Fetch took: 241ms. Enumerating result took: 1ms
  769. Number of elements fetched: 31465. Fetch took: 248ms. Enumerating result took: 1ms
  770. Number of elements fetched: 31465. Fetch took: 246ms. Enumerating result took: 1ms
  771. Number of elements fetched: 31465. Fetch took: 244ms. Enumerating result took: 1ms
  772. Number of elements fetched: 31465. Fetch took: 246ms. Enumerating result took: 1ms
  773. Number of elements fetched: 31465. Fetch took: 245ms. Enumerating result took: 1ms
  774. Number of elements fetched: 31465. Fetch took: 246ms. Enumerating result took: 1ms
  775. Single element fetches
  776. -------------------------
  777. Number of elements fetched individually: 100. Total time: 151ms. Time per element: 1,51ms
  778. Number of elements fetched individually: 100. Total time: 149ms. Time per element: 1,49ms
  779. Number of elements fetched individually: 100. Total time: 148ms. Time per element: 1,48ms
  780. Number of elements fetched individually: 100. Total time: 148ms. Time per element: 1,48ms
  781. Number of elements fetched individually: 100. Total time: 146ms. Time per element: 1,46ms
  782. Number of elements fetched individually: 100. Total time: 148ms. Time per element: 1,48ms
  783. Number of elements fetched individually: 100. Total time: 148ms. Time per element: 1,48ms
  784. Number of elements fetched individually: 100. Total time: 149ms. Time per element: 1,49ms
  785. Number of elements fetched individually: 100. Total time: 148ms. Time per element: 1,48ms
  786. Number of elements fetched individually: 100. Total time: 148ms. Time per element: 1,48ms
  787. Number of elements fetched individually: 100. Total time: 147ms. Time per element: 1,47ms
  788. Number of elements fetched individually: 100. Total time: 146ms. Time per element: 1,46ms
  789. Number of elements fetched individually: 100. Total time: 146ms. Time per element: 1,46ms
  790. Number of elements fetched individually: 100. Total time: 152ms. Time per element: 1,52ms
  791. Number of elements fetched individually: 100. Total time: 149ms. Time per element: 1,49ms
  792. Number of elements fetched individually: 100. Total time: 147ms. Time per element: 1,47ms
  793. Number of elements fetched individually: 100. Total time: 150ms. Time per element: 1,5ms
  794. Number of elements fetched individually: 100. Total time: 151ms. Time per element: 1,51ms
  795. Number of elements fetched individually: 100. Total time: 150ms. Time per element: 1,5ms
  796. Number of elements fetched individually: 100. Total time: 152ms. Time per element: 1,52ms
  797. Number of elements fetched individually: 100. Total time: 150ms. Time per element: 1,5ms
  798. Number of elements fetched individually: 100. Total time: 148ms. Time per element: 1,48ms
  799. Number of elements fetched individually: 100. Total time: 148ms. Time per element: 1,48ms
  800. Number of elements fetched individually: 100. Total time: 151ms. Time per element: 1,51ms
  801. Number of elements fetched individually: 100. Total time: 153ms. Time per element: 1,53ms
  802.  
  803. LLBLGen Pro v4.2.0.0 (v4.2.15.1015), Poco typed view with Linq. Change tracking: False. Caching: False.
  804. --------------------------------------------------------------------------------------------
  805. First one warm-up run to initialize constructs. Results will not be collected.
  806. Number of elements fetched: 31465. Fetch took: 325ms. Enumerating result took: 1ms
  807. Starting bench runs...
  808. Set fetches
  809. -------------------------
  810. Number of elements fetched: 31465. Fetch took: 307ms. Enumerating result took: 1ms
  811. Number of elements fetched: 31465. Fetch took: 261ms. Enumerating result took: 0ms
  812. Number of elements fetched: 31465. Fetch took: 270ms. Enumerating result took: 0ms
  813. Number of elements fetched: 31465. Fetch took: 282ms. Enumerating result took: 1ms
  814. Number of elements fetched: 31465. Fetch took: 268ms. Enumerating result took: 0ms
  815. Number of elements fetched: 31465. Fetch took: 285ms. Enumerating result took: 0ms
  816. Number of elements fetched: 31465. Fetch took: 259ms. Enumerating result took: 0ms
  817. Number of elements fetched: 31465. Fetch took: 259ms. Enumerating result took: 1ms
  818. Number of elements fetched: 31465. Fetch took: 268ms. Enumerating result took: 0ms
  819. Number of elements fetched: 31465. Fetch took: 278ms. Enumerating result took: 0ms
  820. Number of elements fetched: 31465. Fetch took: 262ms. Enumerating result took: 0ms
  821. Number of elements fetched: 31465. Fetch took: 261ms. Enumerating result took: 0ms
  822. Number of elements fetched: 31465. Fetch took: 276ms. Enumerating result took: 0ms
  823. Number of elements fetched: 31465. Fetch took: 282ms. Enumerating result took: 1ms
  824. Number of elements fetched: 31465. Fetch took: 277ms. Enumerating result took: 0ms
  825. Number of elements fetched: 31465. Fetch took: 269ms. Enumerating result took: 1ms
  826. Number of elements fetched: 31465. Fetch took: 259ms. Enumerating result took: 0ms
  827. Number of elements fetched: 31465. Fetch took: 268ms. Enumerating result took: 0ms
  828. Number of elements fetched: 31465. Fetch took: 262ms. Enumerating result took: 0ms
  829. Number of elements fetched: 31465. Fetch took: 264ms. Enumerating result took: 0ms
  830. Number of elements fetched: 31465. Fetch took: 268ms. Enumerating result took: 1ms
  831. Number of elements fetched: 31465. Fetch took: 275ms. Enumerating result took: 0ms
  832. Number of elements fetched: 31465. Fetch took: 271ms. Enumerating result took: 1ms
  833. Number of elements fetched: 31465. Fetch took: 267ms. Enumerating result took: 1ms
  834. Number of elements fetched: 31465. Fetch took: 263ms. Enumerating result took: 0ms
  835. Single element fetches
  836. -------------------------
  837. Number of elements fetched individually: 100. Total time: 175ms. Time per element: 1,75ms
  838. Number of elements fetched individually: 100. Total time: 139ms. Time per element: 1,39ms
  839. Number of elements fetched individually: 100. Total time: 136ms. Time per element: 1,36ms
  840. Number of elements fetched individually: 100. Total time: 139ms. Time per element: 1,39ms
  841. Number of elements fetched individually: 100. Total time: 139ms. Time per element: 1,39ms
  842. Number of elements fetched individually: 100. Total time: 137ms. Time per element: 1,37ms
  843. Number of elements fetched individually: 100. Total time: 138ms. Time per element: 1,38ms
  844. Number of elements fetched individually: 100. Total time: 138ms. Time per element: 1,38ms
  845. Number of elements fetched individually: 100. Total time: 138ms. Time per element: 1,38ms
  846. Number of elements fetched individually: 100. Total time: 139ms. Time per element: 1,39ms
  847. Number of elements fetched individually: 100. Total time: 137ms. Time per element: 1,37ms
  848. Number of elements fetched individually: 100. Total time: 141ms. Time per element: 1,41ms
  849. Number of elements fetched individually: 100. Total time: 138ms. Time per element: 1,38ms
  850. Number of elements fetched individually: 100. Total time: 139ms. Time per element: 1,39ms
  851. Number of elements fetched individually: 100. Total time: 140ms. Time per element: 1,4ms
  852. Number of elements fetched individually: 100. Total time: 137ms. Time per element: 1,37ms
  853. Number of elements fetched individually: 100. Total time: 137ms. Time per element: 1,37ms
  854. Number of elements fetched individually: 100. Total time: 143ms. Time per element: 1,43ms
  855. Number of elements fetched individually: 100. Total time: 137ms. Time per element: 1,37ms
  856. Number of elements fetched individually: 100. Total time: 140ms. Time per element: 1,4ms
  857. Number of elements fetched individually: 100. Total time: 139ms. Time per element: 1,39ms
  858. Number of elements fetched individually: 100. Total time: 136ms. Time per element: 1,36ms
  859. Number of elements fetched individually: 100. Total time: 137ms. Time per element: 1,37ms
  860. Number of elements fetched individually: 100. Total time: 138ms. Time per element: 1,38ms
  861. Number of elements fetched individually: 100. Total time: 140ms. Time per element: 1,4ms
  862.  
  863. LLBLGen Pro v4.2.0.0 (v4.2.15.1015), Poco typed view with QuerySpec. Change tracking: False. Caching: False.
  864. --------------------------------------------------------------------------------------------
  865. First one warm-up run to initialize constructs. Results will not be collected.
  866. Number of elements fetched: 31465. Fetch took: 258ms. Enumerating result took: 1ms
  867. Starting bench runs...
  868. Set fetches
  869. -------------------------
  870. Number of elements fetched: 31465. Fetch took: 278ms. Enumerating result took: 0ms
  871. Number of elements fetched: 31465. Fetch took: 239ms. Enumerating result took: 0ms
  872. Number of elements fetched: 31465. Fetch took: 233ms. Enumerating result took: 1ms
  873. Number of elements fetched: 31465. Fetch took: 238ms. Enumerating result took: 0ms
  874. Number of elements fetched: 31465. Fetch took: 233ms. Enumerating result took: 1ms
  875. Number of elements fetched: 31465. Fetch took: 233ms. Enumerating result took: 0ms
  876. Number of elements fetched: 31465. Fetch took: 236ms. Enumerating result took: 1ms
  877. Number of elements fetched: 31465. Fetch took: 236ms. Enumerating result took: 0ms
  878. Number of elements fetched: 31465. Fetch took: 235ms. Enumerating result took: 1ms
  879. Number of elements fetched: 31465. Fetch took: 237ms. Enumerating result took: 0ms
  880. Number of elements fetched: 31465. Fetch took: 239ms. Enumerating result took: 1ms
  881. Number of elements fetched: 31465. Fetch took: 235ms. Enumerating result took: 1ms
  882. Number of elements fetched: 31465. Fetch took: 233ms. Enumerating result took: 0ms
  883. Number of elements fetched: 31465. Fetch took: 233ms. Enumerating result took: 1ms
  884. Number of elements fetched: 31465. Fetch took: 235ms. Enumerating result took: 0ms
  885. Number of elements fetched: 31465. Fetch took: 240ms. Enumerating result took: 0ms
  886. Number of elements fetched: 31465. Fetch took: 242ms. Enumerating result took: 1ms
  887. Number of elements fetched: 31465. Fetch took: 238ms. Enumerating result took: 1ms
  888. Number of elements fetched: 31465. Fetch took: 237ms. Enumerating result took: 0ms
  889. Number of elements fetched: 31465. Fetch took: 239ms. Enumerating result took: 1ms
  890. Number of elements fetched: 31465. Fetch took: 236ms. Enumerating result took: 1ms
  891. Number of elements fetched: 31465. Fetch took: 237ms. Enumerating result took: 1ms
  892. Number of elements fetched: 31465. Fetch took: 240ms. Enumerating result took: 1ms
  893. Number of elements fetched: 31465. Fetch took: 248ms. Enumerating result took: 1ms
  894. Number of elements fetched: 31465. Fetch took: 252ms. Enumerating result took: 1ms
  895. Single element fetches
  896. -------------------------
  897. Number of elements fetched individually: 100. Total time: 63ms. Time per element: 0,63ms
  898. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  899. Number of elements fetched individually: 100. Total time: 64ms. Time per element: 0,64ms
  900. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  901. Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
  902. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  903. Number of elements fetched individually: 100. Total time: 71ms. Time per element: 0,71ms
  904. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  905. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  906. Number of elements fetched individually: 100. Total time: 70ms. Time per element: 0,7ms
  907. Number of elements fetched individually: 100. Total time: 64ms. Time per element: 0,64ms
  908. Number of elements fetched individually: 100. Total time: 71ms. Time per element: 0,71ms
  909. Number of elements fetched individually: 100. Total time: 70ms. Time per element: 0,7ms
  910. Number of elements fetched individually: 100. Total time: 64ms. Time per element: 0,64ms
  911. Number of elements fetched individually: 100. Total time: 64ms. Time per element: 0,64ms
  912. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  913. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  914. Number of elements fetched individually: 100. Total time: 61ms. Time per element: 0,61ms
  915. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  916. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  917. Number of elements fetched individually: 100. Total time: 74ms. Time per element: 0,74ms
  918. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  919. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  920. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  921. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  922.  
  923. LLBLGen Pro v4.2.0.0 (v4.2.15.1015), typed view. Change tracking: False. Caching: False.
  924. --------------------------------------------------------------------------------------------
  925. First one warm-up run to initialize constructs. Results will not be collected.
  926. Number of elements fetched: 31465. Fetch took: 322ms. Enumerating result took: 3ms
  927. Starting bench runs...
  928. Set fetches
  929. -------------------------
  930. Number of elements fetched: 31465. Fetch took: 344ms. Enumerating result took: 2ms
  931. Number of elements fetched: 31465. Fetch took: 315ms. Enumerating result took: 6ms
  932. Number of elements fetched: 31465. Fetch took: 334ms. Enumerating result took: 2ms
  933. Number of elements fetched: 31465. Fetch took: 305ms. Enumerating result took: 2ms
  934. Number of elements fetched: 31465. Fetch took: 304ms. Enumerating result took: 2ms
  935. Number of elements fetched: 31465. Fetch took: 316ms. Enumerating result took: 2ms
  936. Number of elements fetched: 31465. Fetch took: 306ms. Enumerating result took: 2ms
  937. Number of elements fetched: 31465. Fetch took: 305ms. Enumerating result took: 2ms
  938. Number of elements fetched: 31465. Fetch took: 310ms. Enumerating result took: 2ms
  939. Number of elements fetched: 31465. Fetch took: 309ms. Enumerating result took: 2ms
  940. Number of elements fetched: 31465. Fetch took: 324ms. Enumerating result took: 2ms
  941. Number of elements fetched: 31465. Fetch took: 312ms. Enumerating result took: 2ms
  942. Number of elements fetched: 31465. Fetch took: 316ms. Enumerating result took: 2ms
  943. Number of elements fetched: 31465. Fetch took: 307ms. Enumerating result took: 2ms
  944. Number of elements fetched: 31465. Fetch took: 301ms. Enumerating result took: 2ms
  945. Number of elements fetched: 31465. Fetch took: 299ms. Enumerating result took: 6ms
  946. Number of elements fetched: 31465. Fetch took: 332ms. Enumerating result took: 2ms
  947. Number of elements fetched: 31465. Fetch took: 322ms. Enumerating result took: 2ms
  948. Number of elements fetched: 31465. Fetch took: 329ms. Enumerating result took: 7ms
  949. Number of elements fetched: 31465. Fetch took: 341ms. Enumerating result took: 2ms
  950. Number of elements fetched: 31465. Fetch took: 330ms. Enumerating result took: 2ms
  951. Number of elements fetched: 31465. Fetch took: 336ms. Enumerating result took: 2ms
  952. Number of elements fetched: 31465. Fetch took: 327ms. Enumerating result took: 2ms
  953. Number of elements fetched: 31465. Fetch took: 325ms. Enumerating result took: 2ms
  954. Number of elements fetched: 31465. Fetch took: 299ms. Enumerating result took: 7ms
  955. Single element fetches
  956. -------------------------
  957. Number of elements fetched individually: 100. Total time: 76ms. Time per element: 0,76ms
  958. Number of elements fetched individually: 100. Total time: 72ms. Time per element: 0,72ms
  959. Number of elements fetched individually: 100. Total time: 72ms. Time per element: 0,72ms
  960. Number of elements fetched individually: 100. Total time: 72ms. Time per element: 0,72ms
  961. Number of elements fetched individually: 100. Total time: 74ms. Time per element: 0,74ms
  962. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  963. Number of elements fetched individually: 100. Total time: 71ms. Time per element: 0,71ms
  964. Number of elements fetched individually: 100. Total time: 74ms. Time per element: 0,74ms
  965. Number of elements fetched individually: 100. Total time: 74ms. Time per element: 0,74ms
  966. Number of elements fetched individually: 100. Total time: 72ms. Time per element: 0,72ms
  967. Number of elements fetched individually: 100. Total time: 72ms. Time per element: 0,72ms
  968. Number of elements fetched individually: 100. Total time: 74ms. Time per element: 0,74ms
  969. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  970. Number of elements fetched individually: 100. Total time: 75ms. Time per element: 0,75ms
  971. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  972. Number of elements fetched individually: 100. Total time: 75ms. Time per element: 0,75ms
  973. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  974. Number of elements fetched individually: 100. Total time: 76ms. Time per element: 0,76ms
  975. Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
  976. Number of elements fetched individually: 100. Total time: 74ms. Time per element: 0,74ms
  977. Number of elements fetched individually: 100. Total time: 75ms. Time per element: 0,75ms
  978. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  979. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  980. Number of elements fetched individually: 100. Total time: 76ms. Time per element: 0,76ms
  981. Number of elements fetched individually: 100. Total time: 75ms. Time per element: 0,75ms
  982.  
  983. LLBLGen Pro v4.2.0.0 (v4.2.15.1015). Change tracking: True. Caching: True.
  984. --------------------------------------------------------------------------------------------
  985. First one warm-up run to initialize constructs. Results will not be collected.
  986. Number of elements fetched: 31465. Fetch took: 457ms. Enumerating result took: 7ms
  987. Starting bench runs...
  988. Set fetches
  989. -------------------------
  990. Number of elements fetched: 31465. Fetch took: 142ms. Enumerating result took: 4ms
  991. Number of elements fetched: 31465. Fetch took: 80ms. Enumerating result took: 3ms
  992. Number of elements fetched: 31465. Fetch took: 76ms. Enumerating result took: 3ms
  993. Number of elements fetched: 31465. Fetch took: 76ms. Enumerating result took: 3ms
  994. Number of elements fetched: 31465. Fetch took: 76ms. Enumerating result took: 3ms
  995. Number of elements fetched: 31465. Fetch took: 88ms. Enumerating result took: 3ms
  996. Number of elements fetched: 31465. Fetch took: 77ms. Enumerating result took: 3ms
  997. Number of elements fetched: 31465. Fetch took: 75ms. Enumerating result took: 3ms
  998. Number of elements fetched: 31465. Fetch took: 76ms. Enumerating result took: 3ms
  999. Number of elements fetched: 31465. Fetch took: 76ms. Enumerating result took: 3ms
  1000. Number of elements fetched: 31465. Fetch took: 75ms. Enumerating result took: 3ms
  1001. Number of elements fetched: 31465. Fetch took: 76ms. Enumerating result took: 3ms
  1002. Number of elements fetched: 31465. Fetch took: 75ms. Enumerating result took: 3ms
  1003. Number of elements fetched: 31465. Fetch took: 75ms. Enumerating result took: 3ms
  1004. Number of elements fetched: 31465. Fetch took: 75ms. Enumerating result took: 3ms
  1005. Number of elements fetched: 31465. Fetch took: 81ms. Enumerating result took: 3ms
  1006. Number of elements fetched: 31465. Fetch took: 84ms. Enumerating result took: 3ms
  1007. Number of elements fetched: 31465. Fetch took: 81ms. Enumerating result took: 3ms
  1008. Number of elements fetched: 31465. Fetch took: 80ms. Enumerating result took: 3ms
  1009. Number of elements fetched: 31465. Fetch took: 74ms. Enumerating result took: 15ms
  1010. Number of elements fetched: 31465. Fetch took: 79ms. Enumerating result took: 3ms
  1011. Number of elements fetched: 31465. Fetch took: 78ms. Enumerating result took: 3ms
  1012. Number of elements fetched: 31465. Fetch took: 81ms. Enumerating result took: 3ms
  1013. Number of elements fetched: 31465. Fetch took: 79ms. Enumerating result took: 3ms
  1014. Number of elements fetched: 31465. Fetch took: 80ms. Enumerating result took: 3ms
  1015. Single element fetches
  1016. -------------------------
  1017. Number of elements fetched individually: 100. Total time: 83ms. Time per element: 0,83ms
  1018. Number of elements fetched individually: 100. Total time: 12ms. Time per element: 0,12ms
  1019. Number of elements fetched individually: 100. Total time: 12ms. Time per element: 0,12ms
  1020. Number of elements fetched individually: 100. Total time: 11ms. Time per element: 0,11ms
  1021. Number of elements fetched individually: 100. Total time: 11ms. Time per element: 0,11ms
  1022. Number of elements fetched individually: 100. Total time: 12ms. Time per element: 0,12ms
  1023. Number of elements fetched individually: 100. Total time: 12ms. Time per element: 0,12ms
  1024. Number of elements fetched individually: 100. Total time: 11ms. Time per element: 0,11ms
  1025. Number of elements fetched individually: 100. Total time: 11ms. Time per element: 0,11ms
  1026. Number of elements fetched individually: 100. Total time: 12ms. Time per element: 0,12ms
  1027. Number of elements fetched individually: 100. Total time: 12ms. Time per element: 0,12ms
  1028. Number of elements fetched individually: 100. Total time: 11ms. Time per element: 0,11ms
  1029. Number of elements fetched individually: 100. Total time: 12ms. Time per element: 0,12ms
  1030. Number of elements fetched individually: 100. Total time: 12ms. Time per element: 0,12ms
  1031. Number of elements fetched individually: 100. Total time: 11ms. Time per element: 0,11ms
  1032. Number of elements fetched individually: 100. Total time: 12ms. Time per element: 0,12ms
  1033. Number of elements fetched individually: 100. Total time: 13ms. Time per element: 0,13ms
  1034. Number of elements fetched individually: 100. Total time: 11ms. Time per element: 0,11ms
  1035. Number of elements fetched individually: 100. Total time: 22ms. Time per element: 0,22ms
  1036. Number of elements fetched individually: 100. Total time: 13ms. Time per element: 0,13ms
  1037. Number of elements fetched individually: 100. Total time: 12ms. Time per element: 0,12ms
  1038. Number of elements fetched individually: 100. Total time: 23ms. Time per element: 0,23ms
  1039. Number of elements fetched individually: 100. Total time: 12ms. Time per element: 0,12ms
  1040. Number of elements fetched individually: 100. Total time: 11ms. Time per element: 0,11ms
  1041. Number of elements fetched individually: 100. Total time: 12ms. Time per element: 0,12ms
  1042.  
  1043. LLBLGen Pro v4.2.0.0 (v4.2.15.1015). Change tracking: True. Caching: False.
  1044. --------------------------------------------------------------------------------------------
  1045. First one warm-up run to initialize constructs. Results will not be collected.
  1046. Number of elements fetched: 31465. Fetch took: 260ms. Enumerating result took: 3ms
  1047. Starting bench runs...
  1048. Set fetches
  1049. -------------------------
  1050. Number of elements fetched: 31465. Fetch took: 292ms. Enumerating result took: 3ms
  1051. Number of elements fetched: 31465. Fetch took: 262ms. Enumerating result took: 3ms
  1052. Number of elements fetched: 31465. Fetch took: 303ms. Enumerating result took: 3ms
  1053. Number of elements fetched: 31465. Fetch took: 274ms. Enumerating result took: 3ms
  1054. Number of elements fetched: 31465. Fetch took: 258ms. Enumerating result took: 3ms
  1055. Number of elements fetched: 31465. Fetch took: 271ms. Enumerating result took: 3ms
  1056. Number of elements fetched: 31465. Fetch took: 260ms. Enumerating result took: 3ms
  1057. Number of elements fetched: 31465. Fetch took: 270ms. Enumerating result took: 3ms
  1058. Number of elements fetched: 31465. Fetch took: 263ms. Enumerating result took: 4ms
  1059. Number of elements fetched: 31465. Fetch took: 278ms. Enumerating result took: 3ms
  1060. Number of elements fetched: 31465. Fetch took: 319ms. Enumerating result took: 3ms
  1061. Number of elements fetched: 31465. Fetch took: 271ms. Enumerating result took: 3ms
  1062. Number of elements fetched: 31465. Fetch took: 267ms. Enumerating result took: 3ms
  1063. Number of elements fetched: 31465. Fetch took: 288ms. Enumerating result took: 3ms
  1064. Number of elements fetched: 31465. Fetch took: 295ms. Enumerating result took: 3ms
  1065. Number of elements fetched: 31465. Fetch took: 303ms. Enumerating result took: 3ms
  1066. Number of elements fetched: 31465. Fetch took: 284ms. Enumerating result took: 3ms
  1067. Number of elements fetched: 31465. Fetch took: 280ms. Enumerating result took: 3ms
  1068. Number of elements fetched: 31465. Fetch took: 277ms. Enumerating result took: 3ms
  1069. Number of elements fetched: 31465. Fetch took: 327ms. Enumerating result took: 3ms
  1070. Number of elements fetched: 31465. Fetch took: 298ms. Enumerating result took: 3ms
  1071. Number of elements fetched: 31465. Fetch took: 298ms. Enumerating result took: 3ms
  1072. Number of elements fetched: 31465. Fetch took: 312ms. Enumerating result took: 3ms
  1073. Number of elements fetched: 31465. Fetch took: 309ms. Enumerating result took: 3ms
  1074. Number of elements fetched: 31465. Fetch took: 283ms. Enumerating result took: 3ms
  1075. Single element fetches
  1076. -------------------------
  1077. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  1078. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  1079. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  1080. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  1081. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  1082. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  1083. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  1084. Number of elements fetched individually: 100. Total time: 64ms. Time per element: 0,64ms
  1085. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  1086. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  1087. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  1088. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  1089. Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
  1090. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  1091. Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
  1092. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  1093. Number of elements fetched individually: 100. Total time: 72ms. Time per element: 0,72ms
  1094. Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
  1095. Number of elements fetched individually: 100. Total time: 71ms. Time per element: 0,71ms
  1096. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  1097. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  1098. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  1099. Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
  1100. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  1101. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  1102.  
  1103. Entity Framework v6.0.0.0 (v6.1.40302.0). Change tracking: True. Caching: False.
  1104. --------------------------------------------------------------------------------------------
  1105. First one warm-up run to initialize constructs. Results will not be collected.
  1106. Number of elements fetched: 31465. Fetch took: 2170ms. Enumerating result took: 2ms
  1107. Starting bench runs...
  1108. Set fetches
  1109. -------------------------
  1110. Number of elements fetched: 31465. Fetch took: 2205ms. Enumerating result took: 2ms
  1111. Number of elements fetched: 31465. Fetch took: 1885ms. Enumerating result took: 2ms
  1112. Number of elements fetched: 31465. Fetch took: 1911ms. Enumerating result took: 2ms
  1113. Number of elements fetched: 31465. Fetch took: 1942ms. Enumerating result took: 2ms
  1114. Number of elements fetched: 31465. Fetch took: 1941ms. Enumerating result took: 2ms
  1115. Number of elements fetched: 31465. Fetch took: 1931ms. Enumerating result took: 2ms
  1116. Number of elements fetched: 31465. Fetch took: 1919ms. Enumerating result took: 2ms
  1117. Number of elements fetched: 31465. Fetch took: 1955ms. Enumerating result took: 2ms
  1118. Number of elements fetched: 31465. Fetch took: 1925ms. Enumerating result took: 2ms
  1119. Number of elements fetched: 31465. Fetch took: 1932ms. Enumerating result took: 2ms
  1120. Number of elements fetched: 31465. Fetch took: 1955ms. Enumerating result took: 2ms
  1121. Number of elements fetched: 31465. Fetch took: 1938ms. Enumerating result took: 2ms
  1122. Number of elements fetched: 31465. Fetch took: 1940ms. Enumerating result took: 2ms
  1123. Number of elements fetched: 31465. Fetch took: 1924ms. Enumerating result took: 2ms
  1124. Number of elements fetched: 31465. Fetch took: 1962ms. Enumerating result took: 2ms
  1125. Number of elements fetched: 31465. Fetch took: 1932ms. Enumerating result took: 2ms
  1126. Number of elements fetched: 31465. Fetch took: 1957ms. Enumerating result took: 2ms
  1127. Number of elements fetched: 31465. Fetch took: 2015ms. Enumerating result took: 2ms
  1128. Number of elements fetched: 31465. Fetch took: 2004ms. Enumerating result took: 2ms
  1129. Number of elements fetched: 31465. Fetch took: 1988ms. Enumerating result took: 2ms
  1130. Number of elements fetched: 31465. Fetch took: 2013ms. Enumerating result took: 2ms
  1131. Number of elements fetched: 31465. Fetch took: 1985ms. Enumerating result took: 2ms
  1132. Number of elements fetched: 31465. Fetch took: 2026ms. Enumerating result took: 2ms
  1133. Number of elements fetched: 31465. Fetch took: 1927ms. Enumerating result took: 2ms
  1134. Number of elements fetched: 31465. Fetch took: 2052ms. Enumerating result took: 2ms
  1135. Single element fetches
  1136. -------------------------
  1137. Number of elements fetched individually: 100. Total time: 93ms. Time per element: 0,93ms
  1138. Number of elements fetched individually: 100. Total time: 89ms. Time per element: 0,89ms
  1139. Number of elements fetched individually: 100. Total time: 88ms. Time per element: 0,88ms
  1140. Number of elements fetched individually: 100. Total time: 88ms. Time per element: 0,88ms
  1141. Number of elements fetched individually: 100. Total time: 87ms. Time per element: 0,87ms
  1142. Number of elements fetched individually: 100. Total time: 86ms. Time per element: 0,86ms
  1143. Number of elements fetched individually: 100. Total time: 87ms. Time per element: 0,87ms
  1144. Number of elements fetched individually: 100. Total time: 85ms. Time per element: 0,85ms
  1145. Number of elements fetched individually: 100. Total time: 86ms. Time per element: 0,86ms
  1146. Number of elements fetched individually: 100. Total time: 86ms. Time per element: 0,86ms
  1147. Number of elements fetched individually: 100. Total time: 87ms. Time per element: 0,87ms
  1148. Number of elements fetched individually: 100. Total time: 87ms. Time per element: 0,87ms
  1149. Number of elements fetched individually: 100. Total time: 85ms. Time per element: 0,85ms
  1150. Number of elements fetched individually: 100. Total time: 91ms. Time per element: 0,91ms
  1151. Number of elements fetched individually: 100. Total time: 88ms. Time per element: 0,88ms
  1152. Number of elements fetched individually: 100. Total time: 90ms. Time per element: 0,9ms
  1153. Number of elements fetched individually: 100. Total time: 87ms. Time per element: 0,87ms
  1154. Number of elements fetched individually: 100. Total time: 90ms. Time per element: 0,9ms
  1155. Number of elements fetched individually: 100. Total time: 87ms. Time per element: 0,87ms
  1156. Number of elements fetched individually: 100. Total time: 87ms. Time per element: 0,87ms
  1157. Number of elements fetched individually: 100. Total time: 86ms. Time per element: 0,86ms
  1158. Number of elements fetched individually: 100. Total time: 89ms. Time per element: 0,89ms
  1159. Number of elements fetched individually: 100. Total time: 90ms. Time per element: 0,9ms
  1160. Number of elements fetched individually: 100. Total time: 86ms. Time per element: 0,86ms
  1161. Number of elements fetched individually: 100. Total time: 87ms. Time per element: 0,87ms
  1162.  
  1163. Oak.DynamicDb using dynamic Dto class. Change tracking: False. Caching: False.
  1164. --------------------------------------------------------------------------------------------
  1165. First one warm-up run to initialize constructs. Results will not be collected.
  1166. Number of elements fetched: 31465. Fetch took: 497ms. Enumerating result took: 81ms
  1167. Starting bench runs...
  1168. Set fetches
  1169. -------------------------
  1170. Number of elements fetched: 31465. Fetch took: 584ms. Enumerating result took: 82ms
  1171. Number of elements fetched: 31465. Fetch took: 541ms. Enumerating result took: 84ms
  1172. Number of elements fetched: 31465. Fetch took: 529ms. Enumerating result took: 84ms
  1173. Number of elements fetched: 31465. Fetch took: 528ms. Enumerating result took: 85ms
  1174. Number of elements fetched: 31465. Fetch took: 529ms. Enumerating result took: 88ms
  1175. Number of elements fetched: 31465. Fetch took: 535ms. Enumerating result took: 85ms
  1176. Number of elements fetched: 31465. Fetch took: 546ms. Enumerating result took: 83ms
  1177. Number of elements fetched: 31465. Fetch took: 537ms. Enumerating result took: 86ms
  1178. Number of elements fetched: 31465. Fetch took: 521ms. Enumerating result took: 82ms
  1179. Number of elements fetched: 31465. Fetch took: 539ms. Enumerating result took: 82ms
  1180. Number of elements fetched: 31465. Fetch took: 564ms. Enumerating result took: 93ms
  1181. Number of elements fetched: 31465. Fetch took: 586ms. Enumerating result took: 89ms
  1182. Number of elements fetched: 31465. Fetch took: 537ms. Enumerating result took: 84ms
  1183. Number of elements fetched: 31465. Fetch took: 539ms. Enumerating result took: 96ms
  1184. Number of elements fetched: 31465. Fetch took: 543ms. Enumerating result took: 82ms
  1185. Number of elements fetched: 31465. Fetch took: 525ms. Enumerating result took: 82ms
  1186. Number of elements fetched: 31465. Fetch took: 529ms. Enumerating result took: 81ms
  1187. Number of elements fetched: 31465. Fetch took: 526ms. Enumerating result took: 83ms
  1188. Number of elements fetched: 31465. Fetch took: 529ms. Enumerating result took: 81ms
  1189. Number of elements fetched: 31465. Fetch took: 527ms. Enumerating result took: 83ms
  1190. Number of elements fetched: 31465. Fetch took: 544ms. Enumerating result took: 83ms
  1191. Number of elements fetched: 31465. Fetch took: 530ms. Enumerating result took: 81ms
  1192. Number of elements fetched: 31465. Fetch took: 546ms. Enumerating result took: 86ms
  1193. Number of elements fetched: 31465. Fetch took: 547ms. Enumerating result took: 89ms
  1194. Number of elements fetched: 31465. Fetch took: 523ms. Enumerating result took: 84ms
  1195. Single element fetches
  1196. -------------------------
  1197. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  1198. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  1199. Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
  1200. Number of elements fetched individually: 100. Total time: 52ms. Time per element: 0,52ms
  1201. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  1202. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  1203. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  1204. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  1205. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  1206. Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
  1207. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  1208. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  1209. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  1210. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  1211. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  1212. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  1213. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  1214. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  1215. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  1216. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  1217. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  1218. Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
  1219. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  1220. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  1221. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  1222.  
  1223. Oak.DynamicDb using typed dynamic class. Change tracking: True. Caching: False.
  1224. --------------------------------------------------------------------------------------------
  1225. First one warm-up run to initialize constructs. Results will not be collected.
  1226. Number of elements fetched: 31465. Fetch took: 545ms. Enumerating result took: 669ms
  1227. Starting bench runs...
  1228. Set fetches
  1229. -------------------------
  1230. Number of elements fetched: 31465. Fetch took: 649ms. Enumerating result took: 645ms
  1231. Number of elements fetched: 31465. Fetch took: 522ms. Enumerating result took: 631ms
  1232. Number of elements fetched: 31465. Fetch took: 516ms. Enumerating result took: 643ms
  1233. Number of elements fetched: 31465. Fetch took: 544ms. Enumerating result took: 620ms
  1234. Number of elements fetched: 31465. Fetch took: 506ms. Enumerating result took: 626ms
  1235. Number of elements fetched: 31465. Fetch took: 551ms. Enumerating result took: 670ms
  1236. Number of elements fetched: 31465. Fetch took: 525ms. Enumerating result took: 608ms
  1237. Number of elements fetched: 31465. Fetch took: 517ms. Enumerating result took: 605ms
  1238. Number of elements fetched: 31465. Fetch took: 521ms. Enumerating result took: 623ms
  1239. Number of elements fetched: 31465. Fetch took: 506ms. Enumerating result took: 625ms
  1240. Number of elements fetched: 31465. Fetch took: 519ms. Enumerating result took: 640ms
  1241. Number of elements fetched: 31465. Fetch took: 538ms. Enumerating result took: 642ms
  1242. Number of elements fetched: 31465. Fetch took: 529ms. Enumerating result took: 598ms
  1243. Number of elements fetched: 31465. Fetch took: 528ms. Enumerating result took: 616ms
  1244. Number of elements fetched: 31465. Fetch took: 518ms. Enumerating result took: 621ms
  1245. Number of elements fetched: 31465. Fetch took: 515ms. Enumerating result took: 627ms
  1246. Number of elements fetched: 31465. Fetch took: 539ms. Enumerating result took: 628ms
  1247. Number of elements fetched: 31465. Fetch took: 520ms. Enumerating result took: 620ms
  1248. Number of elements fetched: 31465. Fetch took: 522ms. Enumerating result took: 603ms
  1249. Number of elements fetched: 31465. Fetch took: 517ms. Enumerating result took: 616ms
  1250. Number of elements fetched: 31465. Fetch took: 518ms. Enumerating result took: 627ms
  1251. Number of elements fetched: 31465. Fetch took: 523ms. Enumerating result took: 618ms
  1252. Number of elements fetched: 31465. Fetch took: 520ms. Enumerating result took: 602ms
  1253. Number of elements fetched: 31465. Fetch took: 520ms. Enumerating result took: 600ms
  1254. Number of elements fetched: 31465. Fetch took: 522ms. Enumerating result took: 609ms
  1255. Single element fetches
  1256. -------------------------
  1257. Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
  1258. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  1259. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  1260. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  1261. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  1262. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  1263. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  1264. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  1265. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  1266. Number of elements fetched individually: 100. Total time: 61ms. Time per element: 0,61ms
  1267. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  1268. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  1269. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  1270. Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
  1271. Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
  1272. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  1273. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  1274. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  1275. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  1276. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  1277. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  1278. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  1279. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  1280. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  1281. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  1282.  
  1283. NHibernate v4.0.0.4000 (v4.0.4.4000). Change tracking: True. Caching: False.
  1284. --------------------------------------------------------------------------------------------
  1285. First one warm-up run to initialize constructs. Results will not be collected.
  1286. Number of elements fetched: 31465. Fetch took: 2972ms. Enumerating result took: 1ms
  1287. Starting bench runs...
  1288. Set fetches
  1289. -------------------------
  1290. Number of elements fetched: 31465. Fetch took: 1852ms. Enumerating result took: 1ms
  1291. Number of elements fetched: 31465. Fetch took: 1854ms. Enumerating result took: 1ms
  1292. Number of elements fetched: 31465. Fetch took: 1811ms. Enumerating result took: 1ms
  1293. Number of elements fetched: 31465. Fetch took: 1809ms. Enumerating result took: 1ms
  1294. Number of elements fetched: 31465. Fetch took: 1822ms. Enumerating result took: 1ms
  1295. Number of elements fetched: 31465. Fetch took: 1768ms. Enumerating result took: 1ms
  1296. Number of elements fetched: 31465. Fetch took: 1817ms. Enumerating result took: 1ms
  1297. Number of elements fetched: 31465. Fetch took: 1796ms. Enumerating result took: 1ms
  1298. Number of elements fetched: 31465. Fetch took: 1818ms. Enumerating result took: 1ms
  1299. Number of elements fetched: 31465. Fetch took: 1808ms. Enumerating result took: 1ms
  1300. Number of elements fetched: 31465. Fetch took: 1821ms. Enumerating result took: 1ms
  1301. Number of elements fetched: 31465. Fetch took: 1805ms. Enumerating result took: 1ms
  1302. Number of elements fetched: 31465. Fetch took: 1815ms. Enumerating result took: 1ms
  1303. Number of elements fetched: 31465. Fetch took: 1799ms. Enumerating result took: 1ms
  1304. Number of elements fetched: 31465. Fetch took: 1832ms. Enumerating result took: 1ms
  1305. Number of elements fetched: 31465. Fetch took: 1820ms. Enumerating result took: 1ms
  1306. Number of elements fetched: 31465. Fetch took: 1845ms. Enumerating result took: 1ms
  1307. Number of elements fetched: 31465. Fetch took: 1856ms. Enumerating result took: 1ms
  1308. Number of elements fetched: 31465. Fetch took: 1857ms. Enumerating result took: 1ms
  1309. Number of elements fetched: 31465. Fetch took: 1862ms. Enumerating result took: 1ms
  1310. Number of elements fetched: 31465. Fetch took: 1863ms. Enumerating result took: 1ms
  1311. Number of elements fetched: 31465. Fetch took: 1848ms. Enumerating result took: 1ms
  1312. Number of elements fetched: 31465. Fetch took: 1875ms. Enumerating result took: 1ms
  1313. Number of elements fetched: 31465. Fetch took: 1849ms. Enumerating result took: 1ms
  1314. Number of elements fetched: 31465. Fetch took: 1874ms. Enumerating result took: 1ms
  1315. Single element fetches
  1316. -------------------------
  1317. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  1318. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  1319. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  1320. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  1321. Number of elements fetched individually: 100. Total time: 64ms. Time per element: 0,64ms
  1322. Number of elements fetched individually: 100. Total time: 64ms. Time per element: 0,64ms
  1323. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  1324. Number of elements fetched individually: 100. Total time: 64ms. Time per element: 0,64ms
  1325. Number of elements fetched individually: 100. Total time: 64ms. Time per element: 0,64ms
  1326. Number of elements fetched individually: 100. Total time: 61ms. Time per element: 0,61ms
  1327. Number of elements fetched individually: 100. Total time: 63ms. Time per element: 0,63ms
  1328. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  1329. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  1330. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  1331. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  1332. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  1333. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  1334. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  1335. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  1336. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  1337. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  1338. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  1339. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  1340. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  1341. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!