API tools faq
paste
Guest User

Raw .NET Data Access / ORM Fetch benchmarks 05-May-2014.

a guest
May 5th, 2014
738
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 52.02 KB | None | 0 0
raw download clone embed print report
  1. Server HW: i5, 8GB ram (DDR3 1600)
  2. Client HW: [email protected] Ghz, 4GB ram (DDR2 800)
  3. LAN: gigabit ethernet switched.
  4. +-------------------------------------------------------------------------------------------
  5. | Raw Data Access / ORM Benchmarks.
  6. | Code available at : https://github.com/FransBouma/RawDataAccessBencher
  7. | Benchmarks run on : maandag 5 mei 2014 14:30:50
  8. | Registered benchmarks :
  9. | Handcoded materializer using DbDataReader. Change tracking: False. Caching: False.
  10. | LLBLGen Pro v4.2.0.0 (v4.2.14.0505), Poco typed view with Linq. Change tracking: False. Caching: False.
  11. | LLBLGen Pro v4.2.0.0 (v4.2.14.0505), Poco typed view with QuerySpec. Change tracking: False. Caching: False.
  12. | LLBLGen Pro v4.2.0.0 (v4.2.14.0505), typed view. Change tracking: False. Caching: False.
  13. | Dapper. Change tracking: False. Caching: False.
  14. | Linq to Sql v4.0.0.0 (v4.0.30319.33440). Change tracking: False. Caching: False.
  15. | Entity Framework v6.0.0.0 (v6.1.30225.0). Change tracking: False. Caching: False.
  16. | ServiceStack OrmLite v4.0.18.0 (v4.0.18.0). Change tracking: False. Caching: False.
  17. | PetaPoco v4.0.3. Change tracking: False. Caching: False.
  18. | PetaPoco Fast v4.0.3. Change tracking: False. Caching: False.
  19. | LLBLGen Pro v4.2.0.0 (v4.2.14.0505). Change tracking: True. Caching: False.
  20. | Entity Framework v6.0.0.0 (v6.1.30225.0). Change tracking: True. Caching: False.
  21. | Telerik DataAccess/OpenAccess Domain v4.0.3. Change tracking: True. Caching: False.
  22. | Telerik DataAccess/OpenAccess Fluent v4.0.3. Change tracking: True. Caching: False.
  23. | DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
  24. | Linq to Sql v4.0.0.0 (v4.0.30319.33440). Change tracking: True. Caching: False.
  25. | NHibernate v3.3.1.4000 (v3.3.3.4001). Change tracking: True. Caching: False.
  26. | Oak.DynamicDb using dynamic Dto class. Change tracking: False. Caching: False.
  27. | Oak.DynamicDb using typed dynamic class. Change tracking: True. Caching: False.
  28. | LLBLGen Pro v4.2.0.0 (v4.2.14.0505). Change tracking: True. Caching: True.
  29. | Run set benchmarks : True
  30. | Run individual fetch benchmarks: True
  31. | Number of set fetches : 10
  32. | Number of individual keys : 100
  33. | Release build : True
  34. | Client OS : Microsoft Windows NT 6.2.9200.0 (32bit)
  35. | Bencher runs as 64bit : False
  36. | CLR version : 4.0.30319.34014
  37. | Number of CPUs : 4
  38. | Server used : nerd.sd.local
  39. | Catalog used : AdventureWorks
  40. | SQL Server version used : 11.00.3128
  41. +-------------------------------------------------------------------------------------------
  42.  
  43.  
  44. Warming up DB, DB client code and CLR
  45. ====================================================================
  46.  
  47. DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
  48. --------------------------------------------------------------------------------------------
  49. Number of elements fetched: 31465. Fetch took: 467ms. Enumerating result took: 53ms
  50. Number of elements fetched: 31465. Fetch took: 426ms. Enumerating result took: 53ms
  51. Number of elements fetched: 31465. Fetch took: 422ms. Enumerating result took: 52ms
  52. Number of elements fetched: 31465. Fetch took: 425ms. Enumerating result took: 82ms
  53. Number of elements fetched: 31465. Fetch took: 440ms. Enumerating result took: 52ms
  54. Number of elements fetched: 31465. Fetch took: 433ms. Enumerating result took: 52ms
  55. Number of elements fetched: 31465. Fetch took: 421ms. Enumerating result took: 52ms
  56. Number of elements fetched: 31465. Fetch took: 439ms. Enumerating result took: 52ms
  57. Number of elements fetched: 31465. Fetch took: 417ms. Enumerating result took: 52ms
  58. Number of elements fetched: 31465. Fetch took: 421ms. Enumerating result took: 52ms
  59.  
  60. Starting benchmarks.
  61. ====================================================================
  62.  
  63. Handcoded materializer using DbDataReader. Change tracking: False. Caching: False.
  64. --------------------------------------------------------------------------------------------
  65. Set fetches
  66. -------------------------
  67. Number of elements fetched: 31465. Fetch took: 291ms. Enumerating result took: 3ms
  68. Number of elements fetched: 31465. Fetch took: 240ms. Enumerating result took: 3ms
  69. Number of elements fetched: 31465. Fetch took: 242ms. Enumerating result took: 3ms
  70. Number of elements fetched: 31465. Fetch took: 239ms. Enumerating result took: 3ms
  71. Number of elements fetched: 31465. Fetch took: 241ms. Enumerating result took: 3ms
  72. Number of elements fetched: 31465. Fetch took: 243ms. Enumerating result took: 3ms
  73. Number of elements fetched: 31465. Fetch took: 239ms. Enumerating result took: 3ms
  74. Number of elements fetched: 31465. Fetch took: 241ms. Enumerating result took: 3ms
  75. Number of elements fetched: 31465. Fetch took: 242ms. Enumerating result took: 3ms
  76. Number of elements fetched: 31465. Fetch took: 244ms. Enumerating result took: 3ms
  77. Single element fetches
  78. -------------------------
  79. Number of elements fetched individually: 100. Total time: 45ms. Time per element: 0,45ms
  80. Number of elements fetched individually: 100. Total time: 42ms. Time per element: 0,42ms
  81. Number of elements fetched individually: 100. Total time: 43ms. Time per element: 0,43ms
  82. Number of elements fetched individually: 100. Total time: 42ms. Time per element: 0,42ms
  83. Number of elements fetched individually: 100. Total time: 42ms. Time per element: 0,42ms
  84. Number of elements fetched individually: 100. Total time: 42ms. Time per element: 0,42ms
  85. Number of elements fetched individually: 100. Total time: 45ms. Time per element: 0,45ms
  86. Number of elements fetched individually: 100. Total time: 44ms. Time per element: 0,44ms
  87. Number of elements fetched individually: 100. Total time: 44ms. Time per element: 0,44ms
  88. Number of elements fetched individually: 100. Total time: 43ms. Time per element: 0,43ms
  89.  
  90. LLBLGen Pro v4.2.0.0 (v4.2.14.0505), Poco typed view with Linq. Change tracking: False. Caching: False.
  91. --------------------------------------------------------------------------------------------
  92. Set fetches
  93. -------------------------
  94. Number of elements fetched: 31465. Fetch took: 717ms. Enumerating result took: 2ms
  95. Number of elements fetched: 31465. Fetch took: 605ms. Enumerating result took: 2ms
  96. Number of elements fetched: 31465. Fetch took: 605ms. Enumerating result took: 2ms
  97. Number of elements fetched: 31465. Fetch took: 602ms. Enumerating result took: 2ms
  98. Number of elements fetched: 31465. Fetch took: 727ms. Enumerating result took: 2ms
  99. Number of elements fetched: 31465. Fetch took: 601ms. Enumerating result took: 2ms
  100. Number of elements fetched: 31465. Fetch took: 607ms. Enumerating result took: 2ms
  101. Number of elements fetched: 31465. Fetch took: 603ms. Enumerating result took: 2ms
  102. Number of elements fetched: 31465. Fetch took: 605ms. Enumerating result took: 2ms
  103. Number of elements fetched: 31465. Fetch took: 602ms. Enumerating result took: 2ms
  104. Single element fetches
  105. -------------------------
  106. Number of elements fetched individually: 100. Total time: 331ms. Time per element: 3,31ms
  107. Number of elements fetched individually: 100. Total time: 253ms. Time per element: 2,53ms
  108. Number of elements fetched individually: 100. Total time: 249ms. Time per element: 2,49ms
  109. Number of elements fetched individually: 100. Total time: 251ms. Time per element: 2,51ms
  110. Number of elements fetched individually: 100. Total time: 249ms. Time per element: 2,49ms
  111. Number of elements fetched individually: 100. Total time: 250ms. Time per element: 2,5ms
  112. Number of elements fetched individually: 100. Total time: 249ms. Time per element: 2,49ms
  113. Number of elements fetched individually: 100. Total time: 250ms. Time per element: 2,5ms
  114. Number of elements fetched individually: 100. Total time: 250ms. Time per element: 2,5ms
  115. Number of elements fetched individually: 100. Total time: 251ms. Time per element: 2,51ms
  116.  
  117. LLBLGen Pro v4.2.0.0 (v4.2.14.0505), Poco typed view with QuerySpec. Change tracking: False. Caching: False.
  118. --------------------------------------------------------------------------------------------
  119. Set fetches
  120. -------------------------
  121. Number of elements fetched: 31465. Fetch took: 543ms. Enumerating result took: 3ms
  122. Number of elements fetched: 31465. Fetch took: 511ms. Enumerating result took: 2ms
  123. Number of elements fetched: 31465. Fetch took: 515ms. Enumerating result took: 2ms
  124. Number of elements fetched: 31465. Fetch took: 512ms. Enumerating result took: 2ms
  125. Number of elements fetched: 31465. Fetch took: 516ms. Enumerating result took: 2ms
  126. Number of elements fetched: 31465. Fetch took: 516ms. Enumerating result took: 2ms
  127. Number of elements fetched: 31465. Fetch took: 518ms. Enumerating result took: 2ms
  128. Number of elements fetched: 31465. Fetch took: 513ms. Enumerating result took: 2ms
  129. Number of elements fetched: 31465. Fetch took: 517ms. Enumerating result took: 2ms
  130. Number of elements fetched: 31465. Fetch took: 519ms. Enumerating result took: 2ms
  131. Single element fetches
  132. -------------------------
  133. Number of elements fetched individually: 100. Total time: 90ms. Time per element: 0,9ms
  134. Number of elements fetched individually: 100. Total time: 87ms. Time per element: 0,87ms
  135. Number of elements fetched individually: 100. Total time: 87ms. Time per element: 0,87ms
  136. Number of elements fetched individually: 100. Total time: 86ms. Time per element: 0,86ms
  137. Number of elements fetched individually: 100. Total time: 86ms. Time per element: 0,86ms
  138. Number of elements fetched individually: 100. Total time: 86ms. Time per element: 0,86ms
  139. Number of elements fetched individually: 100. Total time: 84ms. Time per element: 0,84ms
  140. Number of elements fetched individually: 100. Total time: 86ms. Time per element: 0,86ms
  141. Number of elements fetched individually: 100. Total time: 86ms. Time per element: 0,86ms
  142. Number of elements fetched individually: 100. Total time: 85ms. Time per element: 0,85ms
  143.  
  144. LLBLGen Pro v4.2.0.0 (v4.2.14.0505), typed view. Change tracking: False. Caching: False.
  145. --------------------------------------------------------------------------------------------
  146. Set fetches
  147. -------------------------
  148. Number of elements fetched: 31465. Fetch took: 679ms. Enumerating result took: 7ms
  149. Number of elements fetched: 31465. Fetch took: 664ms. Enumerating result took: 5ms
  150. Number of elements fetched: 31465. Fetch took: 664ms. Enumerating result took: 5ms
  151. Number of elements fetched: 31465. Fetch took: 666ms. Enumerating result took: 5ms
  152. Number of elements fetched: 31465. Fetch took: 666ms. Enumerating result took: 5ms
  153. Number of elements fetched: 31465. Fetch took: 792ms. Enumerating result took: 5ms
  154. Number of elements fetched: 31465. Fetch took: 665ms. Enumerating result took: 5ms
  155. Number of elements fetched: 31465. Fetch took: 668ms. Enumerating result took: 5ms
  156. Number of elements fetched: 31465. Fetch took: 668ms. Enumerating result took: 5ms
  157. Number of elements fetched: 31465. Fetch took: 670ms. Enumerating result took: 5ms
  158. Single element fetches
  159. -------------------------
  160. Number of elements fetched individually: 100. Total time: 112ms. Time per element: 1,12ms
  161. Number of elements fetched individually: 100. Total time: 107ms. Time per element: 1,07ms
  162. Number of elements fetched individually: 100. Total time: 108ms. Time per element: 1,08ms
  163. Number of elements fetched individually: 100. Total time: 109ms. Time per element: 1,09ms
  164. Number of elements fetched individually: 100. Total time: 110ms. Time per element: 1,1ms
  165. Number of elements fetched individually: 100. Total time: 108ms. Time per element: 1,08ms
  166. Number of elements fetched individually: 100. Total time: 109ms. Time per element: 1,09ms
  167. Number of elements fetched individually: 100. Total time: 108ms. Time per element: 1,08ms
  168. Number of elements fetched individually: 100. Total time: 109ms. Time per element: 1,09ms
  169. Number of elements fetched individually: 100. Total time: 109ms. Time per element: 1,09ms
  170.  
  171. Dapper. Change tracking: False. Caching: False.
  172. --------------------------------------------------------------------------------------------
  173. Set fetches
  174. -------------------------
  175. Number of elements fetched: 31465. Fetch took: 505ms. Enumerating result took: 2ms
  176. Number of elements fetched: 31465. Fetch took: 339ms. Enumerating result took: 3ms
  177. Number of elements fetched: 31465. Fetch took: 342ms. Enumerating result took: 2ms
  178. Number of elements fetched: 31465. Fetch took: 474ms. Enumerating result took: 2ms
  179. Number of elements fetched: 31465. Fetch took: 340ms. Enumerating result took: 2ms
  180. Number of elements fetched: 31465. Fetch took: 340ms. Enumerating result took: 2ms
  181. Number of elements fetched: 31465. Fetch took: 340ms. Enumerating result took: 2ms
  182. Number of elements fetched: 31465. Fetch took: 341ms. Enumerating result took: 2ms
  183. Number of elements fetched: 31465. Fetch took: 342ms. Enumerating result took: 2ms
  184. Number of elements fetched: 31465. Fetch took: 338ms. Enumerating result took: 3ms
  185. Single element fetches
  186. -------------------------
  187. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  188. Number of elements fetched individually: 100. Total time: 45ms. Time per element: 0,45ms
  189. Number of elements fetched individually: 100. Total time: 46ms. Time per element: 0,46ms
  190. Number of elements fetched individually: 100. Total time: 45ms. Time per element: 0,45ms
  191. Number of elements fetched individually: 100. Total time: 46ms. Time per element: 0,46ms
  192. Number of elements fetched individually: 100. Total time: 46ms. Time per element: 0,46ms
  193. Number of elements fetched individually: 100. Total time: 46ms. Time per element: 0,46ms
  194. Number of elements fetched individually: 100. Total time: 44ms. Time per element: 0,44ms
  195. Number of elements fetched individually: 100. Total time: 44ms. Time per element: 0,44ms
  196. Number of elements fetched individually: 100. Total time: 45ms. Time per element: 0,45ms
  197.  
  198. Linq to Sql v4.0.0.0 (v4.0.30319.33440). Change tracking: False. Caching: False.
  199. --------------------------------------------------------------------------------------------
  200. Set fetches
  201. -------------------------
  202. Number of elements fetched: 31465. Fetch took: 407ms. Enumerating result took: 3ms
  203. Number of elements fetched: 31465. Fetch took: 374ms. Enumerating result took: 2ms
  204. Number of elements fetched: 31465. Fetch took: 374ms. Enumerating result took: 2ms
  205. Number of elements fetched: 31465. Fetch took: 375ms. Enumerating result took: 2ms
  206. Number of elements fetched: 31465. Fetch took: 349ms. Enumerating result took: 2ms
  207. Number of elements fetched: 31465. Fetch took: 372ms. Enumerating result took: 2ms
  208. Number of elements fetched: 31465. Fetch took: 374ms. Enumerating result took: 2ms
  209. Number of elements fetched: 31465. Fetch took: 374ms. Enumerating result took: 2ms
  210. Number of elements fetched: 31465. Fetch took: 374ms. Enumerating result took: 3ms
  211. Number of elements fetched: 31465. Fetch took: 372ms. Enumerating result took: 3ms
  212. Single element fetches
  213. -------------------------
  214. Number of elements fetched individually: 100. Total time: 237ms. Time per element: 2,37ms
  215. Number of elements fetched individually: 100. Total time: 229ms. Time per element: 2,29ms
  216. Number of elements fetched individually: 100. Total time: 229ms. Time per element: 2,29ms
  217. Number of elements fetched individually: 100. Total time: 230ms. Time per element: 2,3ms
  218. Number of elements fetched individually: 100. Total time: 231ms. Time per element: 2,31ms
  219. Number of elements fetched individually: 100. Total time: 230ms. Time per element: 2,3ms
  220. Number of elements fetched individually: 100. Total time: 231ms. Time per element: 2,31ms
  221. Number of elements fetched individually: 100. Total time: 230ms. Time per element: 2,3ms
  222. Number of elements fetched individually: 100. Total time: 229ms. Time per element: 2,29ms
  223. Number of elements fetched individually: 100. Total time: 230ms. Time per element: 2,3ms
  224.  
  225. Entity Framework v6.0.0.0 (v6.1.30225.0). Change tracking: False. Caching: False.
  226. --------------------------------------------------------------------------------------------
  227. Set fetches
  228. -------------------------
  229. Number of elements fetched: 31465. Fetch took: 2545ms. Enumerating result took: 3ms
  230. Number of elements fetched: 31465. Fetch took: 400ms. Enumerating result took: 3ms
  231. Number of elements fetched: 31465. Fetch took: 378ms. Enumerating result took: 2ms
  232. Number of elements fetched: 31465. Fetch took: 399ms. Enumerating result took: 2ms
  233. Number of elements fetched: 31465. Fetch took: 420ms. Enumerating result took: 2ms
  234. Number of elements fetched: 31465. Fetch took: 405ms. Enumerating result took: 3ms
  235. Number of elements fetched: 31465. Fetch took: 414ms. Enumerating result took: 2ms
  236. Number of elements fetched: 31465. Fetch took: 398ms. Enumerating result took: 3ms
  237. Number of elements fetched: 31465. Fetch took: 417ms. Enumerating result took: 2ms
  238. Number of elements fetched: 31465. Fetch took: 424ms. Enumerating result took: 2ms
  239. Single element fetches
  240. -------------------------
  241. Number of elements fetched individually: 100. Total time: 496ms. Time per element: 4,96ms
  242. Number of elements fetched individually: 100. Total time: 180ms. Time per element: 1,8ms
  243. Number of elements fetched individually: 100. Total time: 178ms. Time per element: 1,78ms
  244. Number of elements fetched individually: 100. Total time: 180ms. Time per element: 1,8ms
  245. Number of elements fetched individually: 100. Total time: 180ms. Time per element: 1,8ms
  246. Number of elements fetched individually: 100. Total time: 180ms. Time per element: 1,8ms
  247. Number of elements fetched individually: 100. Total time: 179ms. Time per element: 1,79ms
  248. Number of elements fetched individually: 100. Total time: 178ms. Time per element: 1,78ms
  249. Number of elements fetched individually: 100. Total time: 178ms. Time per element: 1,78ms
  250. Number of elements fetched individually: 100. Total time: 180ms. Time per element: 1,8ms
  251.  
  252. ServiceStack OrmLite v4.0.18.0 (v4.0.18.0). Change tracking: False. Caching: False.
  253. --------------------------------------------------------------------------------------------
  254. Set fetches
  255. -------------------------
  256. Number of elements fetched: 31465. Fetch took: 645ms. Enumerating result took: 2ms
  257. Number of elements fetched: 31465. Fetch took: 558ms. Enumerating result took: 2ms
  258. Number of elements fetched: 31465. Fetch took: 558ms. Enumerating result took: 2ms
  259. Number of elements fetched: 31465. Fetch took: 555ms. Enumerating result took: 2ms
  260. Number of elements fetched: 31465. Fetch took: 559ms. Enumerating result took: 2ms
  261. Number of elements fetched: 31465. Fetch took: 555ms. Enumerating result took: 2ms
  262. Number of elements fetched: 31465. Fetch took: 555ms. Enumerating result took: 2ms
  263. Number of elements fetched: 31465. Fetch took: 555ms. Enumerating result took: 2ms
  264. Number of elements fetched: 31465. Fetch took: 557ms. Enumerating result took: 2ms
  265. Number of elements fetched: 31465. Fetch took: 543ms. Enumerating result took: 3ms
  266. Single element fetches
  267. -------------------------
  268. Number of elements fetched individually: 100. Total time: 70ms. Time per element: 0,7ms
  269. Number of elements fetched individually: 100. Total time: 52ms. Time per element: 0,52ms
  270. Number of elements fetched individually: 100. Total time: 51ms. Time per element: 0,51ms
  271. Number of elements fetched individually: 100. Total time: 51ms. Time per element: 0,51ms
  272. Number of elements fetched individually: 100. Total time: 52ms. Time per element: 0,52ms
  273. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  274. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  275. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  276. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  277. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  278.  
  279. PetaPoco v4.0.3. Change tracking: False. Caching: False.
  280. --------------------------------------------------------------------------------------------
  281. Set fetches
  282. -------------------------
  283. Number of elements fetched: 31465. Fetch took: 352ms. Enumerating result took: 2ms
  284. Number of elements fetched: 31465. Fetch took: 335ms. Enumerating result took: 2ms
  285. Number of elements fetched: 31465. Fetch took: 311ms. Enumerating result took: 3ms
  286. Number of elements fetched: 31465. Fetch took: 330ms. Enumerating result took: 3ms
  287. Number of elements fetched: 31465. Fetch took: 334ms. Enumerating result took: 2ms
  288. Number of elements fetched: 31465. Fetch took: 318ms. Enumerating result took: 3ms
  289. Number of elements fetched: 31465. Fetch took: 330ms. Enumerating result took: 2ms
  290. Number of elements fetched: 31465. Fetch took: 336ms. Enumerating result took: 2ms
  291. Number of elements fetched: 31465. Fetch took: 314ms. Enumerating result took: 3ms
  292. Number of elements fetched: 31465. Fetch took: 332ms. Enumerating result took: 3ms
  293. Single element fetches
  294. -------------------------
  295. Number of elements fetched individually: 100. Total time: 360ms. Time per element: 3,6ms
  296. Number of elements fetched individually: 100. Total time: 348ms. Time per element: 3,48ms
  297. Number of elements fetched individually: 100. Total time: 349ms. Time per element: 3,49ms
  298. Number of elements fetched individually: 100. Total time: 349ms. Time per element: 3,49ms
  299. Number of elements fetched individually: 100. Total time: 348ms. Time per element: 3,48ms
  300. Number of elements fetched individually: 100. Total time: 348ms. Time per element: 3,48ms
  301. Number of elements fetched individually: 100. Total time: 349ms. Time per element: 3,49ms
  302. Number of elements fetched individually: 100. Total time: 347ms. Time per element: 3,47ms
  303. Number of elements fetched individually: 100. Total time: 348ms. Time per element: 3,48ms
  304. Number of elements fetched individually: 100. Total time: 349ms. Time per element: 3,49ms
  305.  
  306. PetaPoco Fast v4.0.3. Change tracking: False. Caching: False.
  307. --------------------------------------------------------------------------------------------
  308. Set fetches
  309. -------------------------
  310. Number of elements fetched: 31465. Fetch took: 323ms. Enumerating result took: 2ms
  311. Number of elements fetched: 31465. Fetch took: 295ms. Enumerating result took: 3ms
  312. Number of elements fetched: 31465. Fetch took: 425ms. Enumerating result took: 2ms
  313. Number of elements fetched: 31465. Fetch took: 295ms. Enumerating result took: 2ms
  314. Number of elements fetched: 31465. Fetch took: 296ms. Enumerating result took: 2ms
  315. Number of elements fetched: 31465. Fetch took: 303ms. Enumerating result took: 2ms
  316. Number of elements fetched: 31465. Fetch took: 296ms. Enumerating result took: 2ms
  317. Number of elements fetched: 31465. Fetch took: 295ms. Enumerating result took: 3ms
  318. Number of elements fetched: 31465. Fetch took: 297ms. Enumerating result took: 2ms
  319. Number of elements fetched: 31465. Fetch took: 296ms. Enumerating result took: 2ms
  320. Single element fetches
  321. -------------------------
  322. Number of elements fetched individually: 100. Total time: 88ms. Time per element: 0,88ms
  323. Number of elements fetched individually: 100. Total time: 84ms. Time per element: 0,84ms
  324. Number of elements fetched individually: 100. Total time: 83ms. Time per element: 0,83ms
  325. Number of elements fetched individually: 100. Total time: 83ms. Time per element: 0,83ms
  326. Number of elements fetched individually: 100. Total time: 83ms. Time per element: 0,83ms
  327. Number of elements fetched individually: 100. Total time: 84ms. Time per element: 0,84ms
  328. Number of elements fetched individually: 100. Total time: 83ms. Time per element: 0,83ms
  329. Number of elements fetched individually: 100. Total time: 84ms. Time per element: 0,84ms
  330. Number of elements fetched individually: 100. Total time: 84ms. Time per element: 0,84ms
  331. Number of elements fetched individually: 100. Total time: 83ms. Time per element: 0,83ms
  332.  
  333. LLBLGen Pro v4.2.0.0 (v4.2.14.0505). Change tracking: True. Caching: False.
  334. --------------------------------------------------------------------------------------------
  335. Set fetches
  336. -------------------------
  337. Number of elements fetched: 31465. Fetch took: 699ms. Enumerating result took: 13ms
  338. Number of elements fetched: 31465. Fetch took: 616ms. Enumerating result took: 11ms
  339. Number of elements fetched: 31465. Fetch took: 708ms. Enumerating result took: 11ms
  340. Number of elements fetched: 31465. Fetch took: 626ms. Enumerating result took: 11ms
  341. Number of elements fetched: 31465. Fetch took: 611ms. Enumerating result took: 11ms
  342. Number of elements fetched: 31465. Fetch took: 711ms. Enumerating result took: 11ms
  343. Number of elements fetched: 31465. Fetch took: 755ms. Enumerating result took: 11ms
  344. Number of elements fetched: 31465. Fetch took: 615ms. Enumerating result took: 11ms
  345. Number of elements fetched: 31465. Fetch took: 760ms. Enumerating result took: 14ms
  346. Number of elements fetched: 31465. Fetch took: 613ms. Enumerating result took: 11ms
  347. Single element fetches
  348. -------------------------
  349. Number of elements fetched individually: 100. Total time: 102ms. Time per element: 1,02ms
  350. Number of elements fetched individually: 100. Total time: 78ms. Time per element: 0,78ms
  351. Number of elements fetched individually: 100. Total time: 82ms. Time per element: 0,82ms
  352. Number of elements fetched individually: 100. Total time: 79ms. Time per element: 0,79ms
  353. Number of elements fetched individually: 100. Total time: 78ms. Time per element: 0,78ms
  354. Number of elements fetched individually: 100. Total time: 79ms. Time per element: 0,79ms
  355. Number of elements fetched individually: 100. Total time: 79ms. Time per element: 0,79ms
  356. Number of elements fetched individually: 100. Total time: 78ms. Time per element: 0,78ms
  357. Number of elements fetched individually: 100. Total time: 87ms. Time per element: 0,87ms
  358. Number of elements fetched individually: 100. Total time: 81ms. Time per element: 0,81ms
  359.  
  360. Entity Framework v6.0.0.0 (v6.1.30225.0). Change tracking: True. Caching: False.
  361. --------------------------------------------------------------------------------------------
  362. Set fetches
  363. -------------------------
  364. Number of elements fetched: 31465. Fetch took: 3963ms. Enumerating result took: 3ms
  365. Number of elements fetched: 31465. Fetch took: 3812ms. Enumerating result took: 3ms
  366. Number of elements fetched: 31465. Fetch took: 3812ms. Enumerating result took: 3ms
  367. Number of elements fetched: 31465. Fetch took: 3962ms. Enumerating result took: 3ms
  368. Number of elements fetched: 31465. Fetch took: 3833ms. Enumerating result took: 3ms
  369. Number of elements fetched: 31465. Fetch took: 3863ms. Enumerating result took: 3ms
  370. Number of elements fetched: 31465. Fetch took: 3823ms. Enumerating result took: 3ms
  371. Number of elements fetched: 31465. Fetch took: 3802ms. Enumerating result took: 3ms
  372. Number of elements fetched: 31465. Fetch took: 3812ms. Enumerating result took: 3ms
  373. Number of elements fetched: 31465. Fetch took: 3808ms. Enumerating result took: 3ms
  374. Single element fetches
  375. -------------------------
  376. Number of elements fetched individually: 100. Total time: 204ms. Time per element: 2,04ms
  377. Number of elements fetched individually: 100. Total time: 197ms. Time per element: 1,97ms
  378. Number of elements fetched individually: 100. Total time: 198ms. Time per element: 1,98ms
  379. Number of elements fetched individually: 100. Total time: 197ms. Time per element: 1,97ms
  380. Number of elements fetched individually: 100. Total time: 196ms. Time per element: 1,96ms
  381. Number of elements fetched individually: 100. Total time: 199ms. Time per element: 1,99ms
  382. Number of elements fetched individually: 100. Total time: 228ms. Time per element: 2,28ms
  383. Number of elements fetched individually: 100. Total time: 227ms. Time per element: 2,27ms
  384. Number of elements fetched individually: 100. Total time: 244ms. Time per element: 2,44ms
  385. Number of elements fetched individually: 100. Total time: 228ms. Time per element: 2,28ms
  386.  
  387. Telerik DataAccess/OpenAccess Domain v4.0.3. Change tracking: True. Caching: False.
  388. --------------------------------------------------------------------------------------------
  389. Set fetches
  390. -------------------------
  391. Number of elements fetched: 31465. Fetch took: 3238ms. Enumerating result took: 3ms
  392. Number of elements fetched: 31465. Fetch took: 1145ms. Enumerating result took: 3ms
  393. Number of elements fetched: 31465. Fetch took: 1141ms. Enumerating result took: 3ms
  394. Number of elements fetched: 31465. Fetch took: 1387ms. Enumerating result took: 3ms
  395. Number of elements fetched: 31465. Fetch took: 1278ms. Enumerating result took: 3ms
  396. Number of elements fetched: 31465. Fetch took: 1113ms. Enumerating result took: 3ms
  397. Number of elements fetched: 31465. Fetch took: 1135ms. Enumerating result took: 3ms
  398. Number of elements fetched: 31465. Fetch took: 1141ms. Enumerating result took: 3ms
  399. Number of elements fetched: 31465. Fetch took: 1149ms. Enumerating result took: 3ms
  400. Number of elements fetched: 31465. Fetch took: 1247ms. Enumerating result took: 3ms
  401. Single element fetches
  402. -------------------------
  403. Number of elements fetched individually: 100. Total time: 142ms. Time per element: 1,42ms
  404. Number of elements fetched individually: 100. Total time: 61ms. Time per element: 0,61ms
  405. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  406. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  407. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  408. Number of elements fetched individually: 100. Total time: 63ms. Time per element: 0,63ms
  409. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  410. Number of elements fetched individually: 100. Total time: 63ms. Time per element: 0,63ms
  411. Number of elements fetched individually: 100. Total time: 64ms. Time per element: 0,64ms
  412. Number of elements fetched individually: 100. Total time: 63ms. Time per element: 0,63ms
  413.  
  414. Telerik DataAccess/OpenAccess Fluent v4.0.3. Change tracking: True. Caching: False.
  415. --------------------------------------------------------------------------------------------
  416. Set fetches
  417. -------------------------
  418. Number of elements fetched: 31465. Fetch took: 2368ms. Enumerating result took: 4ms
  419. Number of elements fetched: 31465. Fetch took: 1152ms. Enumerating result took: 3ms
  420. Number of elements fetched: 31465. Fetch took: 1311ms. Enumerating result took: 4ms
  421. Number of elements fetched: 31465. Fetch took: 1314ms. Enumerating result took: 4ms
  422. Number of elements fetched: 31465. Fetch took: 1312ms. Enumerating result took: 4ms
  423. Number of elements fetched: 31465. Fetch took: 1423ms. Enumerating result took: 4ms
  424. Number of elements fetched: 31465. Fetch took: 1145ms. Enumerating result took: 3ms
  425. Number of elements fetched: 31465. Fetch took: 1143ms. Enumerating result took: 3ms
  426. Number of elements fetched: 31465. Fetch took: 1145ms. Enumerating result took: 3ms
  427. Number of elements fetched: 31465. Fetch took: 1178ms. Enumerating result took: 3ms
  428. Single element fetches
  429. -------------------------
  430. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  431. Number of elements fetched individually: 100. Total time: 63ms. Time per element: 0,63ms
  432. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  433. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  434. Number of elements fetched individually: 100. Total time: 63ms. Time per element: 0,63ms
  435. Number of elements fetched individually: 100. Total time: 64ms. Time per element: 0,64ms
  436. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  437. Number of elements fetched individually: 100. Total time: 61ms. Time per element: 0,61ms
  438. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  439. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  440.  
  441. DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
  442. --------------------------------------------------------------------------------------------
  443. Set fetches
  444. -------------------------
  445. Number of elements fetched: 31465. Fetch took: 415ms. Enumerating result took: 53ms
  446. Number of elements fetched: 31465. Fetch took: 427ms. Enumerating result took: 53ms
  447. Number of elements fetched: 31465. Fetch took: 415ms. Enumerating result took: 53ms
  448. Number of elements fetched: 31465. Fetch took: 422ms. Enumerating result took: 53ms
  449. Number of elements fetched: 31465. Fetch took: 423ms. Enumerating result took: 53ms
  450. Number of elements fetched: 31465. Fetch took: 419ms. Enumerating result took: 53ms
  451. Number of elements fetched: 31465. Fetch took: 419ms. Enumerating result took: 53ms
  452. Number of elements fetched: 31465. Fetch took: 553ms. Enumerating result took: 53ms
  453. Number of elements fetched: 31465. Fetch took: 425ms. Enumerating result took: 53ms
  454. Number of elements fetched: 31465. Fetch took: 421ms. Enumerating result took: 53ms
  455. Single element fetches
  456. -------------------------
  457. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  458. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  459. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  460. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  461. Number of elements fetched individually: 100. Total time: 60ms. Time per element: 0,6ms
  462. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  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. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  466. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  467.  
  468. Linq to Sql v4.0.0.0 (v4.0.30319.33440). Change tracking: True. Caching: False.
  469. --------------------------------------------------------------------------------------------
  470. Set fetches
  471. -------------------------
  472. Number of elements fetched: 31465. Fetch took: 565ms. Enumerating result took: 3ms
  473. Number of elements fetched: 31465. Fetch took: 540ms. Enumerating result took: 3ms
  474. Number of elements fetched: 31465. Fetch took: 539ms. Enumerating result took: 3ms
  475. Number of elements fetched: 31465. Fetch took: 563ms. Enumerating result took: 3ms
  476. Number of elements fetched: 31465. Fetch took: 584ms. Enumerating result took: 2ms
  477. Number of elements fetched: 31465. Fetch took: 582ms. Enumerating result took: 3ms
  478. Number of elements fetched: 31465. Fetch took: 579ms. Enumerating result took: 3ms
  479. Number of elements fetched: 31465. Fetch took: 587ms. Enumerating result took: 3ms
  480. Number of elements fetched: 31465. Fetch took: 578ms. Enumerating result took: 3ms
  481. Number of elements fetched: 31465. Fetch took: 577ms. Enumerating result took: 3ms
  482. Single element fetches
  483. -------------------------
  484. Number of elements fetched individually: 100. Total time: 250ms. Time per element: 2,5ms
  485. Number of elements fetched individually: 100. Total time: 246ms. Time per element: 2,46ms
  486. Number of elements fetched individually: 100. Total time: 244ms. Time per element: 2,44ms
  487. Number of elements fetched individually: 100. Total time: 248ms. Time per element: 2,48ms
  488. Number of elements fetched individually: 100. Total time: 246ms. Time per element: 2,46ms
  489. Number of elements fetched individually: 100. Total time: 247ms. Time per element: 2,47ms
  490. Number of elements fetched individually: 100. Total time: 249ms. Time per element: 2,49ms
  491. Number of elements fetched individually: 100. Total time: 248ms. Time per element: 2,48ms
  492. Number of elements fetched individually: 100. Total time: 248ms. Time per element: 2,48ms
  493. Number of elements fetched individually: 100. Total time: 247ms. Time per element: 2,47ms
  494.  
  495. NHibernate v3.3.1.4000 (v3.3.3.4001). Change tracking: True. Caching: False.
  496. --------------------------------------------------------------------------------------------
  497. Set fetches
  498. -------------------------
  499. Number of elements fetched: 31465. Fetch took: 6430ms. Enumerating result took: 5ms
  500. Number of elements fetched: 31465. Fetch took: 4004ms. Enumerating result took: 4ms
  501. Number of elements fetched: 31465. Fetch took: 3991ms. Enumerating result took: 4ms
  502. Number of elements fetched: 31465. Fetch took: 3988ms. Enumerating result took: 4ms
  503. Number of elements fetched: 31465. Fetch took: 3974ms. Enumerating result took: 4ms
  504. Number of elements fetched: 31465. Fetch took: 3970ms. Enumerating result took: 4ms
  505. Number of elements fetched: 31465. Fetch took: 3963ms. Enumerating result took: 4ms
  506. Number of elements fetched: 31465. Fetch took: 4005ms. Enumerating result took: 4ms
  507. Number of elements fetched: 31465. Fetch took: 3975ms. Enumerating result took: 4ms
  508. Number of elements fetched: 31465. Fetch took: 4311ms. Enumerating result took: 4ms
  509. Single element fetches
  510. -------------------------
  511. Number of elements fetched individually: 100. Total time: 106ms. Time per element: 1,06ms
  512. Number of elements fetched individually: 100. Total time: 93ms. Time per element: 0,93ms
  513. Number of elements fetched individually: 100. Total time: 91ms. Time per element: 0,91ms
  514. Number of elements fetched individually: 100. Total time: 92ms. Time per element: 0,92ms
  515. Number of elements fetched individually: 100. Total time: 91ms. Time per element: 0,91ms
  516. Number of elements fetched individually: 100. Total time: 93ms. Time per element: 0,93ms
  517. Number of elements fetched individually: 100. Total time: 92ms. Time per element: 0,92ms
  518. Number of elements fetched individually: 100. Total time: 92ms. Time per element: 0,92ms
  519. Number of elements fetched individually: 100. Total time: 91ms. Time per element: 0,91ms
  520. Number of elements fetched individually: 100. Total time: 94ms. Time per element: 0,94ms
  521.  
  522. Oak.DynamicDb using dynamic Dto class. Change tracking: False. Caching: False.
  523. --------------------------------------------------------------------------------------------
  524. Set fetches
  525. -------------------------
  526. Number of elements fetched: 31465. Fetch took: 1260ms. Enumerating result took: 273ms
  527. Number of elements fetched: 31465. Fetch took: 1156ms. Enumerating result took: 179ms
  528. Number of elements fetched: 31465. Fetch took: 1190ms. Enumerating result took: 180ms
  529. Number of elements fetched: 31465. Fetch took: 1211ms. Enumerating result took: 203ms
  530. Number of elements fetched: 31465. Fetch took: 1211ms. Enumerating result took: 201ms
  531. Number of elements fetched: 31465. Fetch took: 1182ms. Enumerating result took: 183ms
  532. Number of elements fetched: 31465. Fetch took: 1183ms. Enumerating result took: 197ms
  533. Number of elements fetched: 31465. Fetch took: 1196ms. Enumerating result took: 208ms
  534. Number of elements fetched: 31465. Fetch took: 1202ms. Enumerating result took: 203ms
  535. Number of elements fetched: 31465. Fetch took: 1180ms. Enumerating result took: 183ms
  536. Single element fetches
  537. -------------------------
  538. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  539. Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
  540. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  541. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  542. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  543. Number of elements fetched individually: 100. Total time: 55ms. Time per element: 0,55ms
  544. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  545. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  546. Number of elements fetched individually: 100. Total time: 53ms. Time per element: 0,53ms
  547. Number of elements fetched individually: 100. Total time: 54ms. Time per element: 0,54ms
  548.  
  549. Oak.DynamicDb using typed dynamic class. Change tracking: True. Caching: False.
  550. --------------------------------------------------------------------------------------------
  551. Set fetches
  552. -------------------------
  553. Number of elements fetched: 31465. Fetch took: 1200ms. Enumerating result took: 1663ms
  554. Number of elements fetched: 31465. Fetch took: 1157ms. Enumerating result took: 1639ms
  555. Number of elements fetched: 31465. Fetch took: 1223ms. Enumerating result took: 1613ms
  556. Number of elements fetched: 31465. Fetch took: 1229ms. Enumerating result took: 1627ms
  557. Number of elements fetched: 31465. Fetch took: 1224ms. Enumerating result took: 1628ms
  558. Number of elements fetched: 31465. Fetch took: 1163ms. Enumerating result took: 1663ms
  559. Number of elements fetched: 31465. Fetch took: 1440ms. Enumerating result took: 1611ms
  560. Number of elements fetched: 31465. Fetch took: 1219ms. Enumerating result took: 1628ms
  561. Number of elements fetched: 31465. Fetch took: 1209ms. Enumerating result took: 1620ms
  562. Number of elements fetched: 31465. Fetch took: 1169ms. Enumerating result took: 1652ms
  563. Single element fetches
  564. -------------------------
  565. Number of elements fetched individually: 100. Total time: 61ms. Time per element: 0,61ms
  566. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  567. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  568. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  569. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  570. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  571. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  572. Number of elements fetched individually: 100. Total time: 59ms. Time per element: 0,59ms
  573. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  574. Number of elements fetched individually: 100. Total time: 58ms. Time per element: 0,58ms
  575.  
  576. LLBLGen Pro v4.2.0.0 (v4.2.14.0505). Change tracking: True. Caching: True.
  577. --------------------------------------------------------------------------------------------
  578. Set fetches
  579. -------------------------
  580. Number of elements fetched: 31465. Fetch took: 838ms. Enumerating result took: 13ms
  581. Number of elements fetched: 31465. Fetch took: 219ms. Enumerating result took: 7ms
  582. Number of elements fetched: 31465. Fetch took: 171ms. Enumerating result took: 7ms
  583. Number of elements fetched: 31465. Fetch took: 202ms. Enumerating result took: 7ms
  584. Number of elements fetched: 31465. Fetch took: 182ms. Enumerating result took: 7ms
  585. Number of elements fetched: 31465. Fetch took: 209ms. Enumerating result took: 7ms
  586. Number of elements fetched: 31465. Fetch took: 183ms. Enumerating result took: 7ms
  587. Number of elements fetched: 31465. Fetch took: 203ms. Enumerating result took: 7ms
  588. Number of elements fetched: 31465. Fetch took: 172ms. Enumerating result took: 7ms
  589. Number of elements fetched: 31465. Fetch took: 209ms. Enumerating result took: 7ms
  590. Single element fetches
  591. -------------------------
  592. Number of elements fetched individually: 100. Total time: 125ms. Time per element: 1,25ms
  593. Number of elements fetched individually: 100. Total time: 30ms. Time per element: 0,3ms
  594. Number of elements fetched individually: 100. Total time: 29ms. Time per element: 0,29ms
  595. Number of elements fetched individually: 100. Total time: 29ms. Time per element: 0,29ms
  596. Number of elements fetched individually: 100. Total time: 30ms. Time per element: 0,3ms
  597. Number of elements fetched individually: 100. Total time: 30ms. Time per element: 0,3ms
  598. Number of elements fetched individually: 100. Total time: 30ms. Time per element: 0,3ms
  599. Number of elements fetched individually: 100. Total time: 30ms. Time per element: 0,3ms
  600. Number of elements fetched individually: 100. Total time: 30ms. Time per element: 0,3ms
  601. Number of elements fetched individually: 100. Total time: 29ms. Time per element: 0,29ms
  602.  
  603. Averaged total results per framework. Fastest and slowest result omited
  604. ==============================================================================
  605. Non-change tracking fetches, set fetches (10 runs), no caching
  606. ------------------------------------------------------------------------------
  607. Handcoded materializer using DbDataReader : 241,50ms. Enumeration average: 3,00ms
  608. PetaPoco Fast v4.0.3 : 300,13ms. Enumeration average: 2,13ms
  609. PetaPoco v4.0.3 : 328,63ms. Enumeration average: 2,50ms
  610. Dapper : 357,25ms. Enumeration average: 2,13ms
  611. Linq to Sql v4.0.0.0 (v4.0.30319.33440) : 373,63ms. Enumeration average: 2,25ms
  612. Entity Framework v6.0.0.0 (v6.1.30225.0) : 409,63ms. Enumeration average: 2,38ms
  613. LLBLGen Pro v4.2.0.0 (v4.2.14.0505), Poco typed view with QuerySpec : 515,75ms. Enumeration average: 2,00ms
  614. ServiceStack OrmLite v4.0.18.0 (v4.0.18.0) : 556,50ms. Enumeration average: 2,00ms
  615. LLBLGen Pro v4.2.0.0 (v4.2.14.0505), Poco typed view with Linq : 618,25ms. Enumeration average: 2,00ms
  616. LLBLGen Pro v4.2.0.0 (v4.2.14.0505), typed view : 668,25ms. Enumeration average: 5,00ms
  617. Oak.DynamicDb using dynamic Dto class : 1.194,38ms. Enumeration average: 194,75ms
  618.  
  619. Change tracking fetches, set fetches (10 runs), no caching
  620. ------------------------------------------------------------------------------
  621. DataTable, using DbDataAdapter : 421,38ms. Enumeration average: 53,00ms
  622. Linq to Sql v4.0.0.0 (v4.0.30319.33440) : 571,00ms. Enumeration average: 3,00ms
  623. LLBLGen Pro v4.2.0.0 (v4.2.14.0505) : 667,88ms. Enumeration average: 11,25ms
  624. Telerik DataAccess/OpenAccess Domain v4.0.3 : 1.202,88ms. Enumeration average: 3,00ms
  625. Oak.DynamicDb using typed dynamic class : 1.204,50ms. Enumeration average: 1.633,75ms
  626. Telerik DataAccess/OpenAccess Fluent v4.0.3 : 1.247,50ms. Enumeration average: 3,50ms
  627. Entity Framework v6.0.0.0 (v6.1.30225.0) : 3.840,63ms. Enumeration average: 3,00ms
  628. NHibernate v3.3.1.4000 (v3.3.3.4001) : 4.027,25ms. Enumeration average: 4,00ms
  629.  
  630. Non-change tracking individual fetches (100 elements, 10 runs), no caching
  631. ------------------------------------------------------------------------------
  632. Handcoded materializer using DbDataReader : 0,43ms per individual fetch
  633. Dapper : 0,45ms per individual fetch
  634. ServiceStack OrmLite v4.0.18.0 (v4.0.18.0) : 0,53ms per individual fetch
  635. Oak.DynamicDb using dynamic Dto class : 0,54ms per individual fetch
  636. PetaPoco Fast v4.0.3 : 0,84ms per individual fetch
  637. LLBLGen Pro v4.2.0.0 (v4.2.14.0505), Poco typed view with QuerySpec : 0,86ms per individual fetch
  638. LLBLGen Pro v4.2.0.0 (v4.2.14.0505), typed view : 1,09ms per individual fetch
  639. Entity Framework v6.0.0.0 (v6.1.30225.0) : 1,79ms per individual fetch
  640. Linq to Sql v4.0.0.0 (v4.0.30319.33440) : 2,30ms per individual fetch
  641. LLBLGen Pro v4.2.0.0 (v4.2.14.0505), Poco typed view with Linq : 2,50ms per individual fetch
  642. PetaPoco v4.0.3 : 3,49ms per individual fetch
  643.  
  644. Change tracking individual fetches (100 elements, 10 runs), no caching
  645. ------------------------------------------------------------------------------
  646. DataTable, using DbDataAdapter : 0,58ms per individual fetch
  647. Oak.DynamicDb using typed dynamic class : 0,58ms per individual fetch
  648. Telerik DataAccess/OpenAccess Fluent v4.0.3 : 0,63ms per individual fetch
  649. Telerik DataAccess/OpenAccess Domain v4.0.3 : 0,63ms per individual fetch
  650. LLBLGen Pro v4.2.0.0 (v4.2.14.0505) : 0,80ms per individual fetch
  651. NHibernate v3.3.1.4000 (v3.3.3.4001) : 0,92ms per individual fetch
  652. Entity Framework v6.0.0.0 (v6.1.30225.0) : 2,10ms per individual fetch
  653. Linq to Sql v4.0.0.0 (v4.0.30319.33440) : 2,47ms per individual fetch
  654.  
  655. Change tracking fetches, set fetches (10 runs), caching
  656. ------------------------------------------------------------------------------
  657. LLBLGen Pro v4.2.0.0 (v4.2.14.0505) : 197,38ms. Enumeration average: 7,00ms
  658.  
  659. Change tracking individual fetches (100 elements, 10 runs), caching
  660. ------------------------------------------------------------------------------
  661. LLBLGen Pro v4.2.0.0 (v4.2.14.0505) : 0,30ms per individual fetch
  662.  
  663. Complete. Press enter to exit.
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!