sql/dml: Update existing benchmark file with new MBP, Go, MySQL driver
sql/dml: Update existing benchmark file with new MBP, Go, MySQL driver

MacBook Pro (13-inch, 2017, Two Thunderbolt 3 ports)
2.5 GHz Intel Core i7
go version devel +447965d4e0 Sun Jan 27 04:18:10 2019 +0000 darwin/amd64

$ benchstat bmStat_baseline.txt bmStat_baseline_609db6db.txt
name                                              old time/op    new time/op    delta
Interpolate-4                                       2.61µs ± 2%    1.61µs ± 2%   -38.36%  (p=0.008 n=5+5)
IsValidIdentifier-4                                  266ns ± 1%     195ns ± 5%   -26.70%  (p=0.016 n=4+5)
QuoteAlias-4                                         177ns ± 1%     115ns ± 3%   -35.18%  (p=0.008 n=5+5)
Conditions_writeOnDuplicateKey-4                     343ns ± 2%     215ns ± 1%   -37.43%  (p=0.008 n=5+5)
DialectEscapeTime-4                                  263ns ± 1%     161ns ± 0%   -38.72%  (p=0.008 n=5+5)
ArgumentEncoding/all_types_without_warm_up-4        7.35µs ± 1%    4.95µs ± 0%   -32.65%  (p=0.008 n=5+5)
ArgumentEncoding/all_types_with_warm_up-4           2.96µs ± 2%    1.93µs ± 0%   -34.90%  (p=0.008 n=5+5)
ArgumentEncoding/number_slices_without_warm_up-4    2.28µs ± 1%    1.51µs ± 0%   -33.57%  (p=0.008 n=5+5)
ArgumentEncoding/number_slices_with_warm_up-4        911ns ± 0%     577ns ± 0%   -36.61%  (p=0.008 n=5+5)
ArgumentEncoding/numbers_without_warm_up-4          1.05µs ± 2%    0.67µs ± 0%   -36.45%  (p=0.016 n=5+4)
ArgumentEncoding/numbers_with_warm_up-4              387ns ± 1%     232ns ± 0%   -39.95%  (p=0.008 n=5+5)
Select_Rows-4                                       3.33µs ± 0%    2.25µs ± 1%   -32.63%  (p=0.008 n=5+5)
SelectBasicSQL-4                                    2.81µs ± 4%    1.75µs ± 0%   -37.70%  (p=0.008 n=5+5)
SelectFullSQL/NewSelect-4                           5.57µs ± 1%    3.63µs ± 0%   -34.89%  (p=0.008 n=5+5)
SelectFullSQL/ToSQL_Interpolate_NoCache-4           2.79µs ± 1%    1.78µs ± 1%   -36.30%  (p=0.008 n=5+5)
SelectFullSQL/ToSQL_Interpolate_Cache-4              133ns ± 2%      88ns ± 0%   -33.96%  (p=0.008 n=5+5)
Select_Large_IN/SQL-4                               81.5µs ± 0%    26.4µs ± 1%   -67.59%  (p=0.008 n=5+5)
Select_Large_IN/interpolate-4                       85.1µs ± 2%    27.6µs ± 1%   -67.59%  (p=0.008 n=5+5)
Select_Large_IN/interpolate_named-4                 85.8µs ± 2%    27.9µs ± 0%   -67.42%  (p=0.008 n=5+5)
Select_ComplexAddColumns-4                          3.24µs ± 0%    2.10µs ± 0%   -35.20%  (p=0.008 n=5+5)
Select_SQLCase-4                                    8.54µs ± 0%    5.33µs ± 0%   -37.63%  (p=0.008 n=5+5)
DeleteSQL/NewDelete-4                               1.23µs ± 0%    0.81µs ± 1%   -33.65%  (p=0.016 n=4+5)
DeleteSQL/ToSQL_no_cache-4                           729ns ± 0%     478ns ± 0%   -34.41%  (p=0.008 n=5+5)
DeleteSQL/ToSQL_with_cache-4                        82.4ns ± 1%    53.5ns ± 1%   -35.06%  (p=0.008 n=5+5)
InsertValuesSQL/NewInsert-4                         1.54µs ± 0%    1.03µs ± 0%   -33.38%  (p=0.016 n=5+4)
InsertValuesSQL/ToSQL_no_cache-4                    1.37µs ± 2%    0.90µs ± 1%   -34.56%  (p=0.008 n=5+5)
InsertValuesSQL/ToSQL_with_cache-4                   823ns ± 1%     517ns ± 1%   -37.19%  (p=0.008 n=5+5)
InsertRecordsSQL-4                                  1.87µs ± 0%    1.22µs ± 1%   -34.62%  (p=0.008 n=5+5)
Repeat/multi-4                                      1.25µs ± 2%    0.79µs ± 0%   -36.75%  (p=0.008 n=5+5)
Repeat/single-4                                      713ns ± 2%     437ns ± 0%   -38.75%  (p=0.008 n=5+5)
QuoteAs-4                                            181ns ± 2%     113ns ± 1%   -37.86%  (p=0.008 n=5+5)
QuoteQuote/Worse_Case-4                              324ns ± 2%     207ns ± 0%   -36.23%  (p=0.008 n=5+5)
QuoteQuote/Best_Case-4                               101ns ± 1%      73ns ± 0%   -27.85%  (p=0.008 n=5+5)
IfNull/3_args_expression_right-4                     278ns ± 1%     183ns ± 0%   -34.22%  (p=0.016 n=5+4)
IfNull/3_args_no_qualifier-4                         314ns ± 1%     208ns ± 1%   -33.69%  (p=0.008 n=5+5)
IfNull/3_args_with_qualifier-4                       415ns ± 2%     270ns ± 0%   -34.94%  (p=0.016 n=5+4)
IfNull/4_args-4                                      299ns ± 1%     193ns ± 1%   -35.41%  (p=0.008 n=5+5)
IfNull/5_args-4                                      298ns ± 1%     192ns ± 0%   -35.48%  (p=0.008 n=5+5)
Union/5_SELECTs-4                                    359ns ± 1%     234ns ± 0%   -34.74%  (p=0.008 n=5+5)
Union/5_SELECTs_interpolated-4                       358ns ± 2%     235ns ± 1%   -34.34%  (p=0.008 n=5+5)
Union/Template-4                                     363ns ± 5%     235ns ± 1%   -35.33%  (p=0.008 n=5+5)
Union/Template_interpolated-4                        368ns ± 6%     236ns ± 0%   -35.83%  (p=0.016 n=5+4)
UpdateValuesSQL-4                                   1.22µs ± 0%    0.82µs ± 0%   -32.89%  (p=0.016 n=5+4)
ArgUnion/reflection_all_types-4                     2.97µs ± 3%    1.71µs ± 0%   -42.64%  (p=0.008 n=5+5)
ArgUnion/args_all_types-4                           1.28µs ± 1%    0.80µs ± 0%   -37.32%  (p=0.008 n=5+5)
ArgUnion/reflection_numbers-4                       4.23µs ± 3%    2.33µs ± 1%   -44.84%  (p=0.008 n=5+5)
ArgUnion/args_numbers-4                             1.26µs ± 2%    0.79µs ± 2%   -37.25%  (p=0.008 n=5+5)
Decimal_String/123456789-4                           157ns ± 2%      99ns ± 1%   -37.01%  (p=0.008 n=5+5)
Decimal_String/-123456789-4                          165ns ± 1%     103ns ± 1%   -37.70%  (p=0.008 n=5+5)
Decimal_String/12345.6789-4                          223ns ± 2%     167ns ± 2%   -25.16%  (p=0.008 n=5+5)
Decimal_String/-12345.6789-4                         230ns ± 1%     169ns ± 2%   -26.28%  (p=0.008 n=5+5)
Decimal_String/-Scale140-4                           389ns ± 1%     249ns ± 2%   -36.11%  (p=0.008 n=5+5)
Decimal_Binary/Marshal-4                            32.1ns ± 1%    21.7ns ± 1%   -32.31%  (p=0.008 n=5+5)
Decimal_Binary/Unmarshal-4                          5.60ns ± 1%    3.59ns ± 0%   -35.92%  (p=0.000 n=5+4)

name                                              old alloc/op   new alloc/op   delta
Interpolate-4                                         160B ± 0%      160B ± 0%      ~     (all equal)
IsValidIdentifier-4                                  0.00B          0.00B           ~     (all equal)
QuoteAlias-4                                         32.0B ± 0%     32.0B ± 0%      ~     (all equal)
Conditions_writeOnDuplicateKey-4                     0.00B          0.00B           ~     (all equal)
DialectEscapeTime-4                                  0.00B          0.00B           ~     (all equal)
ArgumentEncoding/all_types_without_warm_up-4        3.69kB ± 0%    3.69kB ± 0%      ~     (all equal)
ArgumentEncoding/all_types_with_warm_up-4             192B ± 0%      192B ± 0%      ~     (all equal)
ArgumentEncoding/number_slices_without_warm_up-4      992B ± 0%      992B ± 0%      ~     (all equal)
ArgumentEncoding/number_slices_with_warm_up-4        0.00B          0.00B           ~     (all equal)
ArgumentEncoding/numbers_without_warm_up-4            608B ± 0%      608B ± 0%      ~     (all equal)
ArgumentEncoding/numbers_with_warm_up-4              0.00B          0.00B           ~     (all equal)
Select_Rows-4                                       4.41kB ± 0%    4.34kB ± 0%    -1.45%  (p=0.008 n=5+5)
SelectBasicSQL-4                                    2.94kB ± 0%    2.86kB ± 0%    -2.72%  (p=0.008 n=5+5)
SelectFullSQL/NewSelect-4                           5.21kB ± 0%    5.11kB ± 0%    -1.84%  (p=0.008 n=5+5)
SelectFullSQL/ToSQL_Interpolate_NoCache-4           1.46kB ± 0%    1.36kB ± 0%    -6.59%  (p=0.008 n=5+5)
SelectFullSQL/ToSQL_Interpolate_Cache-4               288B ± 0%      288B ± 0%      ~     (all equal)
Select_Large_IN/SQL-4                               17.5kB ± 0%    17.5kB ± 0%    -0.36%  (p=0.008 n=5+5)
Select_Large_IN/interpolate-4                       15.6kB ± 0%    15.5kB ± 0%    -0.58%  (p=0.008 n=5+5)
Select_Large_IN/interpolate_named-4                 16.0kB ± 0%    15.9kB ± 0%    -0.47%  (p=0.008 n=5+5)
Select_ComplexAddColumns-4                          3.60kB ± 0%    3.54kB ± 0%    -1.78%  (p=0.008 n=5+5)
Select_SQLCase-4                                    4.32kB ± 0%    4.22kB ± 0%    -2.23%  (p=0.008 n=5+5)
DeleteSQL/NewDelete-4                               1.98kB ± 0%    1.92kB ± 0%    -3.23%  (p=0.008 n=5+5)
DeleteSQL/ToSQL_no_cache-4                          1.20kB ± 0%    1.14kB ± 0%    -5.33%  (p=0.008 n=5+5)
DeleteSQL/ToSQL_with_cache-4                         64.0B ± 0%     64.0B ± 0%      ~     (all equal)
InsertValuesSQL/NewInsert-4                         2.29kB ± 0%    2.22kB ± 0%    -2.80%  (p=0.008 n=5+5)
InsertValuesSQL/ToSQL_no_cache-4                    1.22kB ± 0%    1.15kB ± 0%    -5.26%  (p=0.008 n=5+5)
InsertValuesSQL/ToSQL_with_cache-4                   80.0B ± 0%     80.0B ± 0%      ~     (all equal)
InsertRecordsSQL-4                                  2.52kB ± 0%    2.46kB ± 0%    -2.54%  (p=0.008 n=5+5)
Repeat/multi-4                                        176B ± 0%      176B ± 0%      ~     (all equal)
Repeat/single-4                                      96.0B ± 0%     96.0B ± 0%      ~     (all equal)
QuoteAs-4                                            32.0B ± 0%     32.0B ± 0%      ~     (all equal)
QuoteQuote/Worse_Case-4                              96.0B ± 0%     96.0B ± 0%      ~     (all equal)
QuoteQuote/Best_Case-4                               32.0B ± 0%     32.0B ± 0%      ~     (all equal)
IfNull/3_args_expression_right-4                      192B ± 0%      192B ± 0%      ~     (all equal)
IfNull/3_args_no_qualifier-4                          208B ± 0%      208B ± 0%      ~     (all equal)
IfNull/3_args_with_qualifier-4                        208B ± 0%      208B ± 0%      ~     (all equal)
IfNull/4_args-4                                       208B ± 0%      208B ± 0%      ~     (all equal)
IfNull/5_args-4                                       208B ± 0%      208B ± 0%      ~     (all equal)
Union/5_SELECTs-4                                   1.28kB ± 0%    1.28kB ± 0%      ~     (all equal)
Union/5_SELECTs_interpolated-4                      1.28kB ± 0%    1.28kB ± 0%      ~     (all equal)
Union/Template-4                                    1.28kB ± 0%    1.28kB ± 0%      ~     (all equal)
Union/Template_interpolated-4                       1.28kB ± 0%    1.28kB ± 0%      ~     (all equal)
UpdateValuesSQL-4                                   2.06kB ± 0%    2.00kB ± 0%    -3.10%  (p=0.008 n=5+5)
ArgUnion/reflection_all_types-4                       672B ± 0%      672B ± 0%      ~     (all equal)
ArgUnion/args_all_types-4                             560B ± 0%      560B ± 0%      ~     (all equal)
ArgUnion/reflection_numbers-4                         984B ± 0%      984B ± 0%      ~     (all equal)
ArgUnion/args_numbers-4                               688B ± 0%      688B ± 0%      ~     (all equal)
Decimal_String/123456789-4                           16.0B ± 0%     16.0B ± 0%      ~     (all equal)
Decimal_String/-123456789-4                          16.0B ± 0%     16.0B ± 0%      ~     (all equal)
Decimal_String/12345.6789-4                          16.0B ± 0%     24.0B ± 0%   +50.00%  (p=0.008 n=5+5)
Decimal_String/-12345.6789-4                         16.0B ± 0%     24.0B ± 0%   +50.00%  (p=0.008 n=5+5)
Decimal_String/-Scale140-4                            288B ± 0%      288B ± 0%      ~     (all equal)
Decimal_Binary/Marshal-4                             16.0B ± 0%     16.0B ± 0%      ~     (all equal)
Decimal_Binary/Unmarshal-4                           0.00B          0.00B           ~     (all equal)

name                                              old allocs/op  new allocs/op  delta
Interpolate-4                                         1.00 ± 0%      1.00 ± 0%      ~     (all equal)
IsValidIdentifier-4                                   0.00           0.00           ~     (all equal)
QuoteAlias-4                                          1.00 ± 0%      1.00 ± 0%      ~     (all equal)
Conditions_writeOnDuplicateKey-4                      0.00           0.00           ~     (all equal)
DialectEscapeTime-4                                   0.00           0.00           ~     (all equal)
ArgumentEncoding/all_types_without_warm_up-4          90.0 ± 0%      90.0 ± 0%      ~     (all equal)
ArgumentEncoding/all_types_with_warm_up-4             4.00 ± 0%      4.00 ± 0%      ~     (all equal)
ArgumentEncoding/number_slices_without_warm_up-4      34.0 ± 0%      34.0 ± 0%      ~     (all equal)
ArgumentEncoding/number_slices_with_warm_up-4         0.00           0.00           ~     (all equal)
ArgumentEncoding/numbers_without_warm_up-4            18.0 ± 0%      18.0 ± 0%      ~     (all equal)
ArgumentEncoding/numbers_with_warm_up-4               0.00           0.00           ~     (all equal)
Select_Rows-4                                         12.0 ± 0%      12.0 ± 0%      ~     (all equal)
SelectBasicSQL-4                                      15.0 ± 0%      14.0 ± 0%    -6.67%  (p=0.008 n=5+5)
SelectFullSQL/NewSelect-4                             32.0 ± 0%      31.0 ± 0%    -3.12%  (p=0.008 n=5+5)
SelectFullSQL/ToSQL_Interpolate_NoCache-4             4.00 ± 0%      3.00 ± 0%   -25.00%  (p=0.008 n=5+5)
SelectFullSQL/ToSQL_Interpolate_Cache-4               1.00 ± 0%      1.00 ± 0%      ~     (all equal)
Select_Large_IN/SQL-4                                 16.0 ± 0%      16.0 ± 0%      ~     (all equal)
Select_Large_IN/interpolate-4                         15.0 ± 0%      15.0 ± 0%      ~     (all equal)
Select_Large_IN/interpolate_named-4                   22.0 ± 0%      22.0 ± 0%      ~     (all equal)
Select_ComplexAddColumns-4                            18.0 ± 0%      18.0 ± 0%      ~     (all equal)
Select_SQLCase-4                                      27.0 ± 0%      26.0 ± 0%    -3.70%  (p=0.008 n=5+5)
DeleteSQL/NewDelete-4                                 8.00 ± 0%      8.00 ± 0%      ~     (all equal)
DeleteSQL/ToSQL_no_cache-4                            3.00 ± 0%      3.00 ± 0%      ~     (all equal)
DeleteSQL/ToSQL_with_cache-4                          1.00 ± 0%      1.00 ± 0%      ~     (all equal)
InsertValuesSQL/NewInsert-4                           12.0 ± 0%      12.0 ± 0%      ~     (all equal)
InsertValuesSQL/ToSQL_no_cache-4                      3.00 ± 0%      3.00 ± 0%      ~     (all equal)
InsertValuesSQL/ToSQL_with_cache-4                    1.00 ± 0%      1.00 ± 0%      ~     (all equal)
InsertRecordsSQL-4                                    16.0 ± 0%      16.0 ± 0%      ~     (all equal)
Repeat/multi-4                                        2.00 ± 0%      2.00 ± 0%      ~     (all equal)
Repeat/single-4                                       2.00 ± 0%      2.00 ± 0%      ~     (all equal)
QuoteAs-4                                             1.00 ± 0%      1.00 ± 0%      ~     (all equal)
QuoteQuote/Worse_Case-4                               5.00 ± 0%      5.00 ± 0%      ~     (all equal)
QuoteQuote/Best_Case-4                                1.00 ± 0%      1.00 ± 0%      ~     (all equal)
IfNull/3_args_expression_right-4                      2.00 ± 0%      2.00 ± 0%      ~     (all equal)
IfNull/3_args_no_qualifier-4                          2.00 ± 0%      2.00 ± 0%      ~     (all equal)
IfNull/3_args_with_qualifier-4                        2.00 ± 0%      2.00 ± 0%      ~     (all equal)
IfNull/4_args-4                                       2.00 ± 0%      2.00 ± 0%      ~     (all equal)
IfNull/5_args-4                                       2.00 ± 0%      2.00 ± 0%      ~     (all equal)
Union/5_SELECTs-4                                     1.00 ± 0%      1.00 ± 0%      ~     (all equal)
Union/5_SELECTs_interpolated-4                        1.00 ± 0%      1.00 ± 0%      ~     (all equal)
Union/Template-4                                      1.00 ± 0%      1.00 ± 0%      ~     (all equal)
Union/Template_interpolated-4                         1.00 ± 0%      1.00 ± 0%      ~     (all equal)
UpdateValuesSQL-4                                     10.0 ± 0%      10.0 ± 0%      ~     (all equal)
ArgUnion/reflection_all_types-4                       44.0 ± 0%      44.0 ± 0%      ~     (all equal)
ArgUnion/args_all_types-4                             31.0 ± 0%      31.0 ± 0%      ~     (all equal)
ArgUnion/reflection_numbers-4                         78.0 ± 0%      78.0 ± 0%      ~     (all equal)
ArgUnion/args_numbers-4                               44.0 ± 0%      44.0 ± 0%      ~     (all equal)
Decimal_String/123456789-4                            1.00 ± 0%      1.00 ± 0%      ~     (all equal)
Decimal_String/-123456789-4                           1.00 ± 0%      1.00 ± 0%      ~     (all equal)
Decimal_String/12345.6789-4                           1.00 ± 0%      2.00 ± 0%  +100.00%  (p=0.008 n=5+5)
Decimal_String/-12345.6789-4                          1.00 ± 0%      2.00 ± 0%  +100.00%  (p=0.008 n=5+5)
Decimal_String/-Scale140-4                            2.00 ± 0%      2.00 ± 0%      ~     (all equal)
Decimal_Binary/Marshal-4                              1.00 ± 0%      1.00 ± 0%      ~     (all equal)
Decimal_Binary/Unmarshal-4                            0.00           0.00           ~     (all equal)

corestoreio/csfw,corestoreio/csfw