API tools faq
paste
Advertisement
Guest User

Raw .NET Data Access / ORM Fetch benchmarks 29-Apr-2014.

a guest
Apr 29th, 2014
257
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 46.37 KB | None | 0 0
raw download clone embed print report
  1. Server HW: i5, 8GB ram (DDR3 1600)
  2. Client HW: Core2Quad@2.4 Ghz, 4GB ram (DDR2 800)
  3.  
  4. +-------------------------------------------------------------------------------------------
  5. | Raw Data Access / ORM Benchmarks.
  6. | Code available at : https://github.com/FransBouma/RawDataAccessBencher
  7. | Benchmarks run on : dinsdag 29 april 2014 15:36:08
  8. | Registered benchmarks :
  9. | Handcoded materializer using DbDataReader. Change tracking: False. Caching: False.
  10. | Entity Framework v6.0.0.0 (v6.0.21211.0). Change tracking: False. Caching: False.
  11. | Entity Framework v6.0.0.0 (v6.0.21211.0). Change tracking: True. Caching: False.
  12. | Telerik DataAccess/OpenAccess Domain v4.0.3. Change tracking: True. Caching: False.
  13. | Telerik DataAccess/OpenAccess Fluent v4.0.3. Change tracking: True. Caching: False.
  14. | DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
  15. | Dapper. Change tracking: False. Caching: False.
  16. | Linq to Sql v4.0.0.0 (v4.0.30319.33440). Change tracking: False. Caching: False.
  17. | Linq to Sql v4.0.0.0 (v4.0.30319.33440). Change tracking: True. Caching: False.
  18. | LLBLGen Pro v4.1.0.0 (v4.1.14.0117), typed view. Change tracking: False. Caching: False.
  19. | LLBLGen Pro v4.1.0.0 (v4.1.14.0117). Change tracking: True. Caching: True.
  20. | LLBLGen Pro v4.1.0.0 (v4.1.14.0117). Change tracking: True. Caching: False.
  21. | NHibernate v3.3.1.4000 (v3.3.3.4001). Change tracking: True. Caching: False.
  22. | Oak.DynamicDb using dynamic Dto class. Change tracking: False. Caching: False.
  23. | Oak.DynamicDb using typed dynamic class. Change tracking: True. Caching: False.
  24. | ServiceStack OrmLite v4.0.9.0 (v4.0.9.0). Change tracking: False. Caching: False.
  25. | PetaPoco v4.0.3. Change tracking: False. Caching: False.
  26. | PetaPoco Fast v4.0.3. Change tracking: False. Caching: False.
  27. | Run set benchmarks : True
  28. | Run individual fetch benchmarks: True
  29. | Number of set fetches : 10
  30. | Number of individual keys : 100
  31. | Release build : True
  32. | Client OS : Microsoft Windows NT 6.2.9200.0 (32bit)
  33. | Bencher runs as 64bit : False
  34. | CLR version : 4.0.30319.34014
  35. | Number of CPUs : 4
  36. | Server used : nerd.sd.local
  37. | Catalog used : AdventureWorks
  38. | SQL Server version used : 11.00.3128
  39. +-------------------------------------------------------------------------------------------
  40.  
  41.  
  42. Warming up DB, DB client code and CLR
  43. ====================================================================
  44.  
  45. DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
  46. --------------------------------------------------------------------------------------------
  47. Number of elements fetched: 31465. Fetch took: 665ms. Enumerating result took: 73ms
  48. Number of elements fetched: 31465. Fetch took: 419ms. Enumerating result took: 55ms
  49. Number of elements fetched: 31465. Fetch took: 411ms. Enumerating result took: 54ms
  50. Number of elements fetched: 31465. Fetch took: 427ms. Enumerating result took: 84ms
  51. Number of elements fetched: 31465. Fetch took: 426ms. Enumerating result took: 55ms
  52. Number of elements fetched: 31465. Fetch took: 412ms. Enumerating result took: 54ms
  53. Number of elements fetched: 31465. Fetch took: 409ms. Enumerating result took: 55ms
  54. Number of elements fetched: 31465. Fetch took: 424ms. Enumerating result took: 55ms
  55. Number of elements fetched: 31465. Fetch took: 400ms. Enumerating result took: 55ms
  56. Number of elements fetched: 31465. Fetch took: 407ms. Enumerating result took: 54ms
  57.  
  58. Starting benchmarks.
  59. ====================================================================
  60.  
  61. Handcoded materializer using DbDataReader. Change tracking: False. Caching: False.
  62. --------------------------------------------------------------------------------------------
  63. Set fetches
  64. -------------------------
  65. Number of elements fetched: 31465. Fetch took: 309ms. Enumerating result took: 3ms
  66. Number of elements fetched: 31465. Fetch took: 239ms. Enumerating result took: 3ms
  67. Number of elements fetched: 31465. Fetch took: 239ms. Enumerating result took: 3ms
  68. Number of elements fetched: 31465. Fetch took: 235ms. Enumerating result took: 2ms
  69. Number of elements fetched: 31465. Fetch took: 235ms. Enumerating result took: 3ms
  70. Number of elements fetched: 31465. Fetch took: 242ms. Enumerating result took: 2ms
  71. Number of elements fetched: 31465. Fetch took: 234ms. Enumerating result took: 3ms
  72. Number of elements fetched: 31465. Fetch took: 235ms. Enumerating result took: 3ms
  73. Number of elements fetched: 31465. Fetch took: 235ms. Enumerating result took: 2ms
  74. Number of elements fetched: 31465. Fetch took: 236ms. Enumerating result took: 3ms
  75. Single element fetches
  76. -------------------------
  77. Number of elements fetched individually: 100. Total time: 132ms. Time per element: 1,32ms
  78. Number of elements fetched individually: 100. Total time: 74ms. Time per element: 0,74ms
  79. Number of elements fetched individually: 100. Total time: 74ms. Time per element: 0,74ms
  80. Number of elements fetched individually: 100. Total time: 74ms. Time per element: 0,74ms
  81. Number of elements fetched individually: 100. Total time: 74ms. Time per element: 0,74ms
  82. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  83. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  84. Number of elements fetched individually: 100. Total time: 72ms. Time per element: 0,72ms
  85. Number of elements fetched individually: 100. Total time: 73ms. Time per element: 0,73ms
  86. Number of elements fetched individually: 100. Total time: 74ms. Time per element: 0,74ms
  87.  
  88. Entity Framework v6.0.0.0 (v6.0.21211.0). Change tracking: False. Caching: False.
  89. --------------------------------------------------------------------------------------------
  90. Set fetches
  91. -------------------------
  92. Number of elements fetched: 31465. Fetch took: 3446ms. Enumerating result took: 3ms
  93. Number of elements fetched: 31465. Fetch took: 372ms. Enumerating result took: 3ms
  94. Number of elements fetched: 31465. Fetch took: 398ms. Enumerating result took: 3ms
  95. Number of elements fetched: 31465. Fetch took: 372ms. Enumerating result took: 3ms
  96. Number of elements fetched: 31465. Fetch took: 356ms. Enumerating result took: 2ms
  97. Number of elements fetched: 31465. Fetch took: 371ms. Enumerating result took: 3ms
  98. Number of elements fetched: 31465. Fetch took: 358ms. Enumerating result took: 2ms
  99. Number of elements fetched: 31465. Fetch took: 375ms. Enumerating result took: 3ms
  100. Number of elements fetched: 31465. Fetch took: 403ms. Enumerating result took: 3ms
  101. Number of elements fetched: 31465. Fetch took: 373ms. Enumerating result took: 3ms
  102. Single element fetches
  103. -------------------------
  104. Number of elements fetched individually: 100. Total time: 591ms. Time per element: 5,91ms
  105. Number of elements fetched individually: 100. Total time: 176ms. Time per element: 1,76ms
  106. Number of elements fetched individually: 100. Total time: 172ms. Time per element: 1,72ms
  107. Number of elements fetched individually: 100. Total time: 174ms. Time per element: 1,74ms
  108. Number of elements fetched individually: 100. Total time: 177ms. Time per element: 1,77ms
  109. Number of elements fetched individually: 100. Total time: 175ms. Time per element: 1,75ms
  110. Number of elements fetched individually: 100. Total time: 174ms. Time per element: 1,74ms
  111. Number of elements fetched individually: 100. Total time: 171ms. Time per element: 1,71ms
  112. Number of elements fetched individually: 100. Total time: 173ms. Time per element: 1,73ms
  113. Number of elements fetched individually: 100. Total time: 174ms. Time per element: 1,74ms
  114.  
  115. Entity Framework v6.0.0.0 (v6.0.21211.0). Change tracking: True. Caching: False.
  116. --------------------------------------------------------------------------------------------
  117. Set fetches
  118. -------------------------
  119. Number of elements fetched: 31465. Fetch took: 6355ms. Enumerating result took: 3ms
  120. Number of elements fetched: 31465. Fetch took: 6291ms. Enumerating result took: 3ms
  121. Number of elements fetched: 31465. Fetch took: 6252ms. Enumerating result took: 3ms
  122. Number of elements fetched: 31465. Fetch took: 6264ms. Enumerating result took: 3ms
  123. Number of elements fetched: 31465. Fetch took: 6227ms. Enumerating result took: 4ms
  124. Number of elements fetched: 31465. Fetch took: 6278ms. Enumerating result took: 3ms
  125. Number of elements fetched: 31465. Fetch took: 6278ms. Enumerating result took: 3ms
  126. Number of elements fetched: 31465. Fetch took: 6250ms. Enumerating result took: 4ms
  127. Number of elements fetched: 31465. Fetch took: 6312ms. Enumerating result took: 3ms
  128. Number of elements fetched: 31465. Fetch took: 6243ms. Enumerating result took: 3ms
  129. Single element fetches
  130. -------------------------
  131. Number of elements fetched individually: 100. Total time: 201ms. Time per element: 2,01ms
  132. Number of elements fetched individually: 100. Total time: 199ms. Time per element: 1,99ms
  133. Number of elements fetched individually: 100. Total time: 196ms. Time per element: 1,96ms
  134. Number of elements fetched individually: 100. Total time: 198ms. Time per element: 1,98ms
  135. Number of elements fetched individually: 100. Total time: 196ms. Time per element: 1,96ms
  136. Number of elements fetched individually: 100. Total time: 196ms. Time per element: 1,96ms
  137. Number of elements fetched individually: 100. Total time: 199ms. Time per element: 1,99ms
  138. Number of elements fetched individually: 100. Total time: 199ms. Time per element: 1,99ms
  139. Number of elements fetched individually: 100. Total time: 199ms. Time per element: 1,99ms
  140. Number of elements fetched individually: 100. Total time: 195ms. Time per element: 1,95ms
  141.  
  142. Telerik DataAccess/OpenAccess Domain v4.0.3. Change tracking: True. Caching: False.
  143. --------------------------------------------------------------------------------------------
  144. Set fetches
  145. -------------------------
  146. Number of elements fetched: 31465. Fetch took: 3334ms. Enumerating result took: 3ms
  147. Number of elements fetched: 31465. Fetch took: 1112ms. Enumerating result took: 3ms
  148. Number of elements fetched: 31465. Fetch took: 1122ms. Enumerating result took: 3ms
  149. Number of elements fetched: 31465. Fetch took: 1107ms. Enumerating result took: 3ms
  150. Number of elements fetched: 31465. Fetch took: 1253ms. Enumerating result took: 3ms
  151. Number of elements fetched: 31465. Fetch took: 1068ms. Enumerating result took: 3ms
  152. Number of elements fetched: 31465. Fetch took: 1223ms. Enumerating result took: 3ms
  153. Number of elements fetched: 31465. Fetch took: 1105ms. Enumerating result took: 3ms
  154. Number of elements fetched: 31465. Fetch took: 1100ms. Enumerating result took: 3ms
  155. Number of elements fetched: 31465. Fetch took: 1210ms. Enumerating result took: 3ms
  156. Single element fetches
  157. -------------------------
  158. Number of elements fetched individually: 100. Total time: 163ms. Time per element: 1,63ms
  159. Number of elements fetched individually: 100. Total time: 82ms. Time per element: 0,82ms
  160. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  161. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  162. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  163. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  164. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  165. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  166. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  167. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  168.  
  169. Telerik DataAccess/OpenAccess Fluent v4.0.3. Change tracking: True. Caching: False.
  170. --------------------------------------------------------------------------------------------
  171. Set fetches
  172. -------------------------
  173. Number of elements fetched: 31465. Fetch took: 2237ms. Enumerating result took: 3ms
  174. Number of elements fetched: 31465. Fetch took: 1205ms. Enumerating result took: 3ms
  175. Number of elements fetched: 31465. Fetch took: 1145ms. Enumerating result took: 3ms
  176. Number of elements fetched: 31465. Fetch took: 1284ms. Enumerating result took: 3ms
  177. Number of elements fetched: 31465. Fetch took: 1156ms. Enumerating result took: 3ms
  178. Number of elements fetched: 31465. Fetch took: 1116ms. Enumerating result took: 3ms
  179. Number of elements fetched: 31465. Fetch took: 1109ms. Enumerating result took: 3ms
  180. Number of elements fetched: 31465. Fetch took: 1103ms. Enumerating result took: 3ms
  181. Number of elements fetched: 31465. Fetch took: 1114ms. Enumerating result took: 3ms
  182. Number of elements fetched: 31465. Fetch took: 1130ms. Enumerating result took: 3ms
  183. Single element fetches
  184. -------------------------
  185. Number of elements fetched individually: 100. Total time: 63ms. Time per element: 0,63ms
  186. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  187. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  188. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  189. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  190. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  191. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  192. Number of elements fetched individually: 100. Total time: 68ms. Time per element: 0,68ms
  193. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  194. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  195.  
  196. DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
  197. --------------------------------------------------------------------------------------------
  198. Set fetches
  199. -------------------------
  200. Number of elements fetched: 31465. Fetch took: 409ms. Enumerating result took: 55ms
  201. Number of elements fetched: 31465. Fetch took: 406ms. Enumerating result took: 56ms
  202. Number of elements fetched: 31465. Fetch took: 405ms. Enumerating result took: 55ms
  203. Number of elements fetched: 31465. Fetch took: 390ms. Enumerating result took: 55ms
  204. Number of elements fetched: 31465. Fetch took: 388ms. Enumerating result took: 56ms
  205. Number of elements fetched: 31465. Fetch took: 411ms. Enumerating result took: 55ms
  206. Number of elements fetched: 31465. Fetch took: 404ms. Enumerating result took: 56ms
  207. Number of elements fetched: 31465. Fetch took: 416ms. Enumerating result took: 55ms
  208. Number of elements fetched: 31465. Fetch took: 401ms. Enumerating result took: 56ms
  209. Number of elements fetched: 31465. Fetch took: 406ms. Enumerating result took: 55ms
  210. Single element fetches
  211. -------------------------
  212. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  213. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  214. Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
  215. Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
  216. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  217. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  218. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  219. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  220. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  221. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  222.  
  223. Dapper. Change tracking: False. Caching: False.
  224. --------------------------------------------------------------------------------------------
  225. Set fetches
  226. -------------------------
  227. Number of elements fetched: 31465. Fetch took: 404ms. Enumerating result took: 3ms
  228. Number of elements fetched: 31465. Fetch took: 327ms. Enumerating result took: 3ms
  229. Number of elements fetched: 31465. Fetch took: 332ms. Enumerating result took: 3ms
  230. Number of elements fetched: 31465. Fetch took: 329ms. Enumerating result took: 3ms
  231. Number of elements fetched: 31465. Fetch took: 327ms. Enumerating result took: 3ms
  232. Number of elements fetched: 31465. Fetch took: 330ms. Enumerating result took: 3ms
  233. Number of elements fetched: 31465. Fetch took: 331ms. Enumerating result took: 3ms
  234. Number of elements fetched: 31465. Fetch took: 320ms. Enumerating result took: 3ms
  235. Number of elements fetched: 31465. Fetch took: 327ms. Enumerating result took: 3ms
  236. Number of elements fetched: 31465. Fetch took: 328ms. Enumerating result took: 3ms
  237. Single element fetches
  238. -------------------------
  239. Number of elements fetched individually: 100. Total time: 56ms. Time per element: 0,56ms
  240. Number of elements fetched individually: 100. Total time: 45ms. Time per element: 0,45ms
  241. Number of elements fetched individually: 100. Total time: 45ms. Time per element: 0,45ms
  242. Number of elements fetched individually: 100. Total time: 44ms. Time per element: 0,44ms
  243. Number of elements fetched individually: 100. Total time: 44ms. Time per element: 0,44ms
  244. Number of elements fetched individually: 100. Total time: 45ms. Time per element: 0,45ms
  245. Number of elements fetched individually: 100. Total time: 44ms. Time per element: 0,44ms
  246. Number of elements fetched individually: 100. Total time: 45ms. Time per element: 0,45ms
  247. Number of elements fetched individually: 100. Total time: 45ms. Time per element: 0,45ms
  248. Number of elements fetched individually: 100. Total time: 46ms. Time per element: 0,46ms
  249.  
  250. Linq to Sql v4.0.0.0 (v4.0.30319.33440). Change tracking: False. Caching: False.
  251. --------------------------------------------------------------------------------------------
  252. Set fetches
  253. -------------------------
  254. Number of elements fetched: 31465. Fetch took: 524ms. Enumerating result took: 3ms
  255. Number of elements fetched: 31465. Fetch took: 372ms. Enumerating result took: 3ms
  256. Number of elements fetched: 31465. Fetch took: 338ms. Enumerating result took: 3ms
  257. Number of elements fetched: 31465. Fetch took: 342ms. Enumerating result took: 3ms
  258. Number of elements fetched: 31465. Fetch took: 382ms. Enumerating result took: 3ms
  259. Number of elements fetched: 31465. Fetch took: 338ms. Enumerating result took: 3ms
  260. Number of elements fetched: 31465. Fetch took: 384ms. Enumerating result took: 3ms
  261. Number of elements fetched: 31465. Fetch took: 340ms. Enumerating result took: 3ms
  262. Number of elements fetched: 31465. Fetch took: 346ms. Enumerating result took: 3ms
  263. Number of elements fetched: 31465. Fetch took: 362ms. Enumerating result took: 3ms
  264. Single element fetches
  265. -------------------------
  266. Number of elements fetched individually: 100. Total time: 289ms. Time per element: 2,89ms
  267. Number of elements fetched individually: 100. Total time: 259ms. Time per element: 2,59ms
  268. Number of elements fetched individually: 100. Total time: 229ms. Time per element: 2,29ms
  269. Number of elements fetched individually: 100. Total time: 229ms. Time per element: 2,29ms
  270. Number of elements fetched individually: 100. Total time: 233ms. Time per element: 2,33ms
  271. Number of elements fetched individually: 100. Total time: 229ms. Time per element: 2,29ms
  272. Number of elements fetched individually: 100. Total time: 228ms. Time per element: 2,28ms
  273. Number of elements fetched individually: 100. Total time: 228ms. Time per element: 2,28ms
  274. Number of elements fetched individually: 100. Total time: 234ms. Time per element: 2,34ms
  275. Number of elements fetched individually: 100. Total time: 232ms. Time per element: 2,32ms
  276.  
  277. Linq to Sql v4.0.0.0 (v4.0.30319.33440). Change tracking: True. Caching: False.
  278. --------------------------------------------------------------------------------------------
  279. Set fetches
  280. -------------------------
  281. Number of elements fetched: 31465. Fetch took: 570ms. Enumerating result took: 3ms
  282. Number of elements fetched: 31465. Fetch took: 517ms. Enumerating result took: 3ms
  283. Number of elements fetched: 31465. Fetch took: 525ms. Enumerating result took: 3ms
  284. Number of elements fetched: 31465. Fetch took: 563ms. Enumerating result took: 3ms
  285. Number of elements fetched: 31465. Fetch took: 568ms. Enumerating result took: 3ms
  286. Number of elements fetched: 31465. Fetch took: 579ms. Enumerating result took: 3ms
  287. Number of elements fetched: 31465. Fetch took: 559ms. Enumerating result took: 3ms
  288. Number of elements fetched: 31465. Fetch took: 512ms. Enumerating result took: 3ms
  289. Number of elements fetched: 31465. Fetch took: 524ms. Enumerating result took: 3ms
  290. Number of elements fetched: 31465. Fetch took: 542ms. Enumerating result took: 3ms
  291. Single element fetches
  292. -------------------------
  293. Number of elements fetched individually: 100. Total time: 249ms. Time per element: 2,49ms
  294. Number of elements fetched individually: 100. Total time: 240ms. Time per element: 2,4ms
  295. Number of elements fetched individually: 100. Total time: 242ms. Time per element: 2,42ms
  296. Number of elements fetched individually: 100. Total time: 245ms. Time per element: 2,45ms
  297. Number of elements fetched individually: 100. Total time: 245ms. Time per element: 2,45ms
  298. Number of elements fetched individually: 100. Total time: 249ms. Time per element: 2,49ms
  299. Number of elements fetched individually: 100. Total time: 246ms. Time per element: 2,46ms
  300. Number of elements fetched individually: 100. Total time: 245ms. Time per element: 2,45ms
  301. Number of elements fetched individually: 100. Total time: 245ms. Time per element: 2,45ms
  302. Number of elements fetched individually: 100. Total time: 246ms. Time per element: 2,46ms
  303.  
  304. LLBLGen Pro v4.1.0.0 (v4.1.14.0117), typed view. Change tracking: False. Caching: False.
  305. --------------------------------------------------------------------------------------------
  306. Set fetches
  307. -------------------------
  308. Number of elements fetched: 31465. Fetch took: 743ms. Enumerating result took: 23ms
  309. Number of elements fetched: 31465. Fetch took: 657ms. Enumerating result took: 5ms
  310. Number of elements fetched: 31465. Fetch took: 671ms. Enumerating result took: 5ms
  311. Number of elements fetched: 31465. Fetch took: 660ms. Enumerating result took: 5ms
  312. Number of elements fetched: 31465. Fetch took: 687ms. Enumerating result took: 5ms
  313. Number of elements fetched: 31465. Fetch took: 704ms. Enumerating result took: 5ms
  314. Number of elements fetched: 31465. Fetch took: 660ms. Enumerating result took: 5ms
  315. Number of elements fetched: 31465. Fetch took: 669ms. Enumerating result took: 5ms
  316. Number of elements fetched: 31465. Fetch took: 656ms. Enumerating result took: 5ms
  317. Number of elements fetched: 31465. Fetch took: 674ms. Enumerating result took: 5ms
  318. Single element fetches
  319. -------------------------
  320. Number of elements fetched individually: 100. Total time: 136ms. Time per element: 1,36ms
  321. Number of elements fetched individually: 100. Total time: 109ms. Time per element: 1,09ms
  322. Number of elements fetched individually: 100. Total time: 106ms. Time per element: 1,06ms
  323. Number of elements fetched individually: 100. Total time: 109ms. Time per element: 1,09ms
  324. Number of elements fetched individually: 100. Total time: 111ms. Time per element: 1,11ms
  325. Number of elements fetched individually: 100. Total time: 109ms. Time per element: 1,09ms
  326. Number of elements fetched individually: 100. Total time: 106ms. Time per element: 1,06ms
  327. Number of elements fetched individually: 100. Total time: 108ms. Time per element: 1,08ms
  328. Number of elements fetched individually: 100. Total time: 106ms. Time per element: 1,06ms
  329. Number of elements fetched individually: 100. Total time: 106ms. Time per element: 1,06ms
  330.  
  331. LLBLGen Pro v4.1.0.0 (v4.1.14.0117). Change tracking: True. Caching: True.
  332. --------------------------------------------------------------------------------------------
  333. Set fetches
  334. -------------------------
  335. Number of elements fetched: 31465. Fetch took: 870ms. Enumerating result took: 16ms
  336. Number of elements fetched: 31465. Fetch took: 213ms. Enumerating result took: 8ms
  337. Number of elements fetched: 31465. Fetch took: 207ms. Enumerating result took: 8ms
  338. Number of elements fetched: 31465. Fetch took: 307ms. Enumerating result took: 8ms
  339. Number of elements fetched: 31465. Fetch took: 185ms. Enumerating result took: 8ms
  340. Number of elements fetched: 31465. Fetch took: 196ms. Enumerating result took: 8ms
  341. Number of elements fetched: 31465. Fetch took: 196ms. Enumerating result took: 8ms
  342. Number of elements fetched: 31465. Fetch took: 159ms. Enumerating result took: 8ms
  343. Number of elements fetched: 31465. Fetch took: 196ms. Enumerating result took: 8ms
  344. Number of elements fetched: 31465. Fetch took: 149ms. Enumerating result took: 8ms
  345. Single element fetches
  346. -------------------------
  347. Number of elements fetched individually: 100. Total time: 123ms. Time per element: 1,23ms
  348. Number of elements fetched individually: 100. Total time: 28ms. Time per element: 0,28ms
  349. Number of elements fetched individually: 100. Total time: 31ms. Time per element: 0,31ms
  350. Number of elements fetched individually: 100. Total time: 27ms. Time per element: 0,27ms
  351. Number of elements fetched individually: 100. Total time: 26ms. Time per element: 0,26ms
  352. Number of elements fetched individually: 100. Total time: 26ms. Time per element: 0,26ms
  353. Number of elements fetched individually: 100. Total time: 26ms. Time per element: 0,26ms
  354. Number of elements fetched individually: 100. Total time: 33ms. Time per element: 0,33ms
  355. Number of elements fetched individually: 100. Total time: 27ms. Time per element: 0,27ms
  356. Number of elements fetched individually: 100. Total time: 117ms. Time per element: 1,17ms
  357.  
  358. LLBLGen Pro v4.1.0.0 (v4.1.14.0117). Change tracking: True. Caching: False.
  359. --------------------------------------------------------------------------------------------
  360. Set fetches
  361. -------------------------
  362. Number of elements fetched: 31465. Fetch took: 672ms. Enumerating result took: 11ms
  363. Number of elements fetched: 31465. Fetch took: 561ms. Enumerating result took: 11ms
  364. Number of elements fetched: 31465. Fetch took: 559ms. Enumerating result took: 11ms
  365. Number of elements fetched: 31465. Fetch took: 554ms. Enumerating result took: 11ms
  366. Number of elements fetched: 31465. Fetch took: 554ms. Enumerating result took: 11ms
  367. Number of elements fetched: 31465. Fetch took: 553ms. Enumerating result took: 11ms
  368. Number of elements fetched: 31465. Fetch took: 555ms. Enumerating result took: 11ms
  369. Number of elements fetched: 31465. Fetch took: 554ms. Enumerating result took: 11ms
  370. Number of elements fetched: 31465. Fetch took: 553ms. Enumerating result took: 11ms
  371. Number of elements fetched: 31465. Fetch took: 591ms. Enumerating result took: 11ms
  372. Single element fetches
  373. -------------------------
  374. Number of elements fetched individually: 100. Total time: 100ms. Time per element: 1ms
  375. Number of elements fetched individually: 100. Total time: 79ms. Time per element: 0,79ms
  376. Number of elements fetched individually: 100. Total time: 79ms. Time per element: 0,79ms
  377. Number of elements fetched individually: 100. Total time: 80ms. Time per element: 0,8ms
  378. Number of elements fetched individually: 100. Total time: 81ms. Time per element: 0,81ms
  379. Number of elements fetched individually: 100. Total time: 85ms. Time per element: 0,85ms
  380. Number of elements fetched individually: 100. Total time: 82ms. Time per element: 0,82ms
  381. Number of elements fetched individually: 100. Total time: 81ms. Time per element: 0,81ms
  382. Number of elements fetched individually: 100. Total time: 82ms. Time per element: 0,82ms
  383. Number of elements fetched individually: 100. Total time: 81ms. Time per element: 0,81ms
  384.  
  385. NHibernate v3.3.1.4000 (v3.3.3.4001). Change tracking: True. Caching: False.
  386. --------------------------------------------------------------------------------------------
  387. Set fetches
  388. -------------------------
  389. Number of elements fetched: 31465. Fetch took: 6784ms. Enumerating result took: 4ms
  390. Number of elements fetched: 31465. Fetch took: 3880ms. Enumerating result took: 4ms
  391. Number of elements fetched: 31465. Fetch took: 3893ms. Enumerating result took: 4ms
  392. Number of elements fetched: 31465. Fetch took: 3919ms. Enumerating result took: 4ms
  393. Number of elements fetched: 31465. Fetch took: 3900ms. Enumerating result took: 4ms
  394. Number of elements fetched: 31465. Fetch took: 3884ms. Enumerating result took: 4ms
  395. Number of elements fetched: 31465. Fetch took: 3898ms. 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: 3889ms. Enumerating result took: 4ms
  398. Number of elements fetched: 31465. Fetch took: 3862ms. Enumerating result took: 4ms
  399. Single element fetches
  400. -------------------------
  401. Number of elements fetched individually: 100. Total time: 106ms. Time per element: 1,06ms
  402. Number of elements fetched individually: 100. Total time: 92ms. Time per element: 0,92ms
  403. Number of elements fetched individually: 100. Total time: 90ms. Time per element: 0,9ms
  404. Number of elements fetched individually: 100. Total time: 93ms. Time per element: 0,93ms
  405. Number of elements fetched individually: 100. Total time: 92ms. Time per element: 0,92ms
  406. Number of elements fetched individually: 100. Total time: 91ms. Time per element: 0,91ms
  407. Number of elements fetched individually: 100. Total time: 90ms. Time per element: 0,9ms
  408. Number of elements fetched individually: 100. Total time: 91ms. Time per element: 0,91ms
  409. Number of elements fetched individually: 100. Total time: 90ms. Time per element: 0,9ms
  410. Number of elements fetched individually: 100. Total time: 91ms. Time per element: 0,91ms
  411.  
  412. Oak.DynamicDb using dynamic Dto class. Change tracking: False. Caching: False.
  413. --------------------------------------------------------------------------------------------
  414. Set fetches
  415. -------------------------
  416. Number of elements fetched: 31465. Fetch took: 1358ms. Enumerating result took: 181ms
  417. Number of elements fetched: 31465. Fetch took: 1112ms. Enumerating result took: 180ms
  418. Number of elements fetched: 31465. Fetch took: 1155ms. Enumerating result took: 200ms
  419. Number of elements fetched: 31465. Fetch took: 1178ms. Enumerating result took: 216ms
  420. Number of elements fetched: 31465. Fetch took: 1168ms. Enumerating result took: 184ms
  421. Number of elements fetched: 31465. Fetch took: 1189ms. Enumerating result took: 205ms
  422. Number of elements fetched: 31465. Fetch took: 1244ms. Enumerating result took: 215ms
  423. Number of elements fetched: 31465. Fetch took: 1192ms. Enumerating result took: 213ms
  424. Number of elements fetched: 31465. Fetch took: 1212ms. Enumerating result took: 211ms
  425. Number of elements fetched: 31465. Fetch took: 1133ms. Enumerating result took: 200ms
  426. Single element fetches
  427. -------------------------
  428. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  429. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  430. Number of elements fetched individually: 100. Total time: 52ms. Time per element: 0,52ms
  431. Number of elements fetched individually: 100. Total time: 50ms. Time per element: 0,5ms
  432. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  433. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  434. Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
  435. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  436. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  437. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  438.  
  439. Oak.DynamicDb using typed dynamic class. Change tracking: True. Caching: False.
  440. --------------------------------------------------------------------------------------------
  441. Set fetches
  442. -------------------------
  443. Number of elements fetched: 31465. Fetch took: 1176ms. Enumerating result took: 1703ms
  444. Number of elements fetched: 31465. Fetch took: 1146ms. Enumerating result took: 1613ms
  445. Number of elements fetched: 31465. Fetch took: 1183ms. Enumerating result took: 1597ms
  446. Number of elements fetched: 31465. Fetch took: 1208ms. Enumerating result took: 1629ms
  447. Number of elements fetched: 31465. Fetch took: 1174ms. Enumerating result took: 1628ms
  448. Number of elements fetched: 31465. Fetch took: 1123ms. Enumerating result took: 1650ms
  449. Number of elements fetched: 31465. Fetch took: 1188ms. Enumerating result took: 1608ms
  450. Number of elements fetched: 31465. Fetch took: 1235ms. Enumerating result took: 1537ms
  451. Number of elements fetched: 31465. Fetch took: 1197ms. Enumerating result took: 1604ms
  452. Number of elements fetched: 31465. Fetch took: 1120ms. Enumerating result took: 1618ms
  453. Single element fetches
  454. -------------------------
  455. Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
  456. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  457. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  458. Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
  459. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  460. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  461. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  462. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  463. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  464. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  465.  
  466. ServiceStack OrmLite v4.0.9.0 (v4.0.9.0). Change tracking: False. Caching: False.
  467. --------------------------------------------------------------------------------------------
  468. Set fetches
  469. -------------------------
  470. Number of elements fetched: 31465. Fetch took: 725ms. Enumerating result took: 3ms
  471. Number of elements fetched: 31465. Fetch took: 539ms. Enumerating result took: 2ms
  472. Number of elements fetched: 31465. Fetch took: 542ms. Enumerating result took: 2ms
  473. Number of elements fetched: 31465. Fetch took: 535ms. Enumerating result took: 2ms
  474. Number of elements fetched: 31465. Fetch took: 536ms. Enumerating result took: 2ms
  475. Number of elements fetched: 31465. Fetch took: 543ms. Enumerating result took: 2ms
  476. Number of elements fetched: 31465. Fetch took: 544ms. Enumerating result took: 2ms
  477. Number of elements fetched: 31465. Fetch took: 547ms. Enumerating result took: 2ms
  478. Number of elements fetched: 31465. Fetch took: 534ms. Enumerating result took: 2ms
  479. Number of elements fetched: 31465. Fetch took: 539ms. Enumerating result took: 2ms
  480. Single element fetches
  481. -------------------------
  482. Number of elements fetched individually: 100. Total time: 108ms. Time per element: 1,08ms
  483. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  484. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  485. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  486. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  487. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  488. Number of elements fetched individually: 100. Total time: 51ms. Time per element: 0,51ms
  489. Number of elements fetched individually: 100. Total time: 51ms. Time per element: 0,51ms
  490. Number of elements fetched individually: 100. Total time: 51ms. Time per element: 0,51ms
  491. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  492.  
  493. PetaPoco v4.0.3. Change tracking: False. Caching: False.
  494. --------------------------------------------------------------------------------------------
  495. Set fetches
  496. -------------------------
  497. Number of elements fetched: 31465. Fetch took: 365ms. Enumerating result took: 2ms
  498. Number of elements fetched: 31465. Fetch took: 309ms. Enumerating result took: 3ms
  499. Number of elements fetched: 31465. Fetch took: 317ms. Enumerating result took: 3ms
  500. Number of elements fetched: 31465. Fetch took: 341ms. Enumerating result took: 2ms
  501. Number of elements fetched: 31465. Fetch took: 339ms. Enumerating result took: 3ms
  502. Number of elements fetched: 31465. Fetch took: 310ms. Enumerating result took: 3ms
  503. Number of elements fetched: 31465. Fetch took: 328ms. Enumerating result took: 2ms
  504. Number of elements fetched: 31465. Fetch took: 334ms. Enumerating result took: 2ms
  505. Number of elements fetched: 31465. Fetch took: 312ms. Enumerating result took: 3ms
  506. Number of elements fetched: 31465. Fetch took: 326ms. Enumerating result took: 3ms
  507. Single element fetches
  508. -------------------------
  509. Number of elements fetched individually: 100. Total time: 355ms. Time per element: 3,55ms
  510. Number of elements fetched individually: 100. Total time: 356ms. Time per element: 3,56ms
  511. Number of elements fetched individually: 100. Total time: 355ms. Time per element: 3,55ms
  512. Number of elements fetched individually: 100. Total time: 365ms. Time per element: 3,65ms
  513. Number of elements fetched individually: 100. Total time: 382ms. Time per element: 3,82ms
  514. Number of elements fetched individually: 100. Total time: 363ms. Time per element: 3,63ms
  515. Number of elements fetched individually: 100. Total time: 363ms. Time per element: 3,63ms
  516. Number of elements fetched individually: 100. Total time: 363ms. Time per element: 3,63ms
  517. Number of elements fetched individually: 100. Total time: 363ms. Time per element: 3,63ms
  518. Number of elements fetched individually: 100. Total time: 363ms. Time per element: 3,63ms
  519.  
  520. PetaPoco Fast v4.0.3. Change tracking: False. Caching: False.
  521. --------------------------------------------------------------------------------------------
  522. Set fetches
  523. -------------------------
  524. Number of elements fetched: 31465. Fetch took: 299ms. Enumerating result took: 3ms
  525. Number of elements fetched: 31465. Fetch took: 295ms. Enumerating result took: 3ms
  526. Number of elements fetched: 31465. Fetch took: 289ms. Enumerating result took: 3ms
  527. Number of elements fetched: 31465. Fetch took: 288ms. Enumerating result took: 3ms
  528. Number of elements fetched: 31465. Fetch took: 301ms. Enumerating result took: 3ms
  529. Number of elements fetched: 31465. Fetch took: 288ms. Enumerating result took: 3ms
  530. Number of elements fetched: 31465. Fetch took: 299ms. Enumerating result took: 3ms
  531. Number of elements fetched: 31465. Fetch took: 294ms. Enumerating result took: 3ms
  532. Number of elements fetched: 31465. Fetch took: 428ms. Enumerating result took: 3ms
  533. Number of elements fetched: 31465. Fetch took: 294ms. Enumerating result took: 3ms
  534. Single element fetches
  535. -------------------------
  536. Number of elements fetched individually: 100. Total time: 84ms. Time per element: 0,84ms
  537. Number of elements fetched individually: 100. Total time: 87ms. Time per element: 0,87ms
  538. Number of elements fetched individually: 100. Total time: 86ms. Time per element: 0,86ms
  539. Number of elements fetched individually: 100. Total time: 86ms. Time per element: 0,86ms
  540. Number of elements fetched individually: 100. Total time: 87ms. Time per element: 0,87ms
  541. Number of elements fetched individually: 100. Total time: 88ms. Time per element: 0,88ms
  542. Number of elements fetched individually: 100. Total time: 88ms. Time per element: 0,88ms
  543. Number of elements fetched individually: 100. Total time: 87ms. Time per element: 0,87ms
  544. Number of elements fetched individually: 100. Total time: 86ms. Time per element: 0,86ms
  545. Number of elements fetched individually: 100. Total time: 87ms. Time per element: 0,87ms
  546.  
  547. Averaged total results per framework. Fastest and slowest result omited
  548. ==============================================================================
  549. Non-change tracking fetches, set fetches (10 runs), no caching
  550. ------------------------------------------------------------------------------
  551. Handcoded materializer using DbDataReader : 237,00ms. Enumeration average: 2,75ms
  552. PetaPoco Fast v4.0.3 : 294,88ms. Enumeration average: 3,00ms
  553. PetaPoco v4.0.3 : 325,88ms. Enumeration average: 2,63ms
  554. Dapper : 328,88ms. Enumeration average: 3,00ms
  555. Linq to Sql v4.0.0.0 (v4.0.30319.33440) : 358,25ms. Enumeration average: 3,00ms
  556. Entity Framework v6.0.0.0 (v6.0.21211.0) : 377,75ms. Enumeration average: 2,88ms
  557. ServiceStack OrmLite v4.0.9.0 (v4.0.9.0) : 540,63ms. Enumeration average: 2,00ms
  558. LLBLGen Pro v4.1.0.0 (v4.1.14.0117), typed view : 672,75ms. Enumeration average: 5,00ms
  559. Oak.DynamicDb using dynamic Dto class : 1.183,88ms. Enumeration average: 201,13ms
  560.  
  561. Change tracking fetches, set fetches (10 runs), no caching
  562. ------------------------------------------------------------------------------
  563. DataTable, using DbDataAdapter : 404,00ms. Enumeration average: 55,38ms
  564. Linq to Sql v4.0.0.0 (v4.0.30319.33440) : 546,00ms. Enumeration average: 3,00ms
  565. LLBLGen Pro v4.1.0.0 (v4.1.14.0117) : 560,13ms. Enumeration average: 11,00ms
  566. Telerik DataAccess/OpenAccess Domain v4.0.3 : 1.154,00ms. Enumeration average: 3,00ms
  567. Telerik DataAccess/OpenAccess Fluent v4.0.3 : 1.157,38ms. Enumeration average: 3,00ms
  568. Oak.DynamicDb using typed dynamic class : 1.174,38ms. Enumeration average: 1.618,38ms
  569. NHibernate v3.3.1.4000 (v3.3.3.4001) : 3.898,50ms. Enumeration average: 4,00ms
  570. Entity Framework v6.0.0.0 (v6.0.21211.0) : 6.271,00ms. Enumeration average: 3,13ms
  571.  
  572. Non-change tracking individual fetches (100 elements, 10 runs), no caching
  573. ------------------------------------------------------------------------------
  574. Dapper : 0,45ms per individual fetch
  575. ServiceStack OrmLite v4.0.9.0 (v4.0.9.0) : 0,53ms per individual fetch
  576. Oak.DynamicDb using dynamic Dto class : 0,54ms per individual fetch
  577. Handcoded materializer using DbDataReader : 0,74ms per individual fetch
  578. PetaPoco Fast v4.0.3 : 0,87ms per individual fetch
  579. LLBLGen Pro v4.1.0.0 (v4.1.14.0117), typed view : 1,08ms per individual fetch
  580. Entity Framework v6.0.0.0 (v6.0.21211.0) : 1,74ms per individual fetch
  581. Linq to Sql v4.0.0.0 (v4.0.30319.33440) : 2,34ms per individual fetch
  582. PetaPoco v4.0.3 : 3,61ms per individual fetch
  583.  
  584. Change tracking individual fetches (100 elements, 10 runs), no caching
  585. ------------------------------------------------------------------------------
  586. DataTable, using DbDataAdapter : 0,58ms per individual fetch
  587. Oak.DynamicDb using typed dynamic class : 0,59ms per individual fetch
  588. Telerik DataAccess/OpenAccess Fluent v4.0.3 : 0,67ms per individual fetch
  589. Telerik DataAccess/OpenAccess Domain v4.0.3 : 0,68ms per individual fetch
  590. LLBLGen Pro v4.1.0.0 (v4.1.14.0117) : 0,81ms per individual fetch
  591. NHibernate v3.3.1.4000 (v3.3.3.4001) : 0,91ms per individual fetch
  592. Entity Framework v6.0.0.0 (v6.0.21211.0) : 1,98ms per individual fetch
  593. Linq to Sql v4.0.0.0 (v4.0.30319.33440) : 2,45ms per individual fetch
  594.  
  595. Change tracking fetches, set fetches (10 runs), caching
  596. ------------------------------------------------------------------------------
  597. LLBLGen Pro v4.1.0.0 (v4.1.14.0117) : 207,38ms. Enumeration average: 8,00ms
  598.  
  599. Change tracking individual fetches (100 elements, 10 runs), caching
  600. ------------------------------------------------------------------------------
  601. LLBLGen Pro v4.1.0.0 (v4.1.14.0117) : 0,39ms per individual fetch
  602.  
  603. 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!