Opened 13 years ago

Closed 13 years ago

#2589 closed patch (fixed)

Extra index on program.manualid improves scheduler performance

Reported by: Mark.Buechler@… Owned by: stuartm
Priority: trivial Milestone: 0.21
Component: mythtv Version: 0.20
Severity: low Keywords:
Cc: Ticket locked: no

Description

Small patch to increase performance on the big scheduler query. A rather slow query is sped up significally by this:

DELETE FROM program WHERE manualid = -1 OR (manualid <> 0 AND -1 = -1);

Attachments (1)

program_index.diff (993 bytes) - added by Mark.Buechler@… 13 years ago.
The sql patch..

Download all attachments as: .zip

Change History (3)

Changed 13 years ago by Mark.Buechler@…

Attachment: program_index.diff added

The sql patch..

comment:1 Changed 13 years ago by stuartm

Owner: changed from Isaac Richards to stuartm

comment:2 Changed 13 years ago by stuartm

Resolution: fixed
Status: newclosed

(In [11562]) Create an index on manualid in the program table, should speed up the scheduler query. Closes #2589

Note: See TracTickets for help on using tickets.