API tools faq
paste
Advertisement
Guest User

Raw .NET Data Access / ORM Fetch benchmarks 2

a guest
Jan 31st, 2014
163
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 39.66 KB | None | 0 0
raw download clone embed print report
  1. // Raw .NET Data Access / ORM Fetch benchmarks
  2. // Ran on: January 31st.
  3. // Source: https://github.com/FransBouma/RawDataAccessBencher
  4. // Client: Windows 8 32bit, .NET 4.5.1, Core2Duo quad, 4GB ram
  5. // Server: Windows 2012R2, SQL Server 2012, AdventureWorks 2008, i5 haswell, 8GB ram
  6. // Network: 100BaseT.
  7. ------------------------------------------------------------------------------------------------
  8. Warming up DB, DB client code and CLR
  9. ====================================================================
  10.  
  11. DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
  12. --------------------------------------------------------------------------------------------
  13. Number of elements fetched: 31465. Fetch took: 842ms. Enumerating result took: 52ms
  14. Number of elements fetched: 31465. Fetch took: 512ms. Enumerating result took: 50ms
  15. Number of elements fetched: 31465. Fetch took: 507ms. Enumerating result took: 53ms
  16. Number of elements fetched: 31465. Fetch took: 508ms. Enumerating result took: 81ms
  17. Number of elements fetched: 31465. Fetch took: 535ms. Enumerating result took: 52ms
  18. Number of elements fetched: 31465. Fetch took: 524ms. Enumerating result took: 50ms
  19. Number of elements fetched: 31465. Fetch took: 517ms. Enumerating result took: 53ms
  20. Number of elements fetched: 31465. Fetch took: 540ms. Enumerating result took: 51ms
  21. Number of elements fetched: 31465. Fetch took: 525ms. Enumerating result took: 50ms
  22. Number of elements fetched: 31465. Fetch took: 515ms. Enumerating result took: 53ms
  23.  
  24. Starting benchmarks.
  25. ====================================================================
  26. Do set benchmarks: True.
  27. Do single element benchmarks: True
  28.  
  29. Handcoded materializer using DbDataReader. Change tracking: False. Caching: False.
  30. --------------------------------------------------------------------------------------------
  31. Set fetches
  32. -------------------------
  33. Number of elements fetched: 31465. Fetch took: 530ms. Enumerating result took: 2ms
  34. Number of elements fetched: 31465. Fetch took: 496ms. Enumerating result took: 2ms
  35. Number of elements fetched: 31465. Fetch took: 496ms. Enumerating result took: 2ms
  36. Number of elements fetched: 31465. Fetch took: 496ms. Enumerating result took: 2ms
  37. Number of elements fetched: 31465. Fetch took: 495ms. Enumerating result took: 2ms
  38. Number of elements fetched: 31465. Fetch took: 495ms. Enumerating result took: 2ms
  39. Number of elements fetched: 31465. Fetch took: 496ms. Enumerating result took: 2ms
  40. Number of elements fetched: 31465. Fetch took: 496ms. Enumerating result took: 2ms
  41. Number of elements fetched: 31465. Fetch took: 496ms. Enumerating result took: 2ms
  42. Number of elements fetched: 31465. Fetch took: 496ms. Enumerating result took: 2ms
  43. Single element fetches
  44. -------------------------
  45. Number of elements fetched individually: 100. Total time: 84ms. Time per element: 0,84ms
  46. Number of elements fetched individually: 100. Total time: 92ms. Time per element: 0,92ms
  47. Number of elements fetched individually: 100. Total time: 80ms. Time per element: 0,8ms
  48. Number of elements fetched individually: 100. Total time: 82ms. Time per element: 0,82ms
  49. Number of elements fetched individually: 100. Total time: 82ms. Time per element: 0,82ms
  50. Number of elements fetched individually: 100. Total time: 80ms. Time per element: 0,8ms
  51. Number of elements fetched individually: 100. Total time: 81ms. Time per element: 0,81ms
  52. Number of elements fetched individually: 100. Total time: 82ms. Time per element: 0,82ms
  53. Number of elements fetched individually: 100. Total time: 82ms. Time per element: 0,82ms
  54. Number of elements fetched individually: 100. Total time: 82ms. Time per element: 0,82ms
  55.  
  56. DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
  57. --------------------------------------------------------------------------------------------
  58. Set fetches
  59. -------------------------
  60. Number of elements fetched: 31465. Fetch took: 531ms. Enumerating result took: 49ms
  61. Number of elements fetched: 31465. Fetch took: 522ms. Enumerating result took: 49ms
  62. Number of elements fetched: 31465. Fetch took: 523ms. Enumerating result took: 49ms
  63. Number of elements fetched: 31465. Fetch took: 531ms. Enumerating result took: 48ms
  64. Number of elements fetched: 31465. Fetch took: 530ms. Enumerating result took: 49ms
  65. Number of elements fetched: 31465. Fetch took: 531ms. Enumerating result took: 49ms
  66. Number of elements fetched: 31465. Fetch took: 522ms. Enumerating result took: 49ms
  67. Number of elements fetched: 31465. Fetch took: 530ms. Enumerating result took: 49ms
  68. Number of elements fetched: 31465. Fetch took: 531ms. Enumerating result took: 49ms
  69. Number of elements fetched: 31465. Fetch took: 531ms. Enumerating result took: 49ms
  70. Single element fetches
  71. -------------------------
  72. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  73. Number of elements fetched individually: 100. Total time: 71ms. Time per element: 0,71ms
  74. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  75. Number of elements fetched individually: 100. Total time: 71ms. Time per element: 0,71ms
  76. Number of elements fetched individually: 100. Total time: 72ms. Time per element: 0,72ms
  77. Number of elements fetched individually: 100. Total time: 74ms. Time per element: 0,74ms
  78. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  79. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  80. Number of elements fetched individually: 100. Total time: 75ms. Time per element: 0,75ms
  81. Number of elements fetched individually: 100. Total time: 72ms. Time per element: 0,72ms
  82.  
  83. Dapper. Change tracking: False. Caching: False.
  84. --------------------------------------------------------------------------------------------
  85. Set fetches
  86. -------------------------
  87. Number of elements fetched: 31465. Fetch took: 552ms. Enumerating result took: 2ms
  88. Number of elements fetched: 31465. Fetch took: 521ms. Enumerating result took: 2ms
  89. Number of elements fetched: 31465. Fetch took: 521ms. Enumerating result took: 2ms
  90. Number of elements fetched: 31465. Fetch took: 520ms. Enumerating result took: 2ms
  91. Number of elements fetched: 31465. Fetch took: 521ms. Enumerating result took: 2ms
  92. Number of elements fetched: 31465. Fetch took: 520ms. Enumerating result took: 2ms
  93. Number of elements fetched: 31465. Fetch took: 522ms. Enumerating result took: 2ms
  94. Number of elements fetched: 31465. Fetch took: 521ms. Enumerating result took: 2ms
  95. Number of elements fetched: 31465. Fetch took: 522ms. Enumerating result took: 2ms
  96. Number of elements fetched: 31465. Fetch took: 521ms. Enumerating result took: 2ms
  97. Single element fetches
  98. -------------------------
  99. Number of elements fetched individually: 100. Total time: 78ms. Time per element: 0,78ms
  100. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  101. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  102. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  103. Number of elements fetched individually: 100. Total time: 64ms. Time per element: 0,64ms
  104. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  105. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  106. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  107. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  108. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  109.  
  110. Entity Framework v6.0.0.0 (v6.1.0.0). Change tracking: False. Caching: False.
  111. --------------------------------------------------------------------------------------------
  112. Set fetches
  113. -------------------------
  114. Number of elements fetched: 31465. Fetch took: 3009ms. Enumerating result took: 3ms
  115. Number of elements fetched: 31465. Fetch took: 469ms. Enumerating result took: 3ms
  116. Number of elements fetched: 31465. Fetch took: 468ms. Enumerating result took: 3ms
  117. Number of elements fetched: 31465. Fetch took: 468ms. Enumerating result took: 3ms
  118. Number of elements fetched: 31465. Fetch took: 468ms. Enumerating result took: 3ms
  119. Number of elements fetched: 31465. Fetch took: 476ms. Enumerating result took: 3ms
  120. Number of elements fetched: 31465. Fetch took: 468ms. Enumerating result took: 3ms
  121. Number of elements fetched: 31465. Fetch took: 467ms. Enumerating result took: 3ms
  122. Number of elements fetched: 31465. Fetch took: 469ms. Enumerating result took: 3ms
  123. Number of elements fetched: 31465. Fetch took: 470ms. Enumerating result took: 3ms
  124. Single element fetches
  125. -------------------------
  126. Number of elements fetched individually: 100. Total time: 523ms. Time per element: 5,23ms
  127. Number of elements fetched individually: 100. Total time: 208ms. Time per element: 2,08ms
  128. Number of elements fetched individually: 100. Total time: 210ms. Time per element: 2,1ms
  129. Number of elements fetched individually: 100. Total time: 209ms. Time per element: 2,09ms
  130. Number of elements fetched individually: 100. Total time: 206ms. Time per element: 2,06ms
  131. Number of elements fetched individually: 100. Total time: 205ms. Time per element: 2,05ms
  132. Number of elements fetched individually: 100. Total time: 207ms. Time per element: 2,07ms
  133. Number of elements fetched individually: 100. Total time: 206ms. Time per element: 2,06ms
  134. Number of elements fetched individually: 100. Total time: 206ms. Time per element: 2,06ms
  135. Number of elements fetched individually: 100. Total time: 208ms. Time per element: 2,08ms
  136.  
  137. Entity Framework v6.0.0.0 (v6.1.0.0). Change tracking: True. Caching: False.
  138. --------------------------------------------------------------------------------------------
  139. Set fetches
  140. -------------------------
  141. Number of elements fetched: 31465. Fetch took: 2991ms. Enumerating result took: 4ms
  142. Number of elements fetched: 31465. Fetch took: 2828ms. Enumerating result took: 4ms
  143. Number of elements fetched: 31465. Fetch took: 2833ms. Enumerating result took: 4ms
  144. Number of elements fetched: 31465. Fetch took: 2824ms. Enumerating result took: 4ms
  145. Number of elements fetched: 31465. Fetch took: 2828ms. Enumerating result took: 4ms
  146. Number of elements fetched: 31465. Fetch took: 2824ms. Enumerating result took: 4ms
  147. Number of elements fetched: 31465. Fetch took: 2839ms. Enumerating result took: 4ms
  148. Number of elements fetched: 31465. Fetch took: 2837ms. Enumerating result took: 4ms
  149. Number of elements fetched: 31465. Fetch took: 2817ms. Enumerating result took: 4ms
  150. Number of elements fetched: 31465. Fetch took: 2845ms. Enumerating result took: 4ms
  151. Single element fetches
  152. -------------------------
  153. Number of elements fetched individually: 100. Total time: 288ms. Time per element: 2,88ms
  154. Number of elements fetched individually: 100. Total time: 277ms. Time per element: 2,77ms
  155. Number of elements fetched individually: 100. Total time: 279ms. Time per element: 2,79ms
  156. Number of elements fetched individually: 100. Total time: 275ms. Time per element: 2,75ms
  157. Number of elements fetched individually: 100. Total time: 276ms. Time per element: 2,76ms
  158. Number of elements fetched individually: 100. Total time: 279ms. Time per element: 2,79ms
  159. Number of elements fetched individually: 100. Total time: 282ms. Time per element: 2,82ms
  160. Number of elements fetched individually: 100. Total time: 276ms. Time per element: 2,76ms
  161. Number of elements fetched individually: 100. Total time: 276ms. Time per element: 2,76ms
  162. Number of elements fetched individually: 100. Total time: 277ms. Time per element: 2,77ms
  163.  
  164. Linq to Sql v4.0.0.0 (v4.0.30319.18408). Change tracking: False. Caching: False.
  165. --------------------------------------------------------------------------------------------
  166. Set fetches
  167. -------------------------
  168. Number of elements fetched: 31465. Fetch took: 606ms. Enumerating result took: 3ms
  169. Number of elements fetched: 31465. Fetch took: 536ms. Enumerating result took: 2ms
  170. Number of elements fetched: 31465. Fetch took: 563ms. Enumerating result took: 3ms
  171. Number of elements fetched: 31465. Fetch took: 560ms. Enumerating result took: 2ms
  172. Number of elements fetched: 31465. Fetch took: 556ms. Enumerating result took: 3ms
  173. Number of elements fetched: 31465. Fetch took: 561ms. Enumerating result took: 2ms
  174. Number of elements fetched: 31465. Fetch took: 565ms. Enumerating result took: 4ms
  175. Number of elements fetched: 31465. Fetch took: 560ms. Enumerating result took: 2ms
  176. Number of elements fetched: 31465. Fetch took: 570ms. Enumerating result took: 3ms
  177. Number of elements fetched: 31465. Fetch took: 555ms. Enumerating result took: 2ms
  178. Single element fetches
  179. -------------------------
  180. Number of elements fetched individually: 100. Total time: 264ms. Time per element: 2,64ms
  181. Number of elements fetched individually: 100. Total time: 261ms. Time per element: 2,61ms
  182. Number of elements fetched individually: 100. Total time: 259ms. Time per element: 2,59ms
  183. Number of elements fetched individually: 100. Total time: 259ms. Time per element: 2,59ms
  184. Number of elements fetched individually: 100. Total time: 258ms. Time per element: 2,58ms
  185. Number of elements fetched individually: 100. Total time: 259ms. Time per element: 2,59ms
  186. Number of elements fetched individually: 100. Total time: 258ms. Time per element: 2,58ms
  187. Number of elements fetched individually: 100. Total time: 260ms. Time per element: 2,6ms
  188. Number of elements fetched individually: 100. Total time: 261ms. Time per element: 2,61ms
  189. Number of elements fetched individually: 100. Total time: 257ms. Time per element: 2,57ms
  190.  
  191. Linq to Sql v4.0.0.0 (v4.0.30319.18408). Change tracking: True. Caching: False.
  192. --------------------------------------------------------------------------------------------
  193. Set fetches
  194. -------------------------
  195. Number of elements fetched: 31465. Fetch took: 628ms. Enumerating result took: 3ms
  196. Number of elements fetched: 31465. Fetch took: 647ms. Enumerating result took: 3ms
  197. Number of elements fetched: 31465. Fetch took: 635ms. Enumerating result took: 3ms
  198. Number of elements fetched: 31465. Fetch took: 661ms. Enumerating result took: 2ms
  199. Number of elements fetched: 31465. Fetch took: 663ms. Enumerating result took: 3ms
  200. Number of elements fetched: 31465. Fetch took: 635ms. Enumerating result took: 3ms
  201. Number of elements fetched: 31465. Fetch took: 612ms. Enumerating result took: 3ms
  202. Number of elements fetched: 31465. Fetch took: 629ms. Enumerating result took: 3ms
  203. Number of elements fetched: 31465. Fetch took: 634ms. Enumerating result took: 2ms
  204. Number of elements fetched: 31465. Fetch took: 626ms. Enumerating result took: 3ms
  205. Single element fetches
  206. -------------------------
  207. Number of elements fetched individually: 100. Total time: 271ms. Time per element: 2,71ms
  208. Number of elements fetched individually: 100. Total time: 272ms. Time per element: 2,72ms
  209. Number of elements fetched individually: 100. Total time: 274ms. Time per element: 2,74ms
  210. Number of elements fetched individually: 100. Total time: 274ms. Time per element: 2,74ms
  211. Number of elements fetched individually: 100. Total time: 274ms. Time per element: 2,74ms
  212. Number of elements fetched individually: 100. Total time: 271ms. Time per element: 2,71ms
  213. Number of elements fetched individually: 100. Total time: 272ms. Time per element: 2,72ms
  214. Number of elements fetched individually: 100. Total time: 269ms. Time per element: 2,69ms
  215. Number of elements fetched individually: 100. Total time: 275ms. Time per element: 2,75ms
  216. Number of elements fetched individually: 100. Total time: 279ms. Time per element: 2,79ms
  217.  
  218. LLBLGen Pro v4.1.0.0 (v4.1.14.0117), typed view. Change tracking: False. Caching: False.
  219. --------------------------------------------------------------------------------------------
  220. Set fetches
  221. -------------------------
  222. Number of elements fetched: 31465. Fetch took: 743ms. Enumerating result took: 7ms
  223. Number of elements fetched: 31465. Fetch took: 734ms. Enumerating result took: 5ms
  224. Number of elements fetched: 31465. Fetch took: 728ms. Enumerating result took: 5ms
  225. Number of elements fetched: 31465. Fetch took: 731ms. Enumerating result took: 5ms
  226. Number of elements fetched: 31465. Fetch took: 727ms. Enumerating result took: 5ms
  227. Number of elements fetched: 31465. Fetch took: 726ms. Enumerating result took: 5ms
  228. Number of elements fetched: 31465. Fetch took: 726ms. Enumerating result took: 5ms
  229. Number of elements fetched: 31465. Fetch took: 736ms. Enumerating result took: 5ms
  230. Number of elements fetched: 31465. Fetch took: 725ms. Enumerating result took: 5ms
  231. Number of elements fetched: 31465. Fetch took: 734ms. Enumerating result took: 5ms
  232. Single element fetches
  233. -------------------------
  234. Number of elements fetched individually: 100. Total time: 160ms. Time per element: 1,6ms
  235. Number of elements fetched individually: 100. Total time: 157ms. Time per element: 1,57ms
  236. Number of elements fetched individually: 100. Total time: 161ms. Time per element: 1,61ms
  237. Number of elements fetched individually: 100. Total time: 157ms. Time per element: 1,57ms
  238. Number of elements fetched individually: 100. Total time: 158ms. Time per element: 1,58ms
  239. Number of elements fetched individually: 100. Total time: 157ms. Time per element: 1,57ms
  240. Number of elements fetched individually: 100. Total time: 163ms. Time per element: 1,63ms
  241. Number of elements fetched individually: 100. Total time: 161ms. Time per element: 1,61ms
  242. Number of elements fetched individually: 100. Total time: 165ms. Time per element: 1,65ms
  243. Number of elements fetched individually: 100. Total time: 166ms. Time per element: 1,66ms
  244.  
  245. LLBLGen Pro v4.1.0.0 (v4.1.14.0117). Change tracking: True. Caching: True.
  246. --------------------------------------------------------------------------------------------
  247. Set fetches
  248. -------------------------
  249. Number of elements fetched: 31465. Fetch took: 940ms. Enumerating result took: 16ms
  250. Number of elements fetched: 31465. Fetch took: 214ms. Enumerating result took: 7ms
  251. Number of elements fetched: 31465. Fetch took: 207ms. Enumerating result took: 7ms
  252. Number of elements fetched: 31465. Fetch took: 165ms. Enumerating result took: 7ms
  253. Number of elements fetched: 31465. Fetch took: 208ms. Enumerating result took: 7ms
  254. Number of elements fetched: 31465. Fetch took: 208ms. Enumerating result took: 7ms
  255. Number of elements fetched: 31465. Fetch took: 159ms. Enumerating result took: 7ms
  256. Number of elements fetched: 31465. Fetch took: 209ms. Enumerating result took: 8ms
  257. Number of elements fetched: 31465. Fetch took: 209ms. Enumerating result took: 7ms
  258. Number of elements fetched: 31465. Fetch took: 209ms. Enumerating result took: 7ms
  259. Single element fetches
  260. -------------------------
  261. Number of elements fetched individually: 100. Total time: 167ms. Time per element: 1,67ms
  262. Number of elements fetched individually: 100. Total time: 34ms. Time per element: 0,34ms
  263. Number of elements fetched individually: 100. Total time: 29ms. Time per element: 0,29ms
  264. Number of elements fetched individually: 100. Total time: 29ms. Time per element: 0,29ms
  265. Number of elements fetched individually: 100. Total time: 28ms. Time per element: 0,28ms
  266. Number of elements fetched individually: 100. Total time: 28ms. Time per element: 0,28ms
  267. Number of elements fetched individually: 100. Total time: 28ms. Time per element: 0,28ms
  268. Number of elements fetched individually: 100. Total time: 29ms. Time per element: 0,29ms
  269. Number of elements fetched individually: 100. Total time: 31ms. Time per element: 0,31ms
  270. Number of elements fetched individually: 100. Total time: 150ms. Time per element: 1,5ms
  271.  
  272. LLBLGen Pro v4.1.0.0 (v4.1.14.0117). Change tracking: True. Caching: False.
  273. --------------------------------------------------------------------------------------------
  274. Set fetches
  275. -------------------------
  276. Number of elements fetched: 31465. Fetch took: 704ms. Enumerating result took: 11ms
  277. Number of elements fetched: 31465. Fetch took: 695ms. Enumerating result took: 11ms
  278. Number of elements fetched: 31465. Fetch took: 697ms. Enumerating result took: 11ms
  279. Number of elements fetched: 31465. Fetch took: 699ms. Enumerating result took: 11ms
  280. Number of elements fetched: 31465. Fetch took: 694ms. Enumerating result took: 11ms
  281. Number of elements fetched: 31465. Fetch took: 686ms. Enumerating result took: 11ms
  282. Number of elements fetched: 31465. Fetch took: 702ms. Enumerating result took: 11ms
  283. Number of elements fetched: 31465. Fetch took: 682ms. Enumerating result took: 11ms
  284. Number of elements fetched: 31465. Fetch took: 707ms. Enumerating result took: 11ms
  285. Number of elements fetched: 31465. Fetch took: 699ms. Enumerating result took: 11ms
  286. Single element fetches
  287. -------------------------
  288. Number of elements fetched individually: 100. Total time: 145ms. Time per element: 1,45ms
  289. Number of elements fetched individually: 100. Total time: 122ms. Time per element: 1,22ms
  290. Number of elements fetched individually: 100. Total time: 116ms. Time per element: 1,16ms
  291. Number of elements fetched individually: 100. Total time: 117ms. Time per element: 1,17ms
  292. Number of elements fetched individually: 100. Total time: 117ms. Time per element: 1,17ms
  293. Number of elements fetched individually: 100. Total time: 122ms. Time per element: 1,22ms
  294. Number of elements fetched individually: 100. Total time: 116ms. Time per element: 1,16ms
  295. Number of elements fetched individually: 100. Total time: 121ms. Time per element: 1,21ms
  296. Number of elements fetched individually: 100. Total time: 118ms. Time per element: 1,18ms
  297. Number of elements fetched individually: 100. Total time: 130ms. Time per element: 1,3ms
  298.  
  299. NHibernate v3.3.1.4000 (v3.3.3.4001). Change tracking: True. Caching: False.
  300. --------------------------------------------------------------------------------------------
  301. Set fetches
  302. -------------------------
  303. Number of elements fetched: 31465. Fetch took: 6424ms. Enumerating result took: 4ms
  304. Number of elements fetched: 31465. Fetch took: 4001ms. Enumerating result took: 4ms
  305. Number of elements fetched: 31465. Fetch took: 4073ms. Enumerating result took: 4ms
  306. Number of elements fetched: 31465. Fetch took: 4032ms. Enumerating result took: 4ms
  307. Number of elements fetched: 31465. Fetch took: 4025ms. Enumerating result took: 4ms
  308. Number of elements fetched: 31465. Fetch took: 4066ms. Enumerating result took: 4ms
  309. Number of elements fetched: 31465. Fetch took: 4020ms. Enumerating result took: 4ms
  310. Number of elements fetched: 31465. Fetch took: 4046ms. Enumerating result took: 4ms
  311. Number of elements fetched: 31465. Fetch took: 4016ms. Enumerating result took: 4ms
  312. Number of elements fetched: 31465. Fetch took: 4021ms. Enumerating result took: 4ms
  313. Single element fetches
  314. -------------------------
  315. Number of elements fetched individually: 100. Total time: 152ms. Time per element: 1,52ms
  316. Number of elements fetched individually: 100. Total time: 137ms. Time per element: 1,37ms
  317. Number of elements fetched individually: 100. Total time: 129ms. Time per element: 1,29ms
  318. Number of elements fetched individually: 100. Total time: 135ms. Time per element: 1,35ms
  319. Number of elements fetched individually: 100. Total time: 135ms. Time per element: 1,35ms
  320. Number of elements fetched individually: 100. Total time: 135ms. Time per element: 1,35ms
  321. Number of elements fetched individually: 100. Total time: 130ms. Time per element: 1,3ms
  322. Number of elements fetched individually: 100. Total time: 137ms. Time per element: 1,37ms
  323. Number of elements fetched individually: 100. Total time: 136ms. Time per element: 1,36ms
  324. Number of elements fetched individually: 100. Total time: 137ms. Time per element: 1,37ms
  325.  
  326. Oak.DynamicDb using dynamic Dto class. Change tracking: False. Caching: False.
  327. --------------------------------------------------------------------------------------------
  328. Set fetches
  329. -------------------------
  330. Number of elements fetched: 31465. Fetch took: 1301ms. Enumerating result took: 230ms
  331. Number of elements fetched: 31465. Fetch took: 1217ms. Enumerating result took: 192ms
  332. Number of elements fetched: 31465. Fetch took: 1210ms. Enumerating result took: 295ms
  333. Number of elements fetched: 31465. Fetch took: 1214ms. Enumerating result took: 189ms
  334. Number of elements fetched: 31465. Fetch took: 1205ms. Enumerating result took: 285ms
  335. Number of elements fetched: 31465. Fetch took: 1199ms. Enumerating result took: 289ms
  336. Number of elements fetched: 31465. Fetch took: 1206ms. Enumerating result took: 286ms
  337. Number of elements fetched: 31465. Fetch took: 1196ms. Enumerating result took: 286ms
  338. Number of elements fetched: 31465. Fetch took: 1203ms. Enumerating result took: 288ms
  339. Number of elements fetched: 31465. Fetch took: 1206ms. Enumerating result took: 289ms
  340. Single element fetches
  341. -------------------------
  342. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  343. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  344. Number of elements fetched individually: 100. Total time: 61ms. Time per element: 0,61ms
  345. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  346. Number of elements fetched individually: 100. Total time: 63ms. Time per element: 0,63ms
  347. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  348. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  349. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  350. Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
  351. Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
  352.  
  353. Oak.DynamicDb using typed dynamic class. Change tracking: True. Caching: False.
  354. --------------------------------------------------------------------------------------------
  355. Set fetches
  356. -------------------------
  357. Number of elements fetched: 31465. Fetch took: 1228ms. Enumerating result took: 1652ms
  358. Number of elements fetched: 31465. Fetch took: 1216ms. Enumerating result took: 1644ms
  359. Number of elements fetched: 31465. Fetch took: 1213ms. Enumerating result took: 1641ms
  360. Number of elements fetched: 31465. Fetch took: 1216ms. Enumerating result took: 1633ms
  361. Number of elements fetched: 31465. Fetch took: 1210ms. Enumerating result took: 1644ms
  362. Number of elements fetched: 31465. Fetch took: 1220ms. Enumerating result took: 1629ms
  363. Number of elements fetched: 31465. Fetch took: 1216ms. Enumerating result took: 1641ms
  364. Number of elements fetched: 31465. Fetch took: 1212ms. Enumerating result took: 1655ms
  365. Number of elements fetched: 31465. Fetch took: 1207ms. Enumerating result took: 1647ms
  366. Number of elements fetched: 31465. Fetch took: 1223ms. Enumerating result took: 1641ms
  367. Single element fetches
  368. -------------------------
  369. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  370. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  371. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  372. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  373. Number of elements fetched individually: 100. Total time: 63ms. Time per element: 0,63ms
  374. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  375. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  376. Number of elements fetched individually: 100. Total time: 71ms. Time per element: 0,71ms
  377. Number of elements fetched individually: 100. Total time: 70ms. Time per element: 0,7ms
  378. Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
  379.  
  380. ServiceStack OrmLite v4.0.5.0 (v4.0.5.0). Change tracking: False. Caching: False.
  381. --------------------------------------------------------------------------------------------
  382. Set fetches
  383. -------------------------
  384. Number of elements fetched: 31465. Fetch took: 698ms. Enumerating result took: 2ms
  385. Number of elements fetched: 31465. Fetch took: 599ms. Enumerating result took: 2ms
  386. Number of elements fetched: 31465. Fetch took: 592ms. Enumerating result took: 2ms
  387. Number of elements fetched: 31465. Fetch took: 597ms. Enumerating result took: 2ms
  388. Number of elements fetched: 31465. Fetch took: 599ms. Enumerating result took: 2ms
  389. Number of elements fetched: 31465. Fetch took: 596ms. Enumerating result took: 2ms
  390. Number of elements fetched: 31465. Fetch took: 594ms. Enumerating result took: 2ms
  391. Number of elements fetched: 31465. Fetch took: 598ms. Enumerating result took: 2ms
  392. Number of elements fetched: 31465. Fetch took: 595ms. Enumerating result took: 2ms
  393. Number of elements fetched: 31465. Fetch took: 593ms. Enumerating result took: 2ms
  394. Single element fetches
  395. -------------------------
  396. Number of elements fetched individually: 100. Total time: 92ms. Time per element: 0,92ms
  397. Number of elements fetched individually: 100. Total time: 72ms. Time per element: 0,72ms
  398. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  399. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  400. Number of elements fetched individually: 100. Total time: 74ms. Time per element: 0,74ms
  401. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  402. Number of elements fetched individually: 100. Total time: 74ms. Time per element: 0,74ms
  403. Number of elements fetched individually: 100. Total time: 71ms. Time per element: 0,71ms
  404. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  405. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  406.  
  407. PetaPoco v4.0.3. Change tracking: False. Caching: False.
  408. --------------------------------------------------------------------------------------------
  409. Set fetches
  410. -------------------------
  411. Number of elements fetched: 31465. Fetch took: 528ms. Enumerating result took: 2ms
  412. Number of elements fetched: 31465. Fetch took: 525ms. Enumerating result took: 2ms
  413. Number of elements fetched: 31465. Fetch took: 500ms. Enumerating result took: 2ms
  414. Number of elements fetched: 31465. Fetch took: 513ms. Enumerating result took: 2ms
  415. Number of elements fetched: 31465. Fetch took: 526ms. Enumerating result took: 2ms
  416. Number of elements fetched: 31465. Fetch took: 503ms. Enumerating result took: 2ms
  417. Number of elements fetched: 31465. Fetch took: 513ms. Enumerating result took: 2ms
  418. Number of elements fetched: 31465. Fetch took: 526ms. Enumerating result took: 2ms
  419. Number of elements fetched: 31465. Fetch took: 503ms. Enumerating result took: 2ms
  420. Number of elements fetched: 31465. Fetch took: 513ms. Enumerating result took: 2ms
  421. Single element fetches
  422. -------------------------
  423. Number of elements fetched individually: 100. Total time: 392ms. Time per element: 3,92ms
  424. Number of elements fetched individually: 100. Total time: 386ms. Time per element: 3,86ms
  425. Number of elements fetched individually: 100. Total time: 385ms. Time per element: 3,85ms
  426. Number of elements fetched individually: 100. Total time: 386ms. Time per element: 3,86ms
  427. Number of elements fetched individually: 100. Total time: 387ms. Time per element: 3,87ms
  428. Number of elements fetched individually: 100. Total time: 389ms. Time per element: 3,89ms
  429. Number of elements fetched individually: 100. Total time: 389ms. Time per element: 3,89ms
  430. Number of elements fetched individually: 100. Total time: 386ms. Time per element: 3,86ms
  431. Number of elements fetched individually: 100. Total time: 385ms. Time per element: 3,85ms
  432. Number of elements fetched individually: 100. Total time: 388ms. Time per element: 3,88ms
  433.  
  434. PetaPoco Fast v4.0.3. Change tracking: False. Caching: False.
  435. --------------------------------------------------------------------------------------------
  436. Set fetches
  437. -------------------------
  438. Number of elements fetched: 31465. Fetch took: 509ms. Enumerating result took: 2ms
  439. Number of elements fetched: 31465. Fetch took: 505ms. Enumerating result took: 2ms
  440. Number of elements fetched: 31465. Fetch took: 499ms. Enumerating result took: 2ms
  441. Number of elements fetched: 31465. Fetch took: 504ms. Enumerating result took: 2ms
  442. Number of elements fetched: 31465. Fetch took: 499ms. Enumerating result took: 2ms
  443. Number of elements fetched: 31465. Fetch took: 499ms. Enumerating result took: 2ms
  444. Number of elements fetched: 31465. Fetch took: 499ms. Enumerating result took: 2ms
  445. Number of elements fetched: 31465. Fetch took: 499ms. Enumerating result took: 2ms
  446. Number of elements fetched: 31465. Fetch took: 499ms. Enumerating result took: 2ms
  447. Number of elements fetched: 31465. Fetch took: 500ms. Enumerating result took: 2ms
  448. Single element fetches
  449. -------------------------
  450. Number of elements fetched individually: 100. Total time: 110ms. Time per element: 1,1ms
  451. Number of elements fetched individually: 100. Total time: 104ms. Time per element: 1,04ms
  452. Number of elements fetched individually: 100. Total time: 107ms. Time per element: 1,07ms
  453. Number of elements fetched individually: 100. Total time: 110ms. Time per element: 1,1ms
  454. Number of elements fetched individually: 100. Total time: 111ms. Time per element: 1,11ms
  455. Number of elements fetched individually: 100. Total time: 112ms. Time per element: 1,12ms
  456. Number of elements fetched individually: 100. Total time: 111ms. Time per element: 1,11ms
  457. Number of elements fetched individually: 100. Total time: 96ms. Time per element: 0,96ms
  458. Number of elements fetched individually: 100. Total time: 102ms. Time per element: 1,02ms
  459. Number of elements fetched individually: 100. Total time: 106ms. Time per element: 1,06ms
  460.  
  461. Averaged total results per framework. Fastest and slowest result omited
  462. ==============================================================================
  463. Non-change tracking fetches, set fetches (10 runs), no caching
  464. ------------------------------------------------------------------------------
  465. Entity Framework v6.0.0.0 (v6.1.0.0) : 469,50ms. Enumeration average: 3,00ms
  466. Handcoded materializer using DbDataReader : 495,88ms. Enumeration average: 2,00ms
  467. PetaPoco Fast v4.0.3 : 500,50ms. Enumeration average: 2,00ms
  468. PetaPoco v4.0.3 : 515,25ms. Enumeration average: 2,00ms
  469. Dapper : 521,13ms. Enumeration average: 2,00ms
  470. Linq to Sql v4.0.0.0 (v4.0.30319.18408) : 561,25ms. Enumeration average: 2,50ms
  471. ServiceStack OrmLite v4.0.5.0 (v4.0.5.0) : 596,38ms. Enumeration average: 2,00ms
  472. LLBLGen Pro v4.1.0.0 (v4.1.14.0117), typed view : 730,25ms. Enumeration average: 5,00ms
  473. Oak.DynamicDb using dynamic Dto class : 1.207,50ms. Enumeration average: 268,13ms
  474.  
  475. Change tracking fetches, set fetches (10 runs), no caching
  476. ------------------------------------------------------------------------------
  477. DataTable, using DbDataAdapter : 528,63ms. Enumeration average: 49,00ms
  478. Linq to Sql v4.0.0.0 (v4.0.30319.18408) : 636,88ms. Enumeration average: 2,88ms
  479. LLBLGen Pro v4.1.0.0 (v4.1.14.0117) : 697,00ms. Enumeration average: 11,00ms
  480. Oak.DynamicDb using typed dynamic class : 1.215,75ms. Enumeration average: 1.642,88ms
  481. Entity Framework v6.0.0.0 (v6.1.0.0) : 2.832,25ms. Enumeration average: 4,00ms
  482. NHibernate v3.3.1.4000 (v3.3.3.4001) : 4.037,38ms. Enumeration average: 4,00ms
  483.  
  484. Non-change tracking individual fetches (100 elements, 10 runs), no caching
  485. ------------------------------------------------------------------------------
  486. Oak.DynamicDb using dynamic Dto class : 0,62ms per individual fetch
  487. Dapper : 0,66ms per individual fetch
  488. ServiceStack OrmLite v4.0.5.0 (v4.0.5.0) : 0,72ms per individual fetch
  489. Handcoded materializer using DbDataReader : 0,82ms per individual fetch
  490. PetaPoco Fast v4.0.3 : 1,08ms per individual fetch
  491. LLBLGen Pro v4.1.0.0 (v4.1.14.0117), typed view : 1,60ms per individual fetch
  492. Entity Framework v6.0.0.0 (v6.1.0.0) : 2,08ms per individual fetch
  493. Linq to Sql v4.0.0.0 (v4.0.30319.18408) : 2,59ms per individual fetch
  494. PetaPoco v4.0.3 : 3,87ms per individual fetch
  495.  
  496. Change tracking individual fetches (100 elements, 10 runs), no caching
  497. ------------------------------------------------------------------------------
  498. Oak.DynamicDb using typed dynamic class : 0,67ms per individual fetch
  499. DataTable, using DbDataAdapter : 0,73ms per individual fetch
  500. LLBLGen Pro v4.1.0.0 (v4.1.14.0117) : 1,20ms per individual fetch
  501. NHibernate v3.3.1.4000 (v3.3.3.4001) : 1,35ms per individual fetch
  502. Linq to Sql v4.0.0.0 (v4.0.30319.18408) : 2,73ms per individual fetch
  503. Entity Framework v6.0.0.0 (v6.1.0.0) : 2,78ms per individual fetch
  504.  
  505. Change tracking fetches, set fetches (10 runs), caching
  506. ------------------------------------------------------------------------------
  507. LLBLGen Pro v4.1.0.0 (v4.1.14.0117) : 203,63ms. Enumeration average: 7,13ms
  508.  
  509. Change tracking individual fetches (100 elements, 10 runs), caching
  510. ------------------------------------------------------------------------------
  511. LLBLGen Pro v4.1.0.0 (v4.1.14.0117) : 0,45ms per individual fetch
  512.  
  513. 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!