Opened 16 months ago

Closed 8 months ago

#2549 closed enhancement (done)

Optimize OKB Query Service

Reported by: ascheibe Owned by: abeham
Priority: medium Milestone: HeuristicLab 3.3.14
Component: Services.OKB.DataAccess Version: 3.3.13
Keywords: Cc:

Description

Because it's slow.

Attachments (1)

OKBTestScript.hl (1.6 KB) - added by ascheibe 15 months ago.

Download all attachments as: .zip

Change History (6)

comment:1 Changed 15 months ago by ascheibe

  • Status changed from new to accepted

Changed 15 months ago by ascheibe

comment:2 Changed 13 months ago by abeham

r13675: Added indexes to improve query performance

  • The queries from Run.Id to Value.RunId were missing an index on RunId
  • The queries from ValueName.Id to Value.ValueNameId were also missing an index on ValueNameId
  • Similar indexes were missing in CharacteristicValues

comment:3 Changed 13 months ago by abeham

  • Component changed from General to Services.OKB.DataAccess
  • Milestone changed from HeuristicLab 4.0 to HeuristicLab 3.3.14
  • Status changed from accepted to reviewing

comment:4 Changed 10 months ago by ascheibe

  • Owner changed from ascheibe to abeham
  • Status changed from reviewing to readytorelease

Reviewed r13675, looks good.

comment:5 Changed 8 months ago by abeham

  • Resolution set to done
  • Status changed from readytorelease to closed
  • Type changed from defect to enhancement

r14105: merged to stable

Note: See TracTickets for help on using tickets.