Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ============================
- Vanilla
- ----
- 400000
- 250
- 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
- rate 550 insert/s. progress 250/400000
- rate 1190 insert/s. progress 500/400000
- rate 605 insert/s. progress 750/400000
- rate 939 insert/s. progress 1000/400000
- rate 537 insert/s. progress 1250/400000
- rate 1086 insert/s. progress 1500/400000
- rate 1213 insert/s. progress 1750/400000
- rate 1231 insert/s. progress 2000/400000
- rate 1243 insert/s. progress 2250/400000
- rate 1157 insert/s. progress 2500/400000
- rate 778 insert/s. progress 2750/400000
- rate 1207 insert/s. progress 3000/400000
- [...]
- rate 1201 insert/s. progress 399250/400000
- rate 1190 insert/s. progress 399500/400000
- rate 1082 insert/s. progress 399750/400000
- rate 1207 insert/s. progress 400000/400000
- total duration 353961ms
- final rate 1130 insert/s
- ============================
- 7.3.1.jre11-preview
- ----
- 400000
- 250
- 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
- rate 517 insert/s. progress 250/400000
- rate 1141 insert/s. progress 500/400000
- rate 850 insert/s. progress 750/400000
- rate 886 insert/s. progress 1000/400000
- rate 615 insert/s. progress 1250/400000
- rate 1091 insert/s. progress 1500/400000
- rate 1219 insert/s. progress 1750/400000
- rate 1101 insert/s. progress 2000/400000
- rate 1136 insert/s. progress 2250/400000
- rate 1275 insert/s. progress 2500/400000
- [...]
- rate 1012 insert/s. progress 398750/400000
- rate 1225 insert/s. progress 399000/400000
- rate 746 insert/s. progress 399250/400000
- rate 1136 insert/s. progress 399500/400000
- rate 1173 insert/s. progress 399750/400000
- rate 1012 insert/s. progress 400000/400000
- total duration 347770ms
- final rate 1150 insert/s
- ============================
- 7.2.2.jre8
- ----
- 400000
- 250
- 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
- rate 645 insert/s. progress 250/400000
- rate 1082 insert/s. progress 500/400000
- rate 798 insert/s. progress 750/400000
- rate 936 insert/s. progress 1000/400000
- rate 886 insert/s. progress 1250/400000
- rate 825 insert/s. progress 1500/400000
- rate 1050 insert/s. progress 1750/400000
- rate 1219 insert/s. progress 2000/400000
- rate 1231 insert/s. progress 2250/400000
- rate 1231 insert/s. progress 2500/400000
- rate 1020 insert/s. progress 2750/400000
- rate 996 insert/s. progress 3000/400000
- rate 1225 insert/s. progress 3250/400000
- rate 415 insert/s. progress 3500/400000
- rate 1077 insert/s. progress 3750/400000
- rate 950 insert/s. progress 4000/400000
- rate 1196 insert/s. progress 4250/400000
- rate 1262 insert/s. progress 4500/400000
- [...]
- rate 1243 insert/s. progress 398500/400000
- rate 1033 insert/s. progress 398750/400000
- rate 1141 insert/s. progress 399000/400000
- rate 1190 insert/s. progress 399250/400000
- rate 1225 insert/s. progress 399500/400000
- rate 388 insert/s. progress 399750/400000
- rate 896 insert/s. progress 400000/400000
- total duration 351764ms
- final rate 1137 insert/s
- ============================
- 7.2.2.jre11
- close all statements and connection
- ----
- 400000
- 250
- 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
- rate 553 insert/s. progress 250/400000
- rate 1041 insert/s. progress 500/400000
- rate 822 insert/s. progress 750/400000
- rate 909 insert/s. progress 1000/400000
- rate 905 insert/s. progress 1250/400000
- rate 1179 insert/s. progress 1500/400000
- rate 1179 insert/s. progress 1750/400000
- rate 1141 insert/s. progress 2000/400000
- rate 1157 insert/s. progress 2250/400000
- rate 877 insert/s. progress 2500/400000
- rate 1152 insert/s. progress 2750/400000
- [...]
- rate 1179 insert/s. progress 398250/400000
- rate 1131 insert/s. progress 398500/400000
- rate 1243 insert/s. progress 398750/400000
- rate 1207 insert/s. progress 399000/400000
- rate 1225 insert/s. progress 399250/400000
- rate 1116 insert/s. progress 399500/400000
- rate 1096 insert/s. progress 399750/400000
- rate 1275 insert/s. progress 400000/400000
- total duration 347772ms
- final rate 1150 insert/s
- ============================
- 7.2.2.jre11
- close all statements and connection
- autoCommit=false
- ----
- 400000
- 250
- 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
- rate 769 insert/s. progress 250/400000
- rate 2032 insert/s. progress 500/400000
- rate 1152 insert/s. progress 750/400000
- rate 1366 insert/s. progress 1000/400000
- rate 1612 insert/s. progress 1250/400000
- rate 2192 insert/s. progress 1500/400000
- rate 2232 insert/s. progress 1750/400000
- rate 2252 insert/s. progress 2000/400000
- [...]
- rate 2358 insert/s. progress 398250/400000
- rate 2358 insert/s. progress 398500/400000
- rate 2336 insert/s. progress 398750/400000
- rate 1865 insert/s. progress 399000/400000
- rate 2314 insert/s. progress 399250/400000
- rate 2314 insert/s. progress 399500/400000
- rate 2272 insert/s. progress 399750/400000
- rate 2293 insert/s. progress 400000/400000
- total duration 184759ms
- final rate 2164 insert/s
- ============================
- 7.2.2.jre11
- close all statements and connection
- autoCommit=false
- into real table LIVE_MEASURES
- ----
- 400000
- 250
- 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
- rate 704 insert/s. progress 250/400000
- rate 520 insert/s. progress 500/400000
- rate 1524 insert/s. progress 750/400000
- rate 2252 insert/s. progress 1000/400000
- rate 2192 insert/s. progress 1250/400000
- rate 2173 insert/s. progress 1500/400000
- rate 2252 insert/s. progress 1750/400000
- rate 2212 insert/s. progress 2000/400000
- rate 2252 insert/s. progress 2250/400000
- rate 735 insert/s. progress 2500/400000
- rate 2252 insert/s. progress 2750/400000
- rate 2155 insert/s. progress 3000/400000
- rate 2232 insert/s. progress 3250/400000
- [...]
- rate 2232 insert/s. progress 398250/400000
- rate 2192 insert/s. progress 398500/400000
- rate 2272 insert/s. progress 398750/400000
- rate 2192 insert/s. progress 399000/400000
- rate 2252 insert/s. progress 399250/400000
- rate 2212 insert/s. progress 399500/400000
- rate 2272 insert/s. progress 399750/400000
- rate 2192 insert/s. progress 400000/400000
- total duration 189842ms
- final rate 2107 insert/s
- ============================
- 7.2.2.jre11
- close all statements and connection
- autoCommit=false
- into real table LIVE_MEASURES with setBytes
- ----
- 400000
- 250
- 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
- rate 652 insert/s. progress 250/400000
- rate 1700 insert/s. progress 500/400000
- rate 1824 insert/s. progress 750/400000
- rate 1785 insert/s. progress 1000/400000
- rate 1908 insert/s. progress 1250/400000
- rate 1968 insert/s. progress 1500/400000
- rate 1724 insert/s. progress 1750/400000
- [...]
- rate 1968 insert/s. progress 398500/400000
- rate 1953 insert/s. progress 398750/400000
- rate 1984 insert/s. progress 399000/400000
- rate 1937 insert/s. progress 399250/400000
- rate 1968 insert/s. progress 399500/400000
- rate 1984 insert/s. progress 399750/400000
- rate 1953 insert/s. progress 400000/400000
- total duration 210325ms
- final rate 1901 insert/s
- ===========================
- verify we change the same Connection object in SQ and test program
- ----
- we have the pool in the middle, but underneath, we have a SQLServerConnection and all have databaseAutoCommitMode=false
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement