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

      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}

      ,

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

              Created:
              Updated:
              Resolved: