#2586 closed enhancement (done)

Reduce HIVE load on downloading jobs

Reported by: abeham Owned by: abeham
Priority: medium Milestone: HeuristicLab 3.3.14
Component: Hive.Server.DataAccess Version: 3.3.13
Keywords: Cc:

Description

An index on StateLog with TaskId can reduce load on the HIVE server when downloading jobs.

Change History (4)

comment:1 Changed 16 months ago by abeham

  • Status changed from new to accepted

comment:2 Changed 16 months ago by abeham

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

r13678: added an index on StateLog and updated the index on RequiredPlugins to include additional columns

We measured download times before and after adding the index, but a speed improvement was not observed. However the server load was greatly reduced.

@ASC: The present index on RequiredPlugins was not included in the Initialize Hive Database.sql script.

comment:3 Changed 13 months ago by ascheibe

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

Reviewed r13678, looks good.

comment:4 Changed 11 months ago by abeham

  • Resolution set to done
  • Status changed from readytorelease to closed

r14139: merged r13678 to stable

Note: See TracTickets for help on using tickets.