Opened 13 years ago

Closed 12 years ago

#3081 closed patch (wontfix)

optimization of scheduler query: progfindid is functionally dependend on recordmatch only

Reported by: usleepless@… 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)

scheduler.diff (2.3 KB) - added by anonymous 13 years ago.

Download all attachments as: .zip

Change History (3)

Changed 13 years ago by anonymous

Attachment: scheduler.diff added

comment:1 Changed 12 years ago by stuartm

Component: mythtvscheduler
Owner: changed from Isaac Richards to bjm

comment:2 Changed 12 years ago by gigem

Resolution: wontfix
Status: newclosed

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.

Note: See TracTickets for help on using tickets.