jpountz commented on PR #14701:
URL: https://github.com/apache/lucene/pull/14701#issuecomment-2900931305
Filtered queries get a slowdown, but some important queries get a big
speedup:
```
TaskQPS baseline StdDevQPS
my_modified_version StdDev Pct diff p-value
FilteredAndHighHigh 65.66 (1.9%) 59.10
(4.6%) -10.0% ( -16% - -3%) 0.000
FilteredAndStopWords 45.10 (2.4%) 41.04
(3.9%) -9.0% ( -14% - -2%) 0.000
FilteredAnd3Terms 181.24 (1.7%) 165.29
(3.2%) -8.8% ( -13% - -3%) 0.000
FilteredAnd2Terms2StopWords 178.47 (1.3%) 162.78
(2.9%) -8.8% ( -12% - -4%) 0.000
Fuzzy1 102.41 (2.9%) 98.67
(3.2%) -3.6% ( -9% - 2%) 0.000
FilteredOrStopWords 46.85 (1.6%) 45.27
(2.5%) -3.4% ( -7% - 0%) 0.000
FilteredOrHighHigh 68.45 (0.9%) 66.49
(1.9%) -2.9% ( -5% - 0%) 0.000
Fuzzy2 85.94 (2.6%) 83.58
(2.8%) -2.7% ( -7% - 2%) 0.002
OrHighRare 291.53 (3.3%) 283.82
(6.1%) -2.6% ( -11% - 6%) 0.096
FilteredAndHighMed 126.38 (2.6%) 123.62
(5.5%) -2.2% ( -10% - 6%) 0.119
DismaxTerm 486.16 (2.2%) 478.90
(3.2%) -1.5% ( -6% - 3%) 0.089
FilteredOrHighMed 153.91 (0.8%) 151.71
(1.3%) -1.4% ( -3% - 0%) 0.000
FilteredOr2Terms2StopWords 148.64 (1.1%) 146.57
(1.5%) -1.4% ( -3% - 1%) 0.001
CombinedAndHighHigh 11.47 (2.6%) 11.33
(2.3%) -1.2% ( -5% - 3%) 0.132
FilteredOr3Terms 167.24 (1.1%) 165.61
(1.6%) -1.0% ( -3% - 1%) 0.030
Wildcard 94.57 (2.8%) 93.67
(2.7%) -1.0% ( -6% - 4%) 0.281
CombinedOrHighHigh 18.94 (1.8%) 18.80
(2.1%) -0.7% ( -4% - 3%) 0.243
Term 439.45 (3.6%) 436.34
(4.5%) -0.7% ( -8% - 7%) 0.595
TermDTSort 389.67 (4.7%) 386.92
(4.8%) -0.7% ( -9% - 9%) 0.647
FilteredTerm 159.78 (1.6%) 158.69
(2.3%) -0.7% ( -4% - 3%) 0.282
AndHighOrMedMed 46.65 (1.1%) 46.40
(1.8%) -0.5% ( -3% - 2%) 0.267
PKLookup 320.16 (4.3%) 318.93
(4.7%) -0.4% ( -8% - 8%) 0.791
FilteredPrefix3 154.48 (2.3%) 154.23
(2.6%) -0.2% ( -4% - 4%) 0.840
Phrase 14.34 (2.2%) 14.32
(2.3%) -0.1% ( -4% - 4%) 0.858
IntNRQ 309.51 (0.8%) 309.13
(0.9%) -0.1% ( -1% - 1%) 0.641
Prefix3 163.72 (2.3%) 163.54
(2.7%) -0.1% ( -4% - 4%) 0.893
CountAndHighMed 312.21 (1.2%) 312.08
(1.6%) -0.0% ( -2% - 2%) 0.929
IntervalsOrdered 2.29 (2.9%) 2.29
(2.5%) 0.1% ( -5% - 5%) 0.919
FilteredIntNRQ 301.55 (1.0%) 301.84
(0.9%) 0.1% ( -1% - 2%) 0.760
CountFilteredOrMany 27.46 (1.0%) 27.50
(1.3%) 0.1% ( -2% - 2%) 0.754
CountFilteredOrHighMed 148.19 (0.7%) 148.39
(0.6%) 0.1% ( -1% - 1%) 0.509
CountOrMany 30.46 (1.5%) 30.52
(1.5%) 0.2% ( -2% - 3%) 0.712
CountTerm 8687.88 (2.8%) 8708.11
(4.5%) 0.2% ( -6% - 7%) 0.850
CountFilteredOrHighHigh 136.50 (0.7%) 136.90
(0.6%) 0.3% ( -1% - 1%) 0.178
CountAndHighHigh 359.19 (1.7%) 360.43
(1.6%) 0.3% ( -2% - 3%) 0.520
CountOrHighMed 366.72 (1.5%) 368.05
(1.8%) 0.4% ( -2% - 3%) 0.486
CombinedTerm 30.67 (3.5%) 30.78
(4.0%) 0.4% ( -6% - 8%) 0.751
CountOrHighHigh 346.98 (1.1%) 348.48
(1.5%) 0.4% ( -2% - 3%) 0.304
FilteredPhrase 32.93 (1.8%) 33.07
(1.5%) 0.4% ( -2% - 3%) 0.413
CountFilteredPhrase 25.29 (3.2%) 25.50
(2.5%) 0.8% ( -4% - 6%) 0.377
TermTitleSort 85.82 (10.1%) 86.55
(7.5%) 0.9% ( -15% - 20%) 0.767
TermMonthSort 3181.64 (2.9%) 3213.86
(2.2%) 1.0% ( -3% - 6%) 0.227
FilteredOrMany 16.50 (2.7%) 16.67
(2.5%) 1.0% ( -4% - 6%) 0.221
CountPhrase 4.15 (3.2%) 4.20
(2.0%) 1.3% ( -3% - 6%) 0.137
TermDayOfYearSort 283.82 (3.8%) 287.84
(1.8%) 1.4% ( -4% - 7%) 0.146
CombinedOrHighMed 72.56 (2.4%) 73.69
(1.8%) 1.6% ( -2% - 5%) 0.024
OrMany 20.45 (5.3%) 21.05
(6.0%) 2.9% ( -8% - 15%) 0.114
CombinedAndHighMed 38.55 (2.3%) 39.92
(2.2%) 3.6% ( 0% - 8%) 0.000
DismaxOrHighHigh 118.14 (2.1%) 122.80
(4.3%) 3.9% ( -2% - 10%) 0.000
DismaxOrHighMed 173.28 (2.3%) 183.27
(2.2%) 5.8% ( 1% - 10%) 0.000
Or3Terms 165.74 (5.5%) 197.36
(7.9%) 19.1% ( 5% - 34%) 0.000
And3Terms 172.23 (4.2%) 205.61
(7.9%) 19.4% ( 7% - 32%) 0.000
Or2Terms2StopWords 159.77 (5.6%) 191.42
(6.9%) 19.8% ( 6% - 34%) 0.000
And2Terms2StopWords 161.65 (4.1%) 194.38
(7.1%) 20.2% ( 8% - 32%) 0.000
AndMedOrHighHigh 65.43 (2.8%) 79.68
(2.7%) 21.8% ( 15% - 28%) 0.000
AndStopWords 29.75 (6.7%) 36.45
(12.7%) 22.5% ( 2% - 44%) 0.000
OrStopWords 32.42 (9.6%) 39.95
(13.0%) 23.2% ( 0% - 50%) 0.000
OrHighMed 192.11 (4.0%) 244.47
(2.7%) 27.3% ( 19% - 35%) 0.000
OrHighHigh 51.75 (4.9%) 66.11
(9.2%) 27.8% ( 13% - 44%) 0.000
AndHighHigh 43.14 (1.5%) 56.30
(11.8%) 30.5% ( 16% - 44%) 0.000
AndHighMed 135.13 (0.9%) 183.67
(4.2%) 35.9% ( 30% - 41%) 0.000
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
