SHARE
TWEET

Untitled

a guest Jul 15th, 2019 75 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ============================
  2. Vanilla
  3. ----
  4. 400000
  5. 250
  6. Driver Name?= Microsoft JDBC Driver 7.3 for SQL Server, Driver Version?= 7.3.1.0, Product Name?= Microsoft SQL Server, Product Version?= 12.00.5571
  7. rate 550 insert/s. progress 250/400000
  8. rate 1190 insert/s. progress 500/400000
  9. rate 605 insert/s. progress 750/400000
  10. rate 939 insert/s. progress 1000/400000
  11. rate 537 insert/s. progress 1250/400000
  12. rate 1086 insert/s. progress 1500/400000
  13. rate 1213 insert/s. progress 1750/400000
  14. rate 1231 insert/s. progress 2000/400000
  15. rate 1243 insert/s. progress 2250/400000
  16. rate 1157 insert/s. progress 2500/400000
  17. rate 778 insert/s. progress 2750/400000
  18. rate 1207 insert/s. progress 3000/400000
  19. [...]
  20. rate 1201 insert/s. progress 399250/400000
  21. rate 1190 insert/s. progress 399500/400000
  22. rate 1082 insert/s. progress 399750/400000
  23. rate 1207 insert/s. progress 400000/400000
  24. total duration 353961ms
  25. final rate 1130 insert/s
  26.  
  27. ============================
  28. 7.3.1.jre11-preview
  29. ----
  30. 400000
  31. 250
  32. Driver Name?= Microsoft JDBC Driver 7.3 for SQL Server, Driver Version?= 7.3.1.0, Product Name?= Microsoft SQL Server, Product Version?= 12.00.5571
  33. rate 517 insert/s. progress 250/400000
  34. rate 1141 insert/s. progress 500/400000
  35. rate 850 insert/s. progress 750/400000
  36. rate 886 insert/s. progress 1000/400000
  37. rate 615 insert/s. progress 1250/400000
  38. rate 1091 insert/s. progress 1500/400000
  39. rate 1219 insert/s. progress 1750/400000
  40. rate 1101 insert/s. progress 2000/400000
  41. rate 1136 insert/s. progress 2250/400000
  42. rate 1275 insert/s. progress 2500/400000
  43. [...]
  44. rate 1012 insert/s. progress 398750/400000
  45. rate 1225 insert/s. progress 399000/400000
  46. rate 746 insert/s. progress 399250/400000
  47. rate 1136 insert/s. progress 399500/400000
  48. rate 1173 insert/s. progress 399750/400000
  49. rate 1012 insert/s. progress 400000/400000
  50. total duration 347770ms
  51. final rate 1150 insert/s
  52.  
  53.  
  54. ============================
  55. 7.2.2.jre8
  56. ----
  57. 400000
  58. 250
  59. Driver Name?= Microsoft JDBC Driver 7.2 for SQL Server, Driver Version?= 7.2.2.0, Product Name?= Microsoft SQL Server, Product Version?= 12.00.5571
  60. rate 645 insert/s. progress 250/400000
  61. rate 1082 insert/s. progress 500/400000
  62. rate 798 insert/s. progress 750/400000
  63. rate 936 insert/s. progress 1000/400000
  64. rate 886 insert/s. progress 1250/400000
  65. rate 825 insert/s. progress 1500/400000
  66. rate 1050 insert/s. progress 1750/400000
  67. rate 1219 insert/s. progress 2000/400000
  68. rate 1231 insert/s. progress 2250/400000
  69. rate 1231 insert/s. progress 2500/400000
  70. rate 1020 insert/s. progress 2750/400000
  71. rate 996 insert/s. progress 3000/400000
  72. rate 1225 insert/s. progress 3250/400000
  73. rate 415 insert/s. progress 3500/400000
  74. rate 1077 insert/s. progress 3750/400000
  75. rate 950 insert/s. progress 4000/400000
  76. rate 1196 insert/s. progress 4250/400000
  77. rate 1262 insert/s. progress 4500/400000
  78. [...]
  79. rate 1243 insert/s. progress 398500/400000
  80. rate 1033 insert/s. progress 398750/400000
  81. rate 1141 insert/s. progress 399000/400000
  82. rate 1190 insert/s. progress 399250/400000
  83. rate 1225 insert/s. progress 399500/400000
  84. rate 388 insert/s. progress 399750/400000
  85. rate 896 insert/s. progress 400000/400000
  86. total duration 351764ms
  87. final rate 1137 insert/s
  88.  
  89. ============================
  90. 7.2.2.jre11
  91. close all statements and connection
  92. ----
  93. 400000
  94. 250
  95. Driver Name?= Microsoft JDBC Driver 7.2 for SQL Server, Driver Version?= 7.2.2.0, Product Name?= Microsoft SQL Server, Product Version?= 12.00.5571
  96. rate 553 insert/s. progress 250/400000
  97. rate 1041 insert/s. progress 500/400000
  98. rate 822 insert/s. progress 750/400000
  99. rate 909 insert/s. progress 1000/400000
  100. rate 905 insert/s. progress 1250/400000
  101. rate 1179 insert/s. progress 1500/400000
  102. rate 1179 insert/s. progress 1750/400000
  103. rate 1141 insert/s. progress 2000/400000
  104. rate 1157 insert/s. progress 2250/400000
  105. rate 877 insert/s. progress 2500/400000
  106. rate 1152 insert/s. progress 2750/400000
  107. [...]
  108. rate 1179 insert/s. progress 398250/400000
  109. rate 1131 insert/s. progress 398500/400000
  110. rate 1243 insert/s. progress 398750/400000
  111. rate 1207 insert/s. progress 399000/400000
  112. rate 1225 insert/s. progress 399250/400000
  113. rate 1116 insert/s. progress 399500/400000
  114. rate 1096 insert/s. progress 399750/400000
  115. rate 1275 insert/s. progress 400000/400000
  116. total duration 347772ms
  117. final rate 1150 insert/s
  118.  
  119. ============================
  120. 7.2.2.jre11
  121. close all statements and connection
  122. autoCommit=false
  123. ----
  124. 400000
  125. 250
  126. Driver Name?= Microsoft JDBC Driver 7.2 for SQL Server, Driver Version?= 7.2.2.0, Product Name?= Microsoft SQL Server, Product Version?= 12.00.5571
  127. rate 769 insert/s. progress 250/400000
  128. rate 2032 insert/s. progress 500/400000
  129. rate 1152 insert/s. progress 750/400000
  130. rate 1366 insert/s. progress 1000/400000
  131. rate 1612 insert/s. progress 1250/400000
  132. rate 2192 insert/s. progress 1500/400000
  133. rate 2232 insert/s. progress 1750/400000
  134. rate 2252 insert/s. progress 2000/400000
  135. [...]
  136. rate 2358 insert/s. progress 398250/400000
  137. rate 2358 insert/s. progress 398500/400000
  138. rate 2336 insert/s. progress 398750/400000
  139. rate 1865 insert/s. progress 399000/400000
  140. rate 2314 insert/s. progress 399250/400000
  141. rate 2314 insert/s. progress 399500/400000
  142. rate 2272 insert/s. progress 399750/400000
  143. rate 2293 insert/s. progress 400000/400000
  144. total duration 184759ms
  145. final rate 2164 insert/s
  146.  
  147.  
  148. ============================
  149. 7.2.2.jre11
  150. close all statements and connection
  151. autoCommit=false
  152. into real table LIVE_MEASURES
  153. ----
  154. 400000
  155. 250
  156. Driver Name?= Microsoft JDBC Driver 7.2 for SQL Server, Driver Version?= 7.2.2.0, Product Name?= Microsoft SQL Server, Product Version?= 12.00.5571
  157. rate 704 insert/s. progress 250/400000
  158. rate 520 insert/s. progress 500/400000
  159. rate 1524 insert/s. progress 750/400000
  160. rate 2252 insert/s. progress 1000/400000
  161. rate 2192 insert/s. progress 1250/400000
  162. rate 2173 insert/s. progress 1500/400000
  163. rate 2252 insert/s. progress 1750/400000
  164. rate 2212 insert/s. progress 2000/400000
  165. rate 2252 insert/s. progress 2250/400000
  166. rate 735 insert/s. progress 2500/400000
  167. rate 2252 insert/s. progress 2750/400000
  168. rate 2155 insert/s. progress 3000/400000
  169. rate 2232 insert/s. progress 3250/400000
  170. [...]
  171. rate 2232 insert/s. progress 398250/400000
  172. rate 2192 insert/s. progress 398500/400000
  173. rate 2272 insert/s. progress 398750/400000
  174. rate 2192 insert/s. progress 399000/400000
  175. rate 2252 insert/s. progress 399250/400000
  176. rate 2212 insert/s. progress 399500/400000
  177. rate 2272 insert/s. progress 399750/400000
  178. rate 2192 insert/s. progress 400000/400000
  179. total duration 189842ms
  180. final rate 2107 insert/s
  181.  
  182. ============================
  183. 7.2.2.jre11
  184. close all statements and connection
  185. autoCommit=false
  186. into real table LIVE_MEASURES with setBytes
  187. ----
  188. 400000
  189. 250
  190. Driver Name?= Microsoft JDBC Driver 7.2 for SQL Server, Driver Version?= 7.2.2.0, Product Name?= Microsoft SQL Server, Product Version?= 12.00.5571
  191. rate 652 insert/s. progress 250/400000
  192. rate 1700 insert/s. progress 500/400000
  193. rate 1824 insert/s. progress 750/400000
  194. rate 1785 insert/s. progress 1000/400000
  195. rate 1908 insert/s. progress 1250/400000
  196. rate 1968 insert/s. progress 1500/400000
  197. rate 1724 insert/s. progress 1750/400000
  198. [...]
  199. rate 1968 insert/s. progress 398500/400000
  200. rate 1953 insert/s. progress 398750/400000
  201. rate 1984 insert/s. progress 399000/400000
  202. rate 1937 insert/s. progress 399250/400000
  203. rate 1968 insert/s. progress 399500/400000
  204. rate 1984 insert/s. progress 399750/400000
  205. rate 1953 insert/s. progress 400000/400000
  206. total duration 210325ms
  207. final rate 1901 insert/s
  208.  
  209.  
  210. ===========================
  211. verify we change the same Connection object in SQ and test program
  212. ----
  213. we have the pool in the middle, but underneath, we have a SQLServerConnection and all have databaseAutoCommitMode=false
RAW Paste Data
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!
 
Top