Want more features on Pastebin? Sign Up, it's FREE!
Guest

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

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