API tools faq
paste
Advertisement
Guest User

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

a guest
Feb 11th, 2014
1,780
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 46.41 KB | None | 0 0
raw download clone embed print report
  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
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!