API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 17th, 2014
76
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.46 KB | None | 0 0
raw download clone embed print report
  1. +-------------------------------------------------------------------------------------------
  2. | Raw Data Access / ORM Benchmarks.
  3. | Code available at : https://github.com/FransBouma/RawDataAccessBencher
  4. | Benchmarks run on : 17. februar 2014 17:33:25
  5. | Registered benchmarks :
  6. | Handcoded materializer using DbDataReader. Change tracking: False. Caching: False.
  7. | NHibernate Optimized v3.3.1.4000 (v3.3.3.4001). Change tracking: True. Caching: False.
  8. | NHibernate v3.3.1.4000 (v3.3.3.4001). Change tracking: True. Caching: False.
  9. | Run set benchmarks : True
  10. | Run individual fetch benchmarks: True
  11. | Number of set fetches : 10
  12. | Number of individual keys : 100
  13. | Release build : True
  14. | Client OS : Microsoft Windows NT 6.2.9200.0 (64bit)
  15. | Bencher runs as 64bit : True
  16. | CLR version : 4.0.30319.34011
  17. | Number of CPUs : 8
  18. | Server used : (localdb)\v11.0
  19. | Catalog used : AdventureWorks
  20. | SQL Server version used : 11.00.3000
  21. +-------------------------------------------------------------------------------------------
  22.  
  23.  
  24. Warming up DB, DB client code and CLR
  25. ====================================================================
  26.  
  27. DataTable, using DbDataAdapter. Change tracking: True. Caching: False.
  28. --------------------------------------------------------------------------------------------
  29. Number of elements fetched: 31465. Fetch took: 620ms. Enumerating result took: 65ms
  30. Number of elements fetched: 31465. Fetch took: 284ms. Enumerating result took: 62ms
  31. Number of elements fetched: 31465. Fetch took: 287ms. Enumerating result took: 63ms
  32. Number of elements fetched: 31465. Fetch took: 272ms. Enumerating result took: 63ms
  33. Number of elements fetched: 31465. Fetch took: 299ms. Enumerating result took: 63ms
  34. Number of elements fetched: 31465. Fetch took: 271ms. Enumerating result took: 63ms
  35. Number of elements fetched: 31465. Fetch took: 304ms. Enumerating result took: 64ms
  36. Number of elements fetched: 31465. Fetch took: 278ms. Enumerating result took: 64ms
  37. Number of elements fetched: 31465. Fetch took: 274ms. Enumerating result took: 64ms
  38. Number of elements fetched: 31465. Fetch took: 278ms. Enumerating result took: 62ms
  39.  
  40. Starting benchmarks.
  41. ====================================================================
  42.  
  43. Handcoded materializer using DbDataReader. Change tracking: False. Caching: False.
  44. --------------------------------------------------------------------------------------------
  45. Set fetches
  46. -------------------------
  47. Number of elements fetched: 31465. Fetch took: 182ms. Enumerating result took: 2ms
  48. Number of elements fetched: 31465. Fetch took: 164ms. Enumerating result took: 1ms
  49. Number of elements fetched: 31465. Fetch took: 165ms. Enumerating result took: 1ms
  50. Number of elements fetched: 31465. Fetch took: 173ms. Enumerating result took: 1ms
  51. Number of elements fetched: 31465. Fetch took: 169ms. Enumerating result took: 1ms
  52. Number of elements fetched: 31465. Fetch took: 160ms. Enumerating result took: 1ms
  53. Number of elements fetched: 31465. Fetch took: 168ms. Enumerating result took: 1ms
  54. Number of elements fetched: 31465. Fetch took: 158ms. Enumerating result took: 1ms
  55. Number of elements fetched: 31465. Fetch took: 175ms. Enumerating result took: 1ms
  56. Number of elements fetched: 31465. Fetch took: 162ms. Enumerating result took: 1ms
  57. Single element fetches
  58. -------------------------
  59. Number of elements fetched individually: 100. Total time: 57ms. Time per element: 0,57ms
  60. Number of elements fetched individually: 100. Total time: 21ms. Time per element: 0,21ms
  61. Number of elements fetched individually: 100. Total time: 22ms. Time per element: 0,22ms
  62. Number of elements fetched individually: 100. Total time: 22ms. Time per element: 0,22ms
  63. Number of elements fetched individually: 100. Total time: 18ms. Time per element: 0,18ms
  64. Number of elements fetched individually: 100. Total time: 18ms. Time per element: 0,18ms
  65. Number of elements fetched individually: 100. Total time: 18ms. Time per element: 0,18ms
  66. Number of elements fetched individually: 100. Total time: 17ms. Time per element: 0,17ms
  67. Number of elements fetched individually: 100. Total time: 20ms. Time per element: 0,2ms
  68. Number of elements fetched individually: 100. Total time: 18ms. Time per element: 0,18ms
  69.  
  70. NHibernate Optimized v3.3.1.4000 (v3.3.3.4001). Change tracking: True. Caching: False.
  71. --------------------------------------------------------------------------------------------
  72. Set fetches
  73. -------------------------
  74. Number of elements fetched: 31465. Fetch took: 5831ms. Enumerating result took: 2ms
  75. Number of elements fetched: 31465. Fetch took: 2955ms. Enumerating result took: 1ms
  76. Number of elements fetched: 31465. Fetch took: 2966ms. Enumerating result took: 1ms
  77. Number of elements fetched: 31465. Fetch took: 2967ms. Enumerating result took: 1ms
  78. Number of elements fetched: 31465. Fetch took: 2937ms. Enumerating result took: 1ms
  79. Number of elements fetched: 31465. Fetch took: 2944ms. Enumerating result took: 1ms
  80. Number of elements fetched: 31465. Fetch took: 2956ms. Enumerating result took: 1ms
  81. Number of elements fetched: 31465. Fetch took: 3132ms. Enumerating result took: 1ms
  82. Number of elements fetched: 31465. Fetch took: 2968ms. Enumerating result took: 1ms
  83. Number of elements fetched: 31465. Fetch took: 2991ms. Enumerating result took: 1ms
  84. Single element fetches
  85. -------------------------
  86. Number of elements fetched individually: 100. Total time: 99ms. Time per element: 0,99ms
  87. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  88. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  89. Number of elements fetched individually: 100. Total time: 63ms. Time per element: 0,63ms
  90. Number of elements fetched individually: 100. Total time: 63ms. Time per element: 0,63ms
  91. Number of elements fetched individually: 100. Total time: 61ms. Time per element: 0,61ms
  92. Number of elements fetched individually: 100. Total time: 62ms. Time per element: 0,62ms
  93. Number of elements fetched individually: 100. Total time: 69ms. Time per element: 0,69ms
  94. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  95. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  96.  
  97. NHibernate v3.3.1.4000 (v3.3.3.4001). Change tracking: True. Caching: False.
  98. --------------------------------------------------------------------------------------------
  99. Set fetches
  100. -------------------------
  101. Number of elements fetched: 31465. Fetch took: 3229ms. Enumerating result took: 2ms
  102. Number of elements fetched: 31465. Fetch took: 2999ms. Enumerating result took: 1ms
  103. Number of elements fetched: 31465. Fetch took: 3046ms. Enumerating result took: 1ms
  104. Number of elements fetched: 31465. Fetch took: 3188ms. Enumerating result took: 1ms
  105. Number of elements fetched: 31465. Fetch took: 3095ms. Enumerating result took: 1ms
  106. Number of elements fetched: 31465. Fetch took: 3031ms. Enumerating result took: 1ms
  107. Number of elements fetched: 31465. Fetch took: 2997ms. Enumerating result took: 1ms
  108. Number of elements fetched: 31465. Fetch took: 3009ms. Enumerating result took: 1ms
  109. Number of elements fetched: 31465. Fetch took: 3017ms. Enumerating result took: 1ms
  110. Number of elements fetched: 31465. Fetch took: 3035ms. Enumerating result took: 1ms
  111. Single element fetches
  112. -------------------------
  113. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  114. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  115. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  116. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  117. Number of elements fetched individually: 100. Total time: 64ms. Time per element: 0,64ms
  118. Number of elements fetched individually: 100. Total time: 63ms. Time per element: 0,63ms
  119. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  120. Number of elements fetched individually: 100. Total time: 67ms. Time per element: 0,67ms
  121. Number of elements fetched individually: 100. Total time: 65ms. Time per element: 0,65ms
  122. Number of elements fetched individually: 100. Total time: 66ms. Time per element: 0,66ms
  123.  
  124. Averaged total results per framework. Fastest and slowest result omited
  125. ==============================================================================
  126. Non-change tracking fetches, set fetches (10 runs), no caching
  127. ------------------------------------------------------------------------------
  128. Handcoded materializer using DbDataReader : 167,00ms. Enumeration average: 1,00ms
  129.  
  130. Change tracking fetches, set fetches (10 runs), no caching
  131. ------------------------------------------------------------------------------
  132. NHibernate Optimized v3.3.1.4000 (v3.3.3.4001) : 2 984,88ms. Enumeration average: 1,00ms
  133. NHibernate v3.3.1.4000 (v3.3.3.4001) : 3 052,50ms. Enumeration average: 1,00ms
  134.  
  135. Non-change tracking individual fetches (100 elements, 10 runs), no caching
  136. ------------------------------------------------------------------------------
  137. Handcoded materializer using DbDataReader : 0,20ms per individual fetch
  138.  
  139. Change tracking individual fetches (100 elements, 10 runs), no caching
  140. ------------------------------------------------------------------------------
  141. NHibernate Optimized v3.3.1.4000 (v3.3.3.4001) : 0,65ms per individual fetch
  142. NHibernate v3.3.1.4000 (v3.3.3.4001) : 0,66ms per individual fetch
  143.  
  144. Change tracking fetches, set fetches (10 runs), caching
  145. ------------------------------------------------------------------------------
  146.  
  147. Change tracking individual fetches (100 elements, 10 runs), caching
  148. ------------------------------------------------------------------------------
  149.  
  150. Complete.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!