Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-71038

Investigate LLT mixed regressions

    • Type: Icon: Task Task
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Execution
    • Fully Compatible
    • QE 2023-05-15, QE 2023-05-29, QE 2023-06-12, QE 2023-06-26, QE 2023-07-10, QE 2023-07-24, QE 2023-08-07, QE 2023-08-21, QE 2023-09-04, QE 2023-09-18, QE 2023-10-02, QE 2023-10-16, QE 2023-10-30, QE 2023-11-13, QE 2023-11-27, QE 2023-12-11, QE 2023-12-25, QE 2024-01-08, QE 2024-01-22, QE 2024-02-05, QE 2024-02-19, QE 2024-03-04, QE 2024-03-18, QE 2024-04-01, QE 2024-04-15, QE 2024-04-29, QE 2024-05-13, QE 2024-05-27, QE 2024-06-10, QE 2024-06-24, QE 2024-07-08, QE 2024-07-22, QE 2024-08-05, QE 2024-08-19, QE 2024-09-02, QE 2024-09-16, QE 2024-09-30, QE 2024-10-14, QE 2024-10-28, QE 2024-11-11, QE 2024-11-25, QE 2024-12-09
    • 35
    • 10

      Long.Query.Baseline.findOne -30.18878612
      Long.Query.Benchmark.findOne -22.61465156
      llt_mixed Medium.Query.Baseline.findOne -24.30839036
      llt_mixed Medium.Query.Benchmark.findOne -24.05129074
      llt_mixed Short.Query.Baseline.findOne -19.7895922
      llt_mixed Short.Query.Benchmark.findOne -26.9140599
       

      Oddly enough I feel that this shouldn't be an issue because it's a findOne query, but it's not clear what the predicate is.

        1. SBE_without_hints.svg
          7.30 MB
        2. SBE_short_benchmark.svg
          10.52 MB
        3. classic_without_hints.svg
          8.26 MB
        4. classic_short_benchmark.svg
          7.64 MB

            Assignee:
            backlog-query-execution [DO NOT USE] Backlog - Query Execution
            Reporter:
            mihai.andrei@mongodb.com Mihai Andrei
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated: