Opened 17 years ago

Closed 16 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 17 years ago.

Download all attachments as: .zip

Change History (3)

Changed 17 years ago by anonymous

Attachment: scheduler.diff​ added

comment:1 Changed 16 years ago by stuartm

Component: mythtv → scheduler
Owner: changed from Isaac Richards to bjm

comment:2 Changed 16 years ago by gigem

Resolution: → wontfix
Status: new → closed

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.