Opened 7 years ago
Closed 7 years ago
#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 7 years ago by abeham
- Status changed from new to accepted
comment:2 Changed 7 years ago by abeham
- Owner changed from abeham to ascheibe
- Status changed from accepted to reviewing
comment:3 Changed 7 years ago by ascheibe
- Owner changed from ascheibe to abeham
- Status changed from reviewing to readytorelease
Reviewed r13678, looks good.
comment:4 Changed 7 years ago by abeham
- Resolution set to done
- Status changed from readytorelease to closed
Note: See
TracTickets for help on using
tickets.
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.