Skip to content

Instantly share code, notes, and snippets.

@sns-seb

sns-seb/gist:9469dd82050111f759cf9c6a38f3a4d9

Created July 4, 2019 07:31
Show Gist options
  • Save sns-seb/9469dd82050111f759cf9c6a38f3a4d9 to your computer and use it in GitHub Desktop.
Save sns-seb/9469dd82050111f759cf9c6a38f3a4d9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
============================
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment