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: issues-unsubscr...@lucene.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@lucene.apache.org For additional commands, e-mail: issues-h...@lucene.apache.org