De-duplicate calls to key_string::getKeySize while advancing through a unique index

XMLWordPrintableJSON

    • Storage Execution
    • Execution Team 2024-02-19, Execution Team 2024-03-04, Execution Team 2024-03-18, Execution Team 2024-04-01
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      WiredTigerIndexCursorBase::nextKeyString calls
      1. WiredTigerIndexCursorBase::advanceNext() -> WiredTigerIndexUniqueCursor::updateIdAndTypeBits() -> key_string::getKeySize
      2. WiredTigerIndexCursorBase::getKeyStringEntry() -> key_string::getKeySize

      Seen in TPCC Payment query. Have not measured the performance impact.

      {"find":"CUSTOMER","filter":

      {"C_W_ID":1,"C_D_ID":3,"$comment":"PAYMENT","C_LAST":"PRIABLEEING"}

      ,
      "projection":

      {"C_BALANCE":0,"C_YTD_PAYMENT":0,"C_PAYMENT_CNT":0}

      ,

        1. Screenshot 2024-02-07 at 9.58.03 PM.png
          Screenshot 2024-02-07 at 9.58.03 PM.png
          156 kB

              Assignee:
              Wei Hu
              Reporter:
              Mark Benvenuto
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: