Opened 19 years ago
Closed 18 years ago
#3081 closed patch (wontfix)
optimization of scheduler query: progfindid is functionally dependend on recordmatch only
| Reported by: | Owned by: | bjm | |
|---|---|---|---|
| Priority: | minor | Milestone: | unknown |
| Component: | scheduler | Version: | head |
| Severity: | medium | Keywords: | |
| Cc: | Ticket locked: | no |
Description
do:
alter table recordmatch add progfindid int; create index idx_recordmatch_progfinid on recordmatch(progfindid);
Attachments (1)
Change History (3)
by , 19 years ago
| Attachment: | scheduler.diff added |
|---|
comment:1 by , 18 years ago
| Component: | mythtv → scheduler |
|---|---|
| Owner: | changed from to |
comment:2 by , 18 years ago
| Resolution: | → wontfix |
|---|---|
| Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
In my testing, any improvements from this change were negligible. If/when other scheduler restructuring is done, this change might be incorproated. For now, it's not worth doing.