Advertisement
Guest User

Raw .NET Data Access / ORM Fetch benchmarks 11-feb-2014

a guest
Feb 11th, 2014
1,567
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 46.41 KB | None
  1. client HW: Core2Duo quad, 4GB ram, Windows 8.0
  2. server HW: i5, 8GB ram, Windows Server 2012 64bit
  3. Network: 100BaseT / GB router
  4.  
  5. +-------------------------------------------------------------------------------------------
  6. | Raw Data Access / ORM Benchmarks.
  7. | Code available at : https://github.com/FransBouma/RawDataAccessBencher
  8. | Benchmarks run on : dinsdag 11 februari 2014 16:17:52
  9. | Registered benchmarks :
  10. | Handcoded materializer using DbDataReader. Change tracking: False. Caching: False.
  11. | Entity Framework v6.0.0.0 (v6.0.21211.0). Change tracking: False. Caching: False.
  12. | Entity Framework v6.0.0.0 (v6.0.21211.0). Change tracking: True. Caching: False.
  13. | Telerik DataAccess/OpenAccess Domain v4.0.3. Change tracking: True. Caching: False.
  14. | Telerik DataAccess/OpenAccess Fluent v4.0.3. Change tracking: True. Caching: False.
  15. | DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
  16. | Dapper. Change tracking: False. Caching: False.
  17. | Linq to Sql v4.0.0.0 (v4.0.30319.18408). Change tracking: False. Caching: False.
  18. | Linq to Sql v4.0.0.0 (v4.0.30319.18408). Change tracking: True. Caching: False.
  19. | LLBLGen Pro v4.1.0.0 (v4.1.14.0117), typed view. Change tracking: False. Caching: False.
  20. | LLBLGen Pro v4.1.0.0 (v4.1.14.0117). Change tracking: True. Caching: True.
  21. | LLBLGen Pro v4.1.0.0 (v4.1.14.0117). Change tracking: True. Caching: False.
  22. | NHibernate v3.3.1.4000 (v3.3.3.4001). Change tracking: True. Caching: False.
  23. | Oak.DynamicDb using dynamic Dto class. Change tracking: False. Caching: False.
  24. | Oak.DynamicDb using typed dynamic class. Change tracking: True. Caching: False.
  25. | ServiceStack OrmLite v4.0.9.0 (v4.0.9.0). Change tracking: False. Caching: False.
  26. | PetaPoco v4.0.3. Change tracking: False. Caching: False.
  27. | PetaPoco Fast v4.0.3. Change tracking: False. Caching: False.
  28. | Run set benchmarks : True
  29. | Run individual fetch benchmarks: True
  30. | Number of set fetches : 10
  31. | Number of individual keys : 100
  32. | Release build : True
  33. | Client OS : Microsoft Windows NT 6.2.9200.0 (32bit)
  34. | Bencher runs as 64bit : False
  35. | CLR version : 4.0.30319.18408
  36. | Number of CPUs : 4
  37. | Server used : nerd.sd.local
  38. | Catalog used : AdventureWorks
  39. | SQL Server version used : 11.00.3128
  40. +-------------------------------------------------------------------------------------------
  41.  
  42.  
  43. Warming up DB, DB client code and CLR
  44. ====================================================================
  45.  
  46. DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
  47. --------------------------------------------------------------------------------------------
  48. Number of elements fetched: 31465. Fetch took: 535ms. Enumerating result took: 51ms
  49. Number of elements fetched: 31465. Fetch took: 550ms. Enumerating result took: 53ms
  50. Number of elements fetched: 31465. Fetch took: 536ms. Enumerating result took: 50ms
  51. Number of elements fetched: 31465. Fetch took: 550ms. Enumerating result took: 52ms
  52. Number of elements fetched: 31465. Fetch took: 561ms. Enumerating result took: 52ms
  53. Number of elements fetched: 31465. Fetch took: 564ms. Enumerating result took: 52ms
  54. Number of elements fetched: 31465. Fetch took: 553ms. Enumerating result took: 51ms
  55. Number of elements fetched: 31465. Fetch took: 561ms. Enumerating result took: 52ms
  56. Number of elements fetched: 31465. Fetch took: 547ms. Enumerating result took: 51ms
  57. Number of elements fetched: 31465. Fetch took: 531ms. Enumerating result took: 51ms
  58.  
  59. Starting benchmarks.
  60. ====================================================================
  61.  
  62. Handcoded materializer using DbDataReader. Change tracking: False. Caching: False.
  63. --------------------------------------------------------------------------------------------
  64. Set fetches
  65. -------------------------
  66. Number of elements fetched: 31465. Fetch took: 500ms. Enumerating result took: 2ms
  67. Number of elements fetched: 31465. Fetch took: 500ms. Enumerating result took: 2ms
  68. Number of elements fetched: 31465. Fetch took: 499ms. Enumerating result took: 2ms
  69. Number of elements fetched: 31465. Fetch took: 502ms. Enumerating result took: 2ms
  70. Number of elements fetched: 31465. Fetch took: 503ms. Enumerating result took: 2ms
  71. Number of elements fetched: 31465. Fetch took: 497ms. Enumerating result took: 2ms
  72. Number of elements fetched: 31465. Fetch took: 500ms. Enumerating result took: 2ms
  73. Number of elements fetched: 31465. Fetch took: 502ms. Enumerating result took: 2ms
  74. Number of elements fetched: 31465. Fetch took: 503ms. Enumerating result took: 2ms
  75. Number of elements fetched: 31465. Fetch took: 497ms. Enumerating result took: 2ms
  76. Single element fetches
  77. -------------------------
  78. Number of elements fetched individually: 100. Total time: 80ms. Time per element: 0,8ms
  79. Number of elements fetched individually: 100. Total time: 76ms. Time per element: 0,76ms
  80. Number of elements fetched individually: 100. Total time: 75ms. Time per element: 0,75ms
  81. Number of elements fetched individually: 100. Total time: 76ms. Time per element: 0,76ms
  82. Number of elements fetched individually: 100. Total time: 76ms. Time per element: 0,76ms
  83. Number of elements fetched individually: 100. Total time: 76ms. Time per element: 0,76ms
  84. Number of elements fetched individually: 100. Total time: 76ms. Time per element: 0,76ms
  85. Number of elements fetched individually: 100. Total time: 75ms. Time per element: 0,75ms
  86. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  87. Number of elements fetched individually: 100. Total time: 78ms. Time per element: 0,78ms
  88.  
  89. Entity Framework v6.0.0.0 (v6.0.21211.0). Change tracking: False. Caching: False.
  90. --------------------------------------------------------------------------------------------
  91. Set fetches
  92. -------------------------
  93. Number of elements fetched: 31465. Fetch took: 2709ms. Enumerating result took: 2ms
  94. Number of elements fetched: 31465. Fetch took: 559ms. Enumerating result took: 2ms
  95. Number of elements fetched: 31465. Fetch took: 576ms. Enumerating result took: 2ms
  96. Number of elements fetched: 31465. Fetch took: 561ms. Enumerating result took: 3ms
  97. Number of elements fetched: 31465. Fetch took: 569ms. Enumerating result took: 2ms
  98. Number of elements fetched: 31465. Fetch took: 581ms. Enumerating result took: 2ms
  99. Number of elements fetched: 31465. Fetch took: 562ms. Enumerating result took: 2ms
  100. Number of elements fetched: 31465. Fetch took: 550ms. Enumerating result took: 2ms
  101. Number of elements fetched: 31465. Fetch took: 560ms. Enumerating result took: 3ms
  102. Number of elements fetched: 31465. Fetch took: 538ms. Enumerating result took: 2ms
  103. Single element fetches
  104. -------------------------
  105. Number of elements fetched individually: 100. Total time: 529ms. Time per element: 5,29ms
  106. Number of elements fetched individually: 100. Total time: 221ms. Time per element: 2,21ms
  107. Number of elements fetched individually: 100. Total time: 214ms. Time per element: 2,14ms
  108. Number of elements fetched individually: 100. Total time: 222ms. Time per element: 2,22ms
  109. Number of elements fetched individually: 100. Total time: 216ms. Time per element: 2,16ms
  110. Number of elements fetched individually: 100. Total time: 216ms. Time per element: 2,16ms
  111. Number of elements fetched individually: 100. Total time: 220ms. Time per element: 2,2ms
  112. Number of elements fetched individually: 100. Total time: 221ms. Time per element: 2,21ms
  113. Number of elements fetched individually: 100. Total time: 220ms. Time per element: 2,2ms
  114. Number of elements fetched individually: 100. Total time: 219ms. Time per element: 2,19ms
  115.  
  116. Entity Framework v6.0.0.0 (v6.0.21211.0). Change tracking: True. Caching: False.
  117. --------------------------------------------------------------------------------------------
  118. Set fetches
  119. -------------------------
  120. Number of elements fetched: 31465. Fetch took: 6776ms. Enumerating result took: 3ms
  121. Number of elements fetched: 31465. Fetch took: 6698ms. Enumerating result took: 3ms
  122. Number of elements fetched: 31465. Fetch took: 6698ms. Enumerating result took: 3ms
  123. Number of elements fetched: 31465. Fetch took: 6680ms. Enumerating result took: 3ms
  124. Number of elements fetched: 31465. Fetch took: 6677ms. Enumerating result took: 3ms
  125. Number of elements fetched: 31465. Fetch took: 6686ms. Enumerating result took: 3ms
  126. Number of elements fetched: 31465. Fetch took: 6681ms. Enumerating result took: 3ms
  127. Number of elements fetched: 31465. Fetch took: 6735ms. Enumerating result took: 3ms
  128. Number of elements fetched: 31465. Fetch took: 6679ms. Enumerating result took: 3ms
  129. Number of elements fetched: 31465. Fetch took: 6754ms. Enumerating result took: 3ms
  130. Single element fetches
  131. -------------------------
  132. Number of elements fetched individually: 100. Total time: 246ms. Time per element: 2,46ms
  133. Number of elements fetched individually: 100. Total time: 239ms. Time per element: 2,39ms
  134. Number of elements fetched individually: 100. Total time: 244ms. Time per element: 2,44ms
  135. Number of elements fetched individually: 100. Total time: 242ms. Time per element: 2,42ms
  136. Number of elements fetched individually: 100. Total time: 243ms. Time per element: 2,43ms
  137. Number of elements fetched individually: 100. Total time: 243ms. Time per element: 2,43ms
  138. Number of elements fetched individually: 100. Total time: 246ms. Time per element: 2,46ms
  139. Number of elements fetched individually: 100. Total time: 242ms. Time per element: 2,42ms
  140. Number of elements fetched individually: 100. Total time: 242ms. Time per element: 2,42ms
  141. Number of elements fetched individually: 100. Total time: 246ms. Time per element: 2,46ms
  142.  
  143. Telerik DataAccess/OpenAccess Domain v4.0.3. Change tracking: True. Caching: False.
  144. --------------------------------------------------------------------------------------------
  145. Set fetches
  146. -------------------------
  147. Number of elements fetched: 31465. Fetch took: 2802ms. Enumerating result took: 4ms
  148. Number of elements fetched: 31465. Fetch took: 1196ms. Enumerating result took: 3ms
  149. Number of elements fetched: 31465. Fetch took: 1200ms. Enumerating result took: 3ms
  150. Number of elements fetched: 31465. Fetch took: 1212ms. Enumerating result took: 3ms
  151. Number of elements fetched: 31465. Fetch took: 1188ms. Enumerating result took: 3ms
  152. Number of elements fetched: 31465. Fetch took: 1152ms. Enumerating result took: 3ms
  153. Number of elements fetched: 31465. Fetch took: 1189ms. Enumerating result took: 3ms
  154. Number of elements fetched: 31465. Fetch took: 1191ms. Enumerating result took: 3ms
  155. Number of elements fetched: 31465. Fetch took: 1200ms. Enumerating result took: 3ms
  156. Number of elements fetched: 31465. Fetch took: 1155ms. Enumerating result took: 3ms
  157. Single element fetches
  158. -------------------------
  159. Number of elements fetched individually: 100. Total time: 142ms. Time per element: 1,42ms
  160. Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
  161. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  162. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  163. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  164. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  165. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  166. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  167. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  168. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  169.  
  170. Telerik DataAccess/OpenAccess Fluent v4.0.3. Change tracking: True. Caching: False.
  171. --------------------------------------------------------------------------------------------
  172. Set fetches
  173. -------------------------
  174. Number of elements fetched: 31465. Fetch took: 2280ms. Enumerating result took: 3ms
  175. Number of elements fetched: 31465. Fetch took: 1160ms. Enumerating result took: 3ms
  176. Number of elements fetched: 31465. Fetch took: 1233ms. Enumerating result took: 4ms
  177. Number of elements fetched: 31465. Fetch took: 1249ms. Enumerating result took: 3ms
  178. Number of elements fetched: 31465. Fetch took: 1244ms. Enumerating result took: 3ms
  179. Number of elements fetched: 31465. Fetch took: 1201ms. Enumerating result took: 3ms
  180. Number of elements fetched: 31465. Fetch took: 1202ms. Enumerating result took: 3ms
  181. Number of elements fetched: 31465. Fetch took: 1200ms. Enumerating result took: 3ms
  182. Number of elements fetched: 31465. Fetch took: 1195ms. Enumerating result took: 3ms
  183. Number of elements fetched: 31465. Fetch took: 1223ms. Enumerating result took: 3ms
  184. Single element fetches
  185. -------------------------
  186. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  187. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  188. Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
  189. Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
  190. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  191. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  192. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  193. Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
  194. Number of elements fetched individually: 100. Total time: 70ms. Time per element: 0,7ms
  195. Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
  196.  
  197. DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
  198. --------------------------------------------------------------------------------------------
  199. Set fetches
  200. -------------------------
  201. Number of elements fetched: 31465. Fetch took: 535ms. Enumerating result took: 53ms
  202. Number of elements fetched: 31465. Fetch took: 534ms. Enumerating result took: 52ms
  203. Number of elements fetched: 31465. Fetch took: 535ms. Enumerating result took: 52ms
  204. Number of elements fetched: 31465. Fetch took: 534ms. Enumerating result took: 52ms
  205. Number of elements fetched: 31465. Fetch took: 535ms. Enumerating result took: 51ms
  206. Number of elements fetched: 31465. Fetch took: 534ms. Enumerating result took: 52ms
  207. Number of elements fetched: 31465. Fetch took: 529ms. Enumerating result took: 52ms
  208. Number of elements fetched: 31465. Fetch took: 531ms. Enumerating result took: 52ms
  209. Number of elements fetched: 31465. Fetch took: 529ms. Enumerating result took: 52ms
  210. Number of elements fetched: 31465. Fetch took: 529ms. Enumerating result took: 52ms
  211. Single element fetches
  212. -------------------------
  213. Number of elements fetched individually: 100. Total time: 72ms. Time per element: 0,72ms
  214. Number of elements fetched individually: 100. Total time: 80ms. Time per element: 0,8ms
  215. Number of elements fetched individually: 100. Total time: 75ms. Time per element: 0,75ms
  216. Number of elements fetched individually: 100. Total time: 76ms. Time per element: 0,76ms
  217. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  218. Number of elements fetched individually: 100. Total time: 75ms. Time per element: 0,75ms
  219. Number of elements fetched individually: 100. Total time: 71ms. Time per element: 0,71ms
  220. Number of elements fetched individually: 100. Total time: 71ms. Time per element: 0,71ms
  221. Number of elements fetched individually: 100. Total time: 70ms. Time per element: 0,7ms
  222. Number of elements fetched individually: 100. Total time: 70ms. Time per element: 0,7ms
  223.  
  224. Dapper. Change tracking: False. Caching: False.
  225. --------------------------------------------------------------------------------------------
  226. Set fetches
  227. -------------------------
  228. Number of elements fetched: 31465. Fetch took: 561ms. Enumerating result took: 2ms
  229. Number of elements fetched: 31465. Fetch took: 520ms. Enumerating result took: 2ms
  230. Number of elements fetched: 31465. Fetch took: 522ms. Enumerating result took: 2ms
  231. Number of elements fetched: 31465. Fetch took: 516ms. Enumerating result took: 2ms
  232. Number of elements fetched: 31465. Fetch took: 519ms. Enumerating result took: 2ms
  233. Number of elements fetched: 31465. Fetch took: 522ms. Enumerating result took: 2ms
  234. Number of elements fetched: 31465. Fetch took: 516ms. Enumerating result took: 2ms
  235. Number of elements fetched: 31465. Fetch took: 512ms. Enumerating result took: 2ms
  236. Number of elements fetched: 31465. Fetch took: 520ms. Enumerating result took: 2ms
  237. Number of elements fetched: 31465. Fetch took: 520ms. Enumerating result took: 2ms
  238. Single element fetches
  239. -------------------------
  240. Number of elements fetched individually: 100. Total time: 74ms. Time per element: 0,74ms
  241. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  242. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  243. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  244. Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
  245. Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
  246. Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
  247. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  248. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  249. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  250.  
  251. Linq to Sql v4.0.0.0 (v4.0.30319.18408). Change tracking: False. Caching: False.
  252. --------------------------------------------------------------------------------------------
  253. Set fetches
  254. -------------------------
  255. Number of elements fetched: 31465. Fetch took: 635ms. Enumerating result took: 8ms
  256. Number of elements fetched: 31465. Fetch took: 550ms. Enumerating result took: 3ms
  257. Number of elements fetched: 31465. Fetch took: 568ms. Enumerating result took: 4ms
  258. Number of elements fetched: 31465. Fetch took: 565ms. Enumerating result took: 3ms
  259. Number of elements fetched: 31465. Fetch took: 562ms. Enumerating result took: 3ms
  260. Number of elements fetched: 31465. Fetch took: 569ms. Enumerating result took: 3ms
  261. Number of elements fetched: 31465. Fetch took: 564ms. Enumerating result took: 3ms
  262. Number of elements fetched: 31465. Fetch took: 533ms. Enumerating result took: 2ms
  263. Number of elements fetched: 31465. Fetch took: 543ms. Enumerating result took: 2ms
  264. Number of elements fetched: 31465. Fetch took: 573ms. Enumerating result took: 2ms
  265. Single element fetches
  266. -------------------------
  267. Number of elements fetched individually: 100. Total time: 267ms. Time per element: 2,67ms
  268. Number of elements fetched individually: 100. Total time: 259ms. Time per element: 2,59ms
  269. Number of elements fetched individually: 100. Total time: 251ms. Time per element: 2,51ms
  270. Number of elements fetched individually: 100. Total time: 246ms. Time per element: 2,46ms
  271. Number of elements fetched individually: 100. Total time: 252ms. Time per element: 2,52ms
  272. Number of elements fetched individually: 100. Total time: 254ms. Time per element: 2,54ms
  273. Number of elements fetched individually: 100. Total time: 254ms. Time per element: 2,54ms
  274. Number of elements fetched individually: 100. Total time: 255ms. Time per element: 2,55ms
  275. Number of elements fetched individually: 100. Total time: 257ms. Time per element: 2,57ms
  276. Number of elements fetched individually: 100. Total time: 253ms. Time per element: 2,53ms
  277.  
  278. Linq to Sql v4.0.0.0 (v4.0.30319.18408). Change tracking: True. Caching: False.
  279. --------------------------------------------------------------------------------------------
  280. Set fetches
  281. -------------------------
  282. Number of elements fetched: 31465. Fetch took: 639ms. Enumerating result took: 3ms
  283. Number of elements fetched: 31465. Fetch took: 618ms. Enumerating result took: 3ms
  284. Number of elements fetched: 31465. Fetch took: 631ms. Enumerating result took: 3ms
  285. Number of elements fetched: 31465. Fetch took: 653ms. Enumerating result took: 2ms
  286. Number of elements fetched: 31465. Fetch took: 654ms. Enumerating result took: 3ms
  287. Number of elements fetched: 31465. Fetch took: 642ms. Enumerating result took: 3ms
  288. Number of elements fetched: 31465. Fetch took: 622ms. Enumerating result took: 2ms
  289. Number of elements fetched: 31465. Fetch took: 616ms. Enumerating result took: 3ms
  290. Number of elements fetched: 31465. Fetch took: 662ms. Enumerating result took: 2ms
  291. Number of elements fetched: 31465. Fetch took: 651ms. Enumerating result took: 3ms
  292. Single element fetches
  293. -------------------------
  294. Number of elements fetched individually: 100. Total time: 269ms. Time per element: 2,69ms
  295. Number of elements fetched individually: 100. Total time: 265ms. Time per element: 2,65ms
  296. Number of elements fetched individually: 100. Total time: 267ms. Time per element: 2,67ms
  297. Number of elements fetched individually: 100. Total time: 264ms. Time per element: 2,64ms
  298. Number of elements fetched individually: 100. Total time: 264ms. Time per element: 2,64ms
  299. Number of elements fetched individually: 100. Total time: 261ms. Time per element: 2,61ms
  300. Number of elements fetched individually: 100. Total time: 261ms. Time per element: 2,61ms
  301. Number of elements fetched individually: 100. Total time: 265ms. Time per element: 2,65ms
  302. Number of elements fetched individually: 100. Total time: 262ms. Time per element: 2,62ms
  303. Number of elements fetched individually: 100. Total time: 266ms. Time per element: 2,66ms
  304.  
  305. LLBLGen Pro v4.1.0.0 (v4.1.14.0117), typed view. Change tracking: False. Caching: False.
  306. --------------------------------------------------------------------------------------------
  307. Set fetches
  308. -------------------------
  309. Number of elements fetched: 31465. Fetch took: 754ms. Enumerating result took: 7ms
  310. Number of elements fetched: 31465. Fetch took: 744ms. Enumerating result took: 5ms
  311. Number of elements fetched: 31465. Fetch took: 753ms. Enumerating result took: 5ms
  312. Number of elements fetched: 31465. Fetch took: 729ms. Enumerating result took: 5ms
  313. Number of elements fetched: 31465. Fetch took: 709ms. Enumerating result took: 5ms
  314. Number of elements fetched: 31465. Fetch took: 712ms. Enumerating result took: 5ms
  315. Number of elements fetched: 31465. Fetch took: 716ms. Enumerating result took: 5ms
  316. Number of elements fetched: 31465. Fetch took: 748ms. Enumerating result took: 5ms
  317. Number of elements fetched: 31465. Fetch took: 737ms. Enumerating result took: 5ms
  318. Number of elements fetched: 31465. Fetch took: 749ms. Enumerating result took: 5ms
  319. Single element fetches
  320. -------------------------
  321. Number of elements fetched individually: 100. Total time: 165ms. Time per element: 1,65ms
  322. Number of elements fetched individually: 100. Total time: 158ms. Time per element: 1,58ms
  323. Number of elements fetched individually: 100. Total time: 147ms. Time per element: 1,47ms
  324. Number of elements fetched individually: 100. Total time: 155ms. Time per element: 1,55ms
  325. Number of elements fetched individually: 100. Total time: 155ms. Time per element: 1,55ms
  326. Number of elements fetched individually: 100. Total time: 158ms. Time per element: 1,58ms
  327. Number of elements fetched individually: 100. Total time: 162ms. Time per element: 1,62ms
  328. Number of elements fetched individually: 100. Total time: 148ms. Time per element: 1,48ms
  329. Number of elements fetched individually: 100. Total time: 152ms. Time per element: 1,52ms
  330. Number of elements fetched individually: 100. Total time: 154ms. Time per element: 1,54ms
  331.  
  332. LLBLGen Pro v4.1.0.0 (v4.1.14.0117). Change tracking: True. Caching: True.
  333. --------------------------------------------------------------------------------------------
  334. Set fetches
  335. -------------------------
  336. Number of elements fetched: 31465. Fetch took: 976ms. Enumerating result took: 16ms
  337. Number of elements fetched: 31465. Fetch took: 218ms. Enumerating result took: 7ms
  338. Number of elements fetched: 31465. Fetch took: 221ms. Enumerating result took: 7ms
  339. Number of elements fetched: 31465. Fetch took: 227ms. Enumerating result took: 7ms
  340. Number of elements fetched: 31465. Fetch took: 215ms. Enumerating result took: 7ms
  341. Number of elements fetched: 31465. Fetch took: 211ms. Enumerating result took: 7ms
  342. Number of elements fetched: 31465. Fetch took: 217ms. Enumerating result took: 7ms
  343. Number of elements fetched: 31465. Fetch took: 212ms. Enumerating result took: 7ms
  344. Number of elements fetched: 31465. Fetch took: 215ms. Enumerating result took: 7ms
  345. Number of elements fetched: 31465. Fetch took: 213ms. Enumerating result took: 7ms
  346. Single element fetches
  347. -------------------------
  348. Number of elements fetched individually: 100. Total time: 166ms. Time per element: 1,66ms
  349. Number of elements fetched individually: 100. Total time: 35ms. Time per element: 0,35ms
  350. Number of elements fetched individually: 100. Total time: 27ms. Time per element: 0,27ms
  351. Number of elements fetched individually: 100. Total time: 27ms. Time per element: 0,27ms
  352. Number of elements fetched individually: 100. Total time: 27ms. Time per element: 0,27ms
  353. Number of elements fetched individually: 100. Total time: 28ms. Time per element: 0,28ms
  354. Number of elements fetched individually: 100. Total time: 28ms. Time per element: 0,28ms
  355. Number of elements fetched individually: 100. Total time: 32ms. Time per element: 0,32ms
  356. Number of elements fetched individually: 100. Total time: 27ms. Time per element: 0,27ms
  357. Number of elements fetched individually: 100. Total time: 155ms. Time per element: 1,55ms
  358.  
  359. LLBLGen Pro v4.1.0.0 (v4.1.14.0117). Change tracking: True. Caching: False.
  360. --------------------------------------------------------------------------------------------
  361. Set fetches
  362. -------------------------
  363. Number of elements fetched: 31465. Fetch took: 759ms. Enumerating result took: 11ms
  364. Number of elements fetched: 31465. Fetch took: 654ms. Enumerating result took: 11ms
  365. Number of elements fetched: 31465. Fetch took: 693ms. Enumerating result took: 10ms
  366. Number of elements fetched: 31465. Fetch took: 676ms. Enumerating result took: 11ms
  367. Number of elements fetched: 31465. Fetch took: 685ms. Enumerating result took: 10ms
  368. Number of elements fetched: 31465. Fetch took: 693ms. Enumerating result took: 10ms
  369. Number of elements fetched: 31465. Fetch took: 680ms. Enumerating result took: 11ms
  370. Number of elements fetched: 31465. Fetch took: 684ms. Enumerating result took: 11ms
  371. Number of elements fetched: 31465. Fetch took: 682ms. Enumerating result took: 11ms
  372. Number of elements fetched: 31465. Fetch took: 689ms. Enumerating result took: 11ms
  373. Single element fetches
  374. -------------------------
  375. Number of elements fetched individually: 100. Total time: 149ms. Time per element: 1,49ms
  376. Number of elements fetched individually: 100. Total time: 123ms. Time per element: 1,23ms
  377. Number of elements fetched individually: 100. Total time: 118ms. Time per element: 1,18ms
  378. Number of elements fetched individually: 100. Total time: 123ms. Time per element: 1,23ms
  379. Number of elements fetched individually: 100. Total time: 122ms. Time per element: 1,22ms
  380. Number of elements fetched individually: 100. Total time: 117ms. Time per element: 1,17ms
  381. Number of elements fetched individually: 100. Total time: 115ms. Time per element: 1,15ms
  382. Number of elements fetched individually: 100. Total time: 116ms. Time per element: 1,16ms
  383. Number of elements fetched individually: 100. Total time: 117ms. Time per element: 1,17ms
  384. Number of elements fetched individually: 100. Total time: 115ms. Time per element: 1,15ms
  385.  
  386. NHibernate v3.3.1.4000 (v3.3.3.4001). Change tracking: True. Caching: False.
  387. --------------------------------------------------------------------------------------------
  388. Set fetches
  389. -------------------------
  390. Number of elements fetched: 31465. Fetch took: 6238ms. Enumerating result took: 4ms
  391. Number of elements fetched: 31465. Fetch took: 3934ms. Enumerating result took: 4ms
  392. Number of elements fetched: 31465. Fetch took: 3903ms. Enumerating result took: 4ms
  393. Number of elements fetched: 31465. Fetch took: 3889ms. Enumerating result took: 4ms
  394. Number of elements fetched: 31465. Fetch took: 3929ms. Enumerating result took: 4ms
  395. Number of elements fetched: 31465. Fetch took: 3871ms. Enumerating result took: 4ms
  396. Number of elements fetched: 31465. Fetch took: 3925ms. Enumerating result took: 4ms
  397. Number of elements fetched: 31465. Fetch took: 3906ms. Enumerating result took: 4ms
  398. Number of elements fetched: 31465. Fetch took: 3912ms. Enumerating result took: 4ms
  399. Number of elements fetched: 31465. Fetch took: 3883ms. Enumerating result took: 4ms
  400. Single element fetches
  401. -------------------------
  402. Number of elements fetched individually: 100. Total time: 147ms. Time per element: 1,47ms
  403. Number of elements fetched individually: 100. Total time: 135ms. Time per element: 1,35ms
  404. Number of elements fetched individually: 100. Total time: 131ms. Time per element: 1,31ms
  405. Number of elements fetched individually: 100. Total time: 133ms. Time per element: 1,33ms
  406. Number of elements fetched individually: 100. Total time: 131ms. Time per element: 1,31ms
  407. Number of elements fetched individually: 100. Total time: 133ms. Time per element: 1,33ms
  408. Number of elements fetched individually: 100. Total time: 137ms. Time per element: 1,37ms
  409. Number of elements fetched individually: 100. Total time: 126ms. Time per element: 1,26ms
  410. Number of elements fetched individually: 100. Total time: 130ms. Time per element: 1,3ms
  411. Number of elements fetched individually: 100. Total time: 130ms. Time per element: 1,3ms
  412.  
  413. Oak.DynamicDb using dynamic Dto class. Change tracking: False. Caching: False.
  414. --------------------------------------------------------------------------------------------
  415. Set fetches
  416. -------------------------
  417. Number of elements fetched: 31465. Fetch took: 1387ms. Enumerating result took: 210ms
  418. Number of elements fetched: 31465. Fetch took: 1219ms. Enumerating result took: 179ms
  419. Number of elements fetched: 31465. Fetch took: 1265ms. Enumerating result took: 174ms
  420. Number of elements fetched: 31465. Fetch took: 1290ms. Enumerating result took: 183ms
  421. Number of elements fetched: 31465. Fetch took: 1301ms. Enumerating result took: 206ms
  422. Number of elements fetched: 31465. Fetch took: 1230ms. Enumerating result took: 251ms
  423. Number of elements fetched: 31465. Fetch took: 1255ms. Enumerating result took: 181ms
  424. Number of elements fetched: 31465. Fetch took: 1292ms. Enumerating result took: 208ms
  425. Number of elements fetched: 31465. Fetch took: 1259ms. Enumerating result took: 283ms
  426. Number of elements fetched: 31465. Fetch took: 1264ms. Enumerating result took: 178ms
  427. Single element fetches
  428. -------------------------
  429. Number of elements fetched individually: 100. Total time: 63ms. Time per element: 0,63ms
  430. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  431. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  432. Number of elements fetched individually: 100. Total time: 64ms. Time per element: 0,64ms
  433. Number of elements fetched individually: 100. Total time: 63ms. Time per element: 0,63ms
  434. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  435. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  436. Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
  437. Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
  438. Number of elements fetched individually: 100. Total time: 64ms. Time per element: 0,64ms
  439.  
  440. Oak.DynamicDb using typed dynamic class. Change tracking: True. Caching: False.
  441. --------------------------------------------------------------------------------------------
  442. Set fetches
  443. -------------------------
  444. Number of elements fetched: 31465. Fetch took: 1333ms. Enumerating result took: 1612ms
  445. Number of elements fetched: 31465. Fetch took: 1270ms. Enumerating result took: 1676ms
  446. Number of elements fetched: 31465. Fetch took: 1336ms. Enumerating result took: 1557ms
  447. Number of elements fetched: 31465. Fetch took: 1340ms. Enumerating result took: 1562ms
  448. Number of elements fetched: 31465. Fetch took: 1294ms. Enumerating result took: 1636ms
  449. Number of elements fetched: 31465. Fetch took: 1226ms. Enumerating result took: 1656ms
  450. Number of elements fetched: 31465. Fetch took: 1294ms. Enumerating result took: 1631ms
  451. Number of elements fetched: 31465. Fetch took: 1299ms. Enumerating result took: 1648ms
  452. Number of elements fetched: 31465. Fetch took: 1326ms. Enumerating result took: 1578ms
  453. Number of elements fetched: 31465. Fetch took: 1281ms. Enumerating result took: 1687ms
  454. Single element fetches
  455. -------------------------
  456. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  457. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  458. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  459. Number of elements fetched individually: 100. Total time: 64ms. Time per element: 0,64ms
  460. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  461. Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
  462. Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
  463. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  464. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  465. Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
  466.  
  467. ServiceStack OrmLite v4.0.9.0 (v4.0.9.0). Change tracking: False. Caching: False.
  468. --------------------------------------------------------------------------------------------
  469. Set fetches
  470. -------------------------
  471. Number of elements fetched: 31465. Fetch took: 713ms. Enumerating result took: 2ms
  472. Number of elements fetched: 31465. Fetch took: 593ms. Enumerating result took: 2ms
  473. Number of elements fetched: 31465. Fetch took: 581ms. Enumerating result took: 2ms
  474. Number of elements fetched: 31465. Fetch took: 588ms. Enumerating result took: 2ms
  475. Number of elements fetched: 31465. Fetch took: 591ms. Enumerating result took: 2ms
  476. Number of elements fetched: 31465. Fetch took: 588ms. Enumerating result took: 2ms
  477. Number of elements fetched: 31465. Fetch took: 588ms. Enumerating result took: 2ms
  478. Number of elements fetched: 31465. Fetch took: 588ms. Enumerating result took: 2ms
  479. Number of elements fetched: 31465. Fetch took: 591ms. Enumerating result took: 2ms
  480. Number of elements fetched: 31465. Fetch took: 591ms. Enumerating result took: 2ms
  481. Single element fetches
  482. -------------------------
  483. Number of elements fetched individually: 100. Total time: 99ms. Time per element: 0,99ms
  484. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  485. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  486. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  487. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  488. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  489. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  490. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  491. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  492. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  493.  
  494. PetaPoco v4.0.3. Change tracking: False. Caching: False.
  495. --------------------------------------------------------------------------------------------
  496. Set fetches
  497. -------------------------
  498. Number of elements fetched: 31465. Fetch took: 543ms. Enumerating result took: 2ms
  499. Number of elements fetched: 31465. Fetch took: 502ms. Enumerating result took: 2ms
  500. Number of elements fetched: 31465. Fetch took: 515ms. Enumerating result took: 2ms
  501. Number of elements fetched: 31465. Fetch took: 530ms. Enumerating result took: 2ms
  502. Number of elements fetched: 31465. Fetch took: 525ms. Enumerating result took: 2ms
  503. Number of elements fetched: 31465. Fetch took: 500ms. Enumerating result took: 2ms
  504. Number of elements fetched: 31465. Fetch took: 513ms. Enumerating result took: 2ms
  505. Number of elements fetched: 31465. Fetch took: 526ms. Enumerating result took: 2ms
  506. Number of elements fetched: 31465. Fetch took: 504ms. Enumerating result took: 2ms
  507. Number of elements fetched: 31465. Fetch took: 512ms. Enumerating result took: 2ms
  508. Single element fetches
  509. -------------------------
  510. Number of elements fetched individually: 100. Total time: 376ms. Time per element: 3,76ms
  511. Number of elements fetched individually: 100. Total time: 376ms. Time per element: 3,76ms
  512. Number of elements fetched individually: 100. Total time: 374ms. Time per element: 3,74ms
  513. Number of elements fetched individually: 100. Total time: 377ms. Time per element: 3,77ms
  514. Number of elements fetched individually: 100. Total time: 377ms. Time per element: 3,77ms
  515. Number of elements fetched individually: 100. Total time: 374ms. Time per element: 3,74ms
  516. Number of elements fetched individually: 100. Total time: 375ms. Time per element: 3,75ms
  517. Number of elements fetched individually: 100. Total time: 375ms. Time per element: 3,75ms
  518. Number of elements fetched individually: 100. Total time: 377ms. Time per element: 3,77ms
  519. Number of elements fetched individually: 100. Total time: 375ms. Time per element: 3,75ms
  520.  
  521. PetaPoco Fast v4.0.3. Change tracking: False. Caching: False.
  522. --------------------------------------------------------------------------------------------
  523. Set fetches
  524. -------------------------
  525. Number of elements fetched: 31465. Fetch took: 497ms. Enumerating result took: 2ms
  526. Number of elements fetched: 31465. Fetch took: 498ms. Enumerating result took: 2ms
  527. Number of elements fetched: 31465. Fetch took: 498ms. Enumerating result took: 2ms
  528. Number of elements fetched: 31465. Fetch took: 504ms. Enumerating result took: 2ms
  529. Number of elements fetched: 31465. Fetch took: 530ms. Enumerating result took: 2ms
  530. Number of elements fetched: 31465. Fetch took: 509ms. Enumerating result took: 2ms
  531. Number of elements fetched: 31465. Fetch took: 504ms. Enumerating result took: 2ms
  532. Number of elements fetched: 31465. Fetch took: 503ms. Enumerating result took: 2ms
  533. Number of elements fetched: 31465. Fetch took: 500ms. Enumerating result took: 2ms
  534. Number of elements fetched: 31465. Fetch took: 500ms. Enumerating result took: 3ms
  535. Single element fetches
  536. -------------------------
  537. Number of elements fetched individually: 100. Total time: 103ms. Time per element: 1,03ms
  538. Number of elements fetched individually: 100. Total time: 101ms. Time per element: 1,01ms
  539. Number of elements fetched individually: 100. Total time: 96ms. Time per element: 0,96ms
  540. Number of elements fetched individually: 100. Total time: 97ms. Time per element: 0,97ms
  541. Number of elements fetched individually: 100. Total time: 101ms. Time per element: 1,01ms
  542. Number of elements fetched individually: 100. Total time: 102ms. Time per element: 1,02ms
  543. Number of elements fetched individually: 100. Total time: 101ms. Time per element: 1,01ms
  544. Number of elements fetched individually: 100. Total time: 98ms. Time per element: 0,98ms
  545. Number of elements fetched individually: 100. Total time: 97ms. Time per element: 0,97ms
  546. Number of elements fetched individually: 100. Total time: 98ms. Time per element: 0,98ms
  547.  
  548. Averaged total results per framework. Fastest and slowest result omited
  549. ==============================================================================
  550. Non-change tracking fetches, set fetches (10 runs), no caching
  551. ------------------------------------------------------------------------------
  552. Handcoded materializer using DbDataReader : 500,38ms. Enumeration average: 2,00ms
  553. PetaPoco Fast v4.0.3 : 502,00ms. Enumeration average: 2,00ms
  554. PetaPoco v4.0.3 : 515,88ms. Enumeration average: 2,00ms
  555. Dapper : 519,38ms. Enumeration average: 2,00ms
  556. Linq to Sql v4.0.0.0 (v4.0.30319.18408) : 561,75ms. Enumeration average: 2,88ms
  557. Entity Framework v6.0.0.0 (v6.0.21211.0) : 564,75ms. Enumeration average: 2,13ms
  558. ServiceStack OrmLite v4.0.9.0 (v4.0.9.0) : 589,75ms. Enumeration average: 2,00ms
  559. LLBLGen Pro v4.1.0.0 (v4.1.14.0117), typed view : 736,00ms. Enumeration average: 5,00ms
  560. Oak.DynamicDb using dynamic Dto class : 1.269,50ms. Enumeration average: 199,50ms
  561.  
  562. Change tracking fetches, set fetches (10 runs), no caching
  563. ------------------------------------------------------------------------------
  564. DataTable, using DbDataAdapter : 532,63ms. Enumeration average: 52,00ms
  565. Linq to Sql v4.0.0.0 (v4.0.30319.18408) : 638,75ms. Enumeration average: 2,75ms
  566. LLBLGen Pro v4.1.0.0 (v4.1.14.0117) : 685,25ms. Enumeration average: 10,75ms
  567. Telerik DataAccess/OpenAccess Domain v4.0.3 : 1.191,38ms. Enumeration average: 3,00ms
  568. Telerik DataAccess/OpenAccess Fluent v4.0.3 : 1.218,38ms. Enumeration average: 3,00ms
  569. Oak.DynamicDb using typed dynamic class : 1.304,13ms. Enumeration average: 1.624,88ms
  570. NHibernate v3.3.1.4000 (v3.3.3.4001) : 3.910,13ms. Enumeration average: 4,00ms
  571. Entity Framework v6.0.0.0 (v6.0.21211.0) : 6.701,38ms. Enumeration average: 3,00ms
  572.  
  573. Non-change tracking individual fetches (100 elements, 10 runs), no caching
  574. ------------------------------------------------------------------------------
  575. Dapper : 0,58ms per individual fetch
  576. Oak.DynamicDb using dynamic Dto class : 0,62ms per individual fetch
  577. ServiceStack OrmLite v4.0.9.0 (v4.0.9.0) : 0,67ms per individual fetch
  578. Handcoded materializer using DbDataReader : 0,76ms per individual fetch
  579. PetaPoco Fast v4.0.3 : 0,99ms per individual fetch
  580. LLBLGen Pro v4.1.0.0 (v4.1.14.0117), typed view : 1,55ms per individual fetch
  581. Entity Framework v6.0.0.0 (v6.0.21211.0) : 2,19ms per individual fetch
  582. Linq to Sql v4.0.0.0 (v4.0.30319.18408) : 2,54ms per individual fetch
  583. PetaPoco v4.0.3 : 3,76ms per individual fetch
  584.  
  585. Change tracking individual fetches (100 elements, 10 runs), no caching
  586. ------------------------------------------------------------------------------
  587. Telerik DataAccess/OpenAccess Domain v4.0.3 : 0,67ms per individual fetch
  588. Oak.DynamicDb using typed dynamic class : 0,67ms per individual fetch
  589. Telerik DataAccess/OpenAccess Fluent v4.0.3 : 0,69ms per individual fetch
  590. DataTable, using DbDataAdapter : 0,73ms per individual fetch
  591. LLBLGen Pro v4.1.0.0 (v4.1.14.0117) : 1,19ms per individual fetch
  592. NHibernate v3.3.1.4000 (v3.3.3.4001) : 1,33ms per individual fetch
  593. Entity Framework v6.0.0.0 (v6.0.21211.0) : 2,44ms per individual fetch
  594. Linq to Sql v4.0.0.0 (v4.0.30319.18408) : 2,64ms per individual fetch
  595.  
  596. Change tracking fetches, set fetches (10 runs), caching
  597. ------------------------------------------------------------------------------
  598. LLBLGen Pro v4.1.0.0 (v4.1.14.0117) : 217,25ms. Enumeration average: 7,00ms
  599.  
  600. Change tracking individual fetches (100 elements, 10 runs), caching
  601. ------------------------------------------------------------------------------
  602. LLBLGen Pro v4.1.0.0 (v4.1.14.0117) : 0,45ms per individual fetch
  603.  
  604. Complete. Press enter to exit.
Advertisement
RAW Paste Data Copied
Advertisement