[SERVER-86386] De-duplicate calls to key_string::getKeySize while advancing through a unique index Created: 08/Feb/24  Updated: 08/Feb/24

Status: Needs Scheduling
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Major - P3
Reporter: Mark Benvenuto Assignee: Backlog - Storage Execution Team
Resolution: Unresolved Votes: 0
Labels: perf-tiger, perf-tiger-handoff
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File Screenshot 2024-02-07 at 9.58.03 PM.png    
Participants:

 Description   

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}

,


Generated at Thu Feb 08 07:00:09 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.